EY - GDS Consulting - AI And DATA - Informatica PowerCenter - Senior
EY
At EY, we’re all in to shape your future with confidence.
We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.
Join EY and help to build a better working world.
EY-Advisory - Data and Analytics – Senior ETL Developer (Informatica PowerCenter & Talend)
EY's 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
- 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, you’ll 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, 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 is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.
Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.
EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.