ETL Developer – Informatica PowerCenter & IDMC

About the role

We are seeking an experienced ETL Developer with deep expertise in Informatica PowerCenter and Informatica IDMC to design, develop, and maintain robust data integration workflows for our data warehouse environment.

Key responsibilities

• Design and develop Informatica mappings and ETL workflows.
• Build complex data flows and data‑quality solutions using IDMC.
• Perform testing, debugging, performance tuning, and optimization.
• Analyze and resolve ETL and data integration issues.
• Prepare and maintain technical documentation for all ETL processes.
• Collaborate with data and technical teams to ensure smooth operations.
• Support users, provide guidance on new or updated workflows, and ensure compliance with data‑governance standards.
• Assist with Informatica upgrades, installations, and ongoing maintenance.

Required profile

• Minimum 5 years of hands‑on experience in ETL development.
• Strong expertise in Informatica PowerCenter and Informatica IDMC.
• Proven ability to design, develop, and optimize large‑scale data integration solutions.

Required skills

• Informatica PowerCenter
• Informatica IDMC
• ETL Development & Data Integration
• Advanced SQL & Database Optimization
• Java, Java Transformation & Custom Transformation
• Performance Tuning, Partitioning & Pushdown Optimization
• Data Warehousing & Database Concepts
• APIs, Web Services & Connectors
• Data Quality & Data Governance