Senior Informatica IDMC Consultant

EY; Chennai District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

EY GDS - Data & Analytics team seeks a Senior Informatica PowerCenter and IDMC specialist. You will design, develop, and optimize ETL migrations, lead the ETL team, and collaborate with data architects and DBAs to deliver high-performance data pipelines on cloud and on-premise platforms.

Ideal candidates bring 5-8 years of experience, strong SQL/PLSQL skills, and expertise in Informatica Cloud (IICS) with cloud data migration.

Qualifications

• 5-8 years of experience in ETL/data integration
• Experience with Informatica PowerCenter and IDMC
• Proficiency in SQL, PL/SQL and performance tuning
• Knowledge of Oracle, SQL Server, DB2 and mainframe IDMS
• Experience with Informatica Cloud (IICS) and cloud data migration
• Familiarity with DevOps practices (CI/CD, Gitlab)
• Understanding of data modelling and database design

Responsibilities

• Design and develop data extraction using PowerCenter.
• Design and develop data transformation and loading (ETL) processes using IDMC.
• Lead and contribute in design, coding, testing, and deployment of migration engine.
• Oversee ETL jobs, workflows, and mappings in IDMC.
• Lead a team of ETL developers, data engineers, and analysts.
• Mentor team and enforce ETL best practices.

Skills

ETL development

SQL/PLSQL

Informatica PowerCenter

IDMC / IICS

Cloud data migration

DevOps (CI/CD)

Data modelling

Mentorship

Tools

Informatica PowerCenter

IDMC

Informatica Cloud (IICS)

Gitlab

CI/CD tooling

Oracle

SQL Server

DB2

IDMS

Job description

Job Summary

As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.

Role

EY- GDS - Data and Analytics Informatica PowerCenter and IDMC - Senior

Key responsibilities

• Design and develop data extraction using PowerCenter.
• Design and develop data transformation, and loading (ETL) processes using IDMC
• Is aware of setting up of PowerCenter, PowerCenter navigator.
• Lead and contribute in design, coding, testing, and deployment of the migration engine.
• Oversee the development of ETL jobs, workflows, and mappings in IDMC.
• Lead a team of ETL developers, data engineers, and analysts.
• Work closely with business analysts, data architects, and database administrators.
• Provide technical mentorship and enforce best practices in ETL development.
• Monitor and tune Informatica workflows for high performance.
• Troubleshoot ETL job failures and data discrepancies.
• Maintain technical documentation for all migration processes.

Skills and Experience

• Experience in handling structured and semi-structured data
• Should be having 5-8 years of Experience
• Strong knowledge of Oracle, SQL Server, DB2 and IDMS (mainframe)
• Proficiency in SQL, PL/SQL, stored procedures, and performance tuning.
• Expertise with Informatica Cloud (IICS) and cloud data migration.
• Familiarity with DevOps practices and tools (e.g., CI/CD, Gitlab)
• Deep understanding of architectural principles, frameworks, and best practices
• Knowledge of database design and data modelling

Nice to Have

• Banking domain knowledge (Core Banking).
• Familiarity with Data migration process in a banking implementation project.
• Experience with data masking, encryption, and security compliance.
• Knowledge of virtualization technologies and storage architectures.
• Familiarity with Agile methodology

Ideally, you’ll also have

• Client management skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment