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

Core Competencies

Role fit
Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and developing ETL processes using PowerCenter and IDMC, with strong proficiency in SQL, PL/SQL, and performance tuning. Capable of leading teams, providing technical mentorship, and ensuring best practices in data extraction and transformation.

Highest-signal resume keywords
ETL DevelopmentInformatica Cloud (IICS)SQL Performance TuningData MigrationTeam Leadership

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
PowerCenterIDMCSQLPL/SQLStored ProceduresOracleSQL ServerDB2IDMSData Modelling
Soft Skills
Client ManagementTechnical Mentorship
Tools & Technologies
DevOpsCI/CDGitlab
Industry Keywords
Data ExtractionData TransformationETL ProcessesWorkflowsMigration Engine

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