Informatica Developer

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

Job summary

EY is seeking a Senior Informatica Specialist in Chennai for EY-GDS to lead ETL design and migration using PowerCenter and IDMC. The role involves mentoring a team of ETL developers and collaborating with data architects and DBAs to ensure high-performance data workflows.

Ideal candidates have 5–8 years of experience with Oracle, SQL Server, DB2, and IDMS, plus strong SQL/PLSQL and cloud migration expertise. Banking domain knowledge is a plus.

Qualifications

• Experience designing and delivering ETL using PowerCenter and IDMC.
• Strong SQL/PLSQL and performance tuning skills.
• Proficiency with Oracle, SQL Server, DB2, and mainframe IDMS.
• In-depth knowledge of Informatica Cloud (IICS) and cloud data migration.
• Familiarity with DevOps practices and GitLab.
• Solid understanding of data modeling and data architecture.

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

ETL development

IDMC

Informatica Cloud

SQL/PLSQL

DevOps CI/CD

Data modeling

Data migration

Architectural principles

DB2

Oracle

Client management

Tools

PowerCenter

PowerCenter Navigator

IDMC

IICS

GitLab

CI/CD

Job description

Job Title: EY-GDS Consulting-AI And DATA-Informatica IDMC-Senior

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, youll also have

• Client management skills