Data Migration LeadLocation: Toronto, ONWork Arrangement: HybridEmployment Type: Fulltime FTE - PermanentExperience: 8 10 YearsJob Summary:We are seeking a highly skilledData Migration Leadwith solid expertise inQA, data validation, reconciliation, ETL/ELT, and cloud data migration. The successful candidate will lead end-to-end enterprise data migration initiatives, leveragingMicrosoft Azure, Azure Databricks, Azure Data Factory (ADF), PySpark, Delta Lake, and Medallion Architecture. This role will act as a key bridge betweendata engineering teams, technical stakeholders, and business teams, ensuring data is migrated securely, accurately, efficiently, and with minimal business disruption.Key ResponsibilitiesLead end-to-end data migration initiatives fromdiscovery, source profiling, planning, mapping, and development through production cutover .Define comprehensive migration strategies,Source-to-Target (S2T) mappings, migration plans, and rollback/fallback procedures.Collaborate with Product Owners, Solution Architects, Data Engineers, QA teams, and business stakeholders.Define migration scope, success criteria, business rules, and validation requirements.ETL Engineering & OrchestrationDesign, develop, and optimize high-volumeETL/ELT pipelinesfor migrating data from legacy platforms to Azure Cloud.Build migration frameworks usingAzure Databricks, PySpark, Delta Lake, and Medallion Architecture .Develop and optimize data transformation and processing logic usingPython/PySpark .Orchestrate data workflows usingAzure Data Factory (ADF) .Implement incremental loads, scheduling, dependency management, monitoring, and error handling.Optimize pipelines for performance, scalability, reliability, and cost efficiency.QA, Data Quality & ReconciliationEstablish comprehensivedata quality and validation frameworksfor migration projects.Perform data profiling, cleansing, deduplication, standardization, and survivorship analysis.Define and executeSIT, UAT, regression testing,



and production validationstrategies.Develop automatedSource-to-Target reconciliationprocesses.Validate record counts, data completeness, transformations, business rules, and data integrity.Identify, troubleshoot, and resolve data discrepancies and migration defects.Production & Stakeholder ManagementLead migration cutover, deployment, reconciliation, and post-production validation activities.Develop migration dashboards, reports, status updates, and quality metrics.Manage migration risks, issues, dependencies, and remediation plans.Ensure migration activities follow enterprisesecurity, governance, compliance, and data management standards .Communicate effectively with both technical and non-technical stakeholders.Required Technical SkillsAzure DatabricksAzure Data Factory (ADF)PySpark / PythonDelta LakeMedallion ArchitectureETL / ELTData MigrationSource-to-Target (S2T) MappingData Reconciliation & ValidationData Quality / Data ProfilingData Cleansing & DeduplicationSIT / UAT / Regression TestingSQLCloud Data EngineeringMigration Cutover & Production ValidationPreferred Qualifications8 10 years of experience indata migration, data engineering, ETL, QA, or data validation .Strong experience leading enterprise-scale cloud migration initiatives.Hands‑on experience withAzure data services and large-scale data processing .Strong understanding of data migration methodologies, reconciliation, and quality assurance.Experience working with legacy systems and disparate data sources.Excellent analytical, problem-solving, communication, and stakeholder management skills.Ability to lead complex migration tracks independently and drive successful production outcomes.Key Skills / KeywordsData Migration Lead, Data Migration, Azure, Azure Databricks, Azure Data Factory, ADF, PySpark, Python, Delta Lake, Medallion Architecture, ETL, ELT, SQL, Data Engineering, Data Quality, Data Validation, Data Reconciliation, Source-to-Target Mapping, S2T, Data Profiling, Data Cleansing, Deduplication, Survivorship, SIT, UAT, Regression Testing, Production Validation, Migration Cutover, Cloud Migration, Azure Cloud.#J-18808-Ljbffr

📌 Data Migration Lead (Winnipeg)
🏢 Accenture
📍 Winnipeg