EY-Advisory -
Data and Analytics -
Staff 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. EY s 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 EY s 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 client s 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
- 1 - 3 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, you ll also have
- Worked on at least one end to end migration project.
- Understanding of Business Intelligence, Data Warehousing and Master Data Management.
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.
