Senior IDMC ETL Developer

We are seeking an experienced Senior ETL Developer with deep expertise in Informatica Intelligent Data Management Cloud (IDMC/IICS) to join our data migration and integration team. The ideal candidate will lead data migration projects from legacy mainframe systems to modern cloud-based platforms, ensuring high-quality, efficient, and secure data integration workflows.

Roles and Responsibilities

• Design, develop, and implement data integration workflows and mappings using IDMC/IICS.

• Lead data migration projects from mainframe sources to PostgreSQL databases in the cloud.

• Collaborate with data architects, analysts, and stakeholders to understand data requirements and objectives.

• Maintain, support, and optimize existing ETL/data integration solutions.

• Implement and enforce data quality, data governance, and security policies.

• Troubleshoot and resolve data integration issues promptly.

• Document integration processes, mappings, and workflows for transparency and knowledge sharing.

• Ensure data accuracy, integrity, and consistency across all systems.

Required Technical/Functional Skills

• 10+ years of experience in ETL/Informatics and IDMC/IICS.

• Strong experience in data migration projects, particularly from mainframes to cloud-based databases (PostgreSQL preferred).

• Hands-on expertise in designing and developing complex data workflows and mappings.

• Understanding of data governance, data quality, and performance optimization in ETL processes.

• Familiarity with cloud data platforms and architecture patterns.

Managerial and Soft Skills

• Strong analytical, problem-solving, and communication skills.

• High ownership mindset with proactive issue resolution.

• Solid understanding of software architecture and design patterns.

• Experience working in Agile/Scrum delivery environments.

• Ability to mentor junior team members and collaborate with cross-functional teams.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.

• Prior experience in enterprise or BFSI (Banking, Financial Services, Insurance) projects preferred.

Posted By