Senior Data Engineer

Senior Data Engineer

Location: Bengaluru/Chennai

Experience: 8+ Years

About Us

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery. 

WHY JOIN CAPCO?

You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

MAKE AN IMPACT

Job Description:

We are hiring a Senior Consultant to support data migration and ETL initiatives, ensuring accurate, controlled, and efficient movement of data across systems as part of transformation and remediation programs.

Key Responsibilities

• Analyse source and target systems and define data migration requirements
• Perform data mapping, transformation logic definition, and reconciliation design
• Design and implement ETL pipelines for data ingestion and transformation
• Execute and support data migration activities (planning, execution, validation, reconciliation)
• Conduct data discovery and lineage analysis across systems
• Identify and resolve data issues during migration (quality, completeness, consistency)
• Perform root cause analysis of data discrepancies and defects
• Define and implement data validation, controls, and reconciliation checks
• Support cutover planning, migration rehearsals, and post-migration validation
• Ensure alignment with data governance, quality, and risk controls

Required Skills & Experience

• 8–14 years in ETL, Data Engineering, or Data Migration roles
• Strong experience in data mapping, transformation, and reconciliation
• Hands-on experience with ETL tools (Informatica, Ab Initio, Talend, SSIS, etc.)
• Strong SQL and data analysis skills
• Experience in large-scale data migration or transformation programs
• Experience in regulated industries/BFSI preferred

Desired Qualifications & Certifications

• Bachelor’s/Master’s degree in Computer Science, Engineering, or related field
• Certifications in ETL tools or cloud platforms (AWS/Azure/GCP)
• Experience with modern data platforms (Snow