Senior Data Engineer at Capco

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 (Snowflake, Databricks, etc.) WHY JOIN CAPCO? You will work on engaging projects with some of the largest banks in the world, on projects that will transform the financial services industry. We offer: • A work culture focused on innovation and creating lasting value for our clients and employees • Ongoing learning opportunities to help you acquire new skills or deepen existing expertise • A flat, non-hierarchical structure that will enable you to work with senior partners and directly with clients • A diverse, inclusive, meritocratic culture We offer: • A work culture focused on innovation and creating lasting value for our clients and employees • Ongoing learning opportunities to help you acquire new skills or deepen existing expertise • A flat, non-hierarchical structure that will enable you to work with senior partners and directly with clients Job Role • Location: Bangalore, Chennai Experience: 8–14 Years About the Role We are seeking a Senior Consultant to support data governance initiatives, helping clients define and implement governance frameworks, policies, and operating models. Key Responsibilities • Analyse and interpret data governance policies and standards • Assess applicability of governance requirements across business processes • Conduct current state assessments across processes, systems, and operating models • Perform gap analysis and define target state governance frameworks • Establish data ownership, stewardship, and accountability models • Design and implement governance artefacts, controls, and KCIs • Support risk and control assessments (e.g., RCSA) and governance reporting • Coordinate with stakeholders to drive alignment and approvals • Track and manage data governance initiatives and deliverables • Drive change management activities (training, communication, documentation) • Participate in governance forums and workshops Required Skills & Experience • 8–14 years in Data Governance / Data Management roles • Strong understanding of data governance frameworks and controls • Experience in client-facing delivery or transformation programs • Experience in BFSI Industry preferred • Strong communication and stakeholder management skills Desired Qualifications & Certifications • Bachelor’s/Master’s degree in relevant field • DAMA CDMP, DCAM, or equivalent certifications • Experience with tools such as Collibra, Alation, Informatica