EY - GDS Consulting - AI And DATA - Informatica Cloud - Senior
EY · Chennai, Tamil Nadu, India
- On site
- Full-time
- $120,000 / year
- Chennai, Tamil Nadu, India
Job highlights
- Design and develop ETL processes using Informatica Cloud.
- Lead a team of data engineers and analysts.
- Collaborate with business analysts and architects.
- Mentor team members and enforce best practices.
- Monitor and optimize Informatica workflows for performance.
About the role
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
Skills & topics
- Informatica Cloud
- Senior Consultant
- Data and Analytics
- ETL
- Data Migration
- PowerCenter
- SQL
- PL/SQL
- Cloud Data Migration
- EY
How to get hired
- Tailor your resume: Highlight your Informatica Cloud expertise, ETL experience, and leadership skills relevant to this Senior Consultant role.
- Craft a compelling application: Emphasize your problem-solving abilities and experience with structured/semi-structured data.
- Prepare for technical questions: Be ready to discuss SQL, PL/SQL, data modeling, and cloud data migration scenarios.
- Showcase leadership potential: Prepare examples of mentoring junior team members and enforcing development best practices.
- Research EY's values: Understand EY's commitment to building a better working world and their focus on client success.
Technical preparation
Behavioral questions
Frequently asked questions
- What are the primary responsibilities of an Informatica Cloud Senior Consultant at EY?
- As an Informatica Cloud Senior Consultant at EY, you will be responsible for designing and developing ETL processes using Informatica Cloud (IICS), leading a team of data engineers, mentoring team members, collaborating with business analysts and architects, and ensuring high performance of Informatica workflows.
- What technical skills are essential for this Senior Consultant role at EY?
- Essential technical skills include expertise in Informatica Cloud (IICS), PowerCenter, ETL development, strong SQL and PL/SQL proficiency, experience with Oracle, SQL Server, DB2, and IDMS, as well as knowledge of database design and data modeling.
- Does EY offer opportunities for professional development for Senior Consultants?
- Yes, EY emphasizes education and coaching alongside practical experience for personal development. They offer an individual progression plan, opportunities to develop new skills, and a chance to grow into responsible roles with challenging assignments.
- What kind of projects can I expect to work on as an Informatica Cloud Senior Consultant at EY?
- You can expect to work on inspiring and meaningful projects helping clients solve complex business challenges using data and technology across various industries like Banking, Insurance, Manufacturing, Healthcare, and Finance. This includes data migration and transformation initiatives.
- What is the expected experience level for the Informatica Cloud Senior Consultant position at EY?
- The role requires 4 to 7 years of relevant experience in handling structured and semi-structured data, with a strong focus on Informatica Cloud and ETL development.
- How does EY foster an inclusive culture for its employees?
- EY aims to build a career as unique as you are, emphasizing a global scale, supportive and inclusive culture, and providing the technology to help employees become the best version of themselves. They value unique voices and perspectives.
- What are the benefits of working in the EY-GDS D&A team?
- Working in the EY-GDS D&A team allows you to solve complex business challenges with data and technology, dive deep into data to extract value, and discover opportunities in key business functions across various industries.
- Is experience with cloud data migration required for this role at EY?
- Yes, expertise with Informatica Cloud (IICS) and cloud data migration is a key requirement for this Senior Consultant position.