Etl Developer

Role & responsibilities

Looking for Immediate joiner.

Key Responsibilities

Design and develop ETL/data migration workflows using Informatica PowerCenter and Informatica IDMC.
Build data extraction, transformation, cleansing, reconciliation, and loading processes for large-scale migration programs.
Perform data profiling, quality assessments, and reconciliation to ensure migration accuracy.
Develop and optimize SQL/PL-SQL scripts and database integrations (Oracle, SQL Server, DB2).
Collaborate with Business Analysts and Architects to implement data mapping requirements.
Troubleshoot ETL performance issues and support SIT, UAT, and production cutovers.
Maintain ETL documentation, data lineage, and migration reports.
Participate in Agile delivery, code reviews, and release activities.
Hands-on experience with IDMC Administration and Powercenter Administration
Hand-on experience with CD-CI pipeline (preferably Codeak)
Hand-on experience with Scheduling tool (preferably AWA).
Experience in Environment maintenance and migration activities and processes.

Required Skills

710+ years of ETL development experience.
Strong expertise in Informatica PowerCenter & Informatica Cloud (IDMC).
Hands-on experience with IDMC Administration and Powercenter Administration
Hand-on experience with CD-CI pipeline (preferably Codeak)
Hand-on experience with Scheduling tool (preferably AWA).
Experience in Environment maintenance and migration activities and processes.
Hands-on experience in SQL, PL/SQL, Oracle, SQL Server, DB2.
Knowledge of Data Profiling, Data Quality, Reconciliation, CDC, and Metadata Management.
Experience with Git, CI/CD, and DevOps practices.
Exposure to AWS/Azure is preferred.

Preferred candidate profile