EY GDS Consulting AI And DATA Informatica PowerCenter Senior

EY-Advisory - Data and Analytics Senior ETL Developer (Informatica PowerCenter & Talend)

EYs Advisory Services is a unique industry-focused business unit that provides a broad range of integrated services that leverage deep industry experience with strong functional and technical capabilities and product knowledge. EYs financial services practice provides integrated advisory services to financial institutions and other capital markets participants including commercial banks retail banks investment banks broker-dealers & asset management firms and insurance firms from leading Fortune 500 Companies. Within EYs Advisory Practice Data and Analytics team solves big complex issues and capitalize on opportunities to deliver better working outcomes that help expand and safeguard the businesses now and in the future. This way we help create a compelling business case for embedding the right analytical practice at the heart of clients decision-making.

The opportunity

We are looking for an experienced ETL professional with strong expertise in Informatica PowerCenter and Talend to design develop and maintain robust data integration solutions. The ideal candidate will have a deep understanding of ETL processes data warehousing concepts and performance optimization techniques.

Your key responsibilities

• Design develop and implement ETL workflows using Informatica PowerCenter and Talend.
• Collaborate with business analysts and data architects to understand requirements and deliver scalable solutions.
• Perform data extraction transformation and loading from multiple sources into target systems.
• Optimize ETL jobs for performance and reliability.
• Ensure data quality integrity and compliance with organizational standards.
• Troubleshoot and resolve ETL issues in production and non-production environments.
• Document ETL processes mappings and workflows for maintainability.
• Ensure continual knowledge management and contribute to internal learning and development teams
• Building a quality culture.

Skills and attributes for success

• 3 7 years of hands-on experience in ETL development with Informatica PowerCenter and Talend.
• Strong knowledge of SQL and relational databases (Oracle SQL Server etc.).
• Solid understanding of data warehousing concepts data modeling and performance tuning.
• Experience in handling large datasets and complex transformations.
• Familiarity with job scheduling tools and version control systems.
• Excellent problem-solving and communication skills.

To qualify for the role you must have

• BE/BTech/MCA/MBA
• In-depth understanding of data management and data migration concepts.
• Experience of working in minimum one Insurance domain projects with strong experience of data analysis profiling.
• Very good understanding of the concepts and technology around data extraction data migration data transformation data load data profiling data quality management and metadata management.
• More than one year of experience on ETL and Data migration/warehouse projects
• Good communication skills proven ability and commitment to working collaboratively towards common goal.
• Possess effective planning and problem-solving skills.
• Multi-tasking attitude equally comfortable operating from within both the technology & business environments.
• Focused on a quality outcome excellent inter-personal skills and highly motivated.
• Business Rule Analysis and Design experience.
• knowledge on Data Modelling and UNIX/Shell scripting experience

Ideally youll also have

Worked on at least one end to end migration project.

Understanding of Business Intelligence Data Warehousing and Master Data Management.

What we look for

• A Team of people with commercial acumen technical experience and enthusiasm to learn new things in this fast-moving environment
• An opportunity to be a part of market-leading multi-disciplinary team of 1400 professionals in the only integrated global transaction business worldwide.
• Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries

What working at EY offers

At EY were dedicated to helping our clients from startups 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 thats right for you