Data Migration Lead

Tata Consultancy Services; Toronto; On-site; CAD 90,000 - 100,000; Full time

Job summary

Tata Consultancy Services Canada is seeking a highly skilled Data Migration Lead with strong QA and data validation expertise to drive enterprise-scale cloud data migration initiatives. You will lead end-to-end strategy, execution, and quality assurance of complex migration tracks using Azure Databricks and Azure Data Factory.

You will bridge data engineering and business stakeholders, ensuring secure, accurate migrations with zero business disruption while maintaining rigorous reconciliation

Qualifications

• Experience leading enterprise-scale data migrations and coordinating across teams.
• Strong QA and data validation skills with end-to-end data quality accountability.
• Ability to translate business requirements into robust data integration strategies.

Responsibilities

• Lead end-to-end data migration tracks from scoping through production cutover.
• Define migration strategies, S2T mappings, and rollback procedures.
• Coordinate with product owners, system architects, and business teams on criteria and logic.
• Design and optimize ETL/ELT pipelines to move data into Azure Cloud.
• Build migration frameworks using PySpark and Delta Lake in Azure Databricks.
• Establish automated source-to-target reconciliation and data quality checks.

Skills

Data migration leadership

QA expertise

Data validation

Stakeholder coordination

Tools

Azure Databricks

Azure Data Factory

PySpark

Delta Lake

Medallion architecture

Job description

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.

Tata Consultancy Services (BSE: 532540, NSE: TCS) is the technology partner of choice for industry-leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence and customer service.

It has set an aspiration to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence.

Rooted in the heritage of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large. With a highly skilled workforce spread across 56 countries and 194 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients. Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today.

Job Summary

We are seeking a highly skilled Data Migration Lead with strong QA and data validation expertise to drive our enterprise-scale cloud data migration initiatives. In this role, you will lead the end-to-end strategy, execution, and quality assurance of complex data migration tracks. You will leverage the Microsoft Azure ecosystem, specifically Azure Databricks and Azure Data Factory (ADF), to design high-performance ETL pipelines while establishing rigorous source-to-target reconciliation and automated data quality frameworks. The ideal candidate acts as the bridge between technical data engineering teams and business stakeholders, ensuring that data is migrated securely, accurately, and with zero business disruption.

Key Responsibilities

• Migration Strategy & Leadership: Lead end-to-end data migration tracks from initial scoping, legacy profiling, and planning through production cutover and deployment.
• Define comprehensive migration strategies, source-to-target mapping (S2T) documents, and fallback/rollback procedures.
• Coordinate with cross-functional stakeholders, including product owners, system architects, and business teams, to align on migration criteria and business logic.
• ETL Engineering & Orchestration: Design and optimize ETL/ELT pipelines to ingest, transform, and load massive scale datasets from disparate legacy systems into Azure Cloud.
• Build optimized migration frameworks inside Azure Databricks using PySpark, Delta Lake, and Medallion architecture patterns.
• Orchestrate complex workflows and data movements via Azure Data Factory, managing incremental loads, scheduling, and error handling.QA, Data Quality & Reconciliation
• Establish the data validation framework, implementing rules for advanced data profiling, cleansing, deduplication, and survivorship.
• Author comprehensive test strategies encompassing System Integration Testing (SIT), User Acceptance Testing (UAT), regression testing, and final production validation.
• Build automated source-to-target reconciliation

Salary Range - CA$ 90,000 - CA$ 100,000 Per annum

TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion.

Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodation during the recruitment and selection process, please inform Human Resources.

Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.