Data Migration Senior Consultant - Banking/Capital Market

Company Overview

Capco, a Wipro company, is a global technology and management consultancy specializing in driving digital transformation in the financial services industry. With a growing client portfolio comprising of over 100 global organizations, Capco operates at the intersection of business and technology by combining innovative thinking with unrivaled industry knowledge to deliver end-to-end data-driven solutions and fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting-edge ingenuity is brought to life through its Innovation Labs and award-winning Be Yourself At Work culture and diverse talent.

We are experts in Banking, Capital Markets, Wealth and Asset Management. We specialize in Digital Transformation, Data Management & Data Analytics, Business & Finance Transformation engagements, and IT transformation and Change programs.

We are committed to growing our business and hiring the best talent in the market. Our focus is on maintaining our agile and entrepreneurial culture.

Role Summary

We are seeking an experienced Data Migration Lead/Senior Consultant to manage and deliver end ‑ to ‑ end data migration activities for large-scale transformation programs within the capital markets domain.

This role is responsible for defining migration strategy, overseeing data extraction, transformation, reconciliation, and ensuring data integrity throughout the migration lifecycle. You will work closely with business, technology, and vendor teams to ensure seamless data transition with minimal disruption to operations.

Key Responsibilities

• Define and lead the overall data migration strategy, approach, and execution plan
• Manage end‑to‑end migration activities, including data extraction, transformation, and loading (ETL)
• Oversee data discovery, profiling, and mapping, ensuring alignment between source and target systems
• Ensure data quality, integrity, and completeness through validation and reconciliation processes
• Plan and manage migration test cycles, including dry runs, mock migrations, and production readiness
• Coordinate with business, technology, and vendor teams to manage dependencies and deliverables
• Identify and mitigate data risks, issues, and inconsistencies throughout the migration lifecycle
• Establish and enforce data migration governance, standards, and documentation
• Support cutover planning and execution, ensuring smooth transition to production
• Oversee post-migration validation and stabilization, including issue resolution and business sign-off

Key Requirements

Required

• 8–12+ years of experience in data migration / data management roles.
• Proven experience leading large-scale system migration or transformation programs in banking, financial services, capital market domain is a must.
• Strong expertise in ETL processes and data migration frameworks
• Experience handling complex, high-volume data environments
• Strong knowledge of data validation, reconciliation, and data quality management
• Experience working with cross-functional teams in complex delivery environments
• Strong stakeholder management and communication skills

Technical Skills (Preferred)

• Experience with ETL tools (e.g., Informatica, Talend, DataStage, SSIS)
• Strong SQL and data querying skills
• Familiarity with databases (e.g., Oracle, SQL Server)
• Experience with data migration automation and scripting
• Understanding of cloud or modern data platforms (optional advantage)

Why Join Capco?

Work on large-scale transformation programs.

Collaborate with global experts.

Gain exposure to cutting-edge technology.

Accelerate your consulting career.