Informatica Cloud Senior Consultant

EY - GDS Consulting - AI And DATA - Informatica Cloud - Senior Consultant

At EY, you’ll 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 we’re 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 Cloud - Senior Consultant

As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.

Key Responsibilities:

• Design and develop data extraction using PowerCenter.
• Design and develop data transformation, and loading (ETL) processes using IDMC.
• 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.
• 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 modeling.
• Years – 4 to 7 years of relevant experience.

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.
• Client management skills.

What We Look For:

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

What Working At EY Offers:

At EY, we’re dedicated to helping our clients, from start-ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

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

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

Key skills/competency:

• Informatica Cloud
• ETL Development
• Data Migration
• SQL
• PL/SQL
• Data Transformation
• PowerCenter
• Database Design
• Data Modeling
• DevOps