Total Experience: 8-10 years

Role Description

Job Summary

We are seeking a highly skilled Data Migration Lead with robust 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 reconcilia

📌 Data Migration Lead (Toronto)
🏢 Zodiac Solutions
📍 Toronto