RQ10584 - Software Developer - ETL - Senior

Key Responsibilities :

• Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud ( IDMC).
• Migrate Informatica PowerCentre v10.2 ETL code including embedded SQL and PL / SQL code developed using Oracle 11g and 19c
• Test migrated embedded SQL code and PL / SQL based Stored Procedures.
• Performance-tune and optimize SQL queries and PL / SQL code for performance and scalability.
• Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery to achieve optimum baseline-based performance
• Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses (star / snowflake schemas).
• Translate technical specifications into fully tested applications and data pipelines.
• Collaborate with vendor and entire project team for unit testing, debugging, and validation of ETL processes.
• Document technical designs, deployment guides, and support materials.
• Participate in Agile / Scrum development cycles and iterative delivery.
• Ensure compliance with data governance, security, and access control policies.
• Provide post-implementation support and participate in knowledge transfer sessions.
• Provide database administration including configuration, backup / recovery, user roles, database

Requirements

Experience and Skill Set Requirements :

Must Haves :

Skill Set Requirements :

Desirable Skills :

ETL Expertise :

Informatica Experience :

Problem-Solving and Decision-Making :

Collaboration & Communication :

OPS Experience :