Senior AWS Databricks Consultant

EY; Chennai District; On-site; INR 1,800,000 - 3,400,000; Full time

Job summary

EY invites you to advance data and analytics initiatives with a Senior role focused on Informatica PowerCenter and IDMC. You will design, develop, and optimize ETL processes and lead a team of ETL developers and data engineers across complex data migrations.

You will collaborate with analysts, data architects, and DBAs while ensuring best practices, performance tuning, and adherence to security standards in enterprise-scale projects.

Qualifications

• 5-7 years of experience in ETL and data integration.
• Strong SQL/PLSQL, Oracle, SQL Server, DB2.
• Proficiency with Informatica PowerCenter and IDMC.
• Experience with Informatica Cloud (IICS).
• Knowledge of DevOps practices and CI/CD with Gitlab.

Responsibilities

• Design and develop ETL processes using PowerCenter and IDMC.
• Lead migration engine design, coding, testing, and deployment.
• Oversee ETL jobs, workflows, mappings in IDMC.
• Mentor ETL developers, data engineers, and analysts.
• Collaborate with analysts, architects, and DBAs.
• Monitor and tune Informatica workflows for performance.
• Maintain migration process documentation.
• Troubleshoot ETL failures and data discrepancies.
• Set up PowerCenter and PowerCenter Navigator.

Skills

PowerCenter

IDMC

Informatica Cloud (IICS)

SQL/PLSQL

DevOps (CI/CD)

Data migration

Oracle/SQL Server/DB2

Mainframe IDMS

ETL development

Education

Bachelor's degree in Computer Science or related field

Tools

Gitlab

CI/CD

PowerCenter tools

IDMC tooling

Job description

Job Summary

At EY, youll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And were counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

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

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-7 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.