Senior AWS Databricks Consultant

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.
• Familiarity with Agile methodology

Ideally, youll also have

• Client management skills

What we look for

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