Apply

Ready to go for it?

AI Apply speeds things up—apply directly if you prefer.

FREE ACCESS
5,000–10,000 jobs/day
JobTailor Logo

See all jobs on JobTailor

Search thousands of fresh jobs every day.

Discover
  • Fresh listings
  • Fast filters
  • No subscription required
Create a free account and start exploring right away.
EY

Senior Consultant – AI and Data, Informatica IDMC

EY

Senior role in EY's Data and Analytics team designing and developing ETL processes with Informatica. Leading a team and collaborating with various stakeholders in the business.

Posted 7/11/2026full-timeChennai • 🇮🇳 IndiaSeniorWebsite

Tech Stack

Tools & technologies
CloudETLInformaticaOracleSQL

About the role

Key responsibilities & impact
  • 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.

Requirements

What you’ll need
  • 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
  • Client management skills

Benefits

Comp & perks
  • Support, coaching and feedback from some of the most engaging colleagues around
  • Opportunities to develop new skills and progress your career
  • The freedom and flexibility to handle your role in a way that’s right for you

ATS Keywords

✓ Tailor your resume
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PowerCenterIDMCSQLPL/SQLStored ProceduresOracleSQL ServerDB2IDMSData Modelling
Soft Skills
Client ManagementTechnical Mentorship