Are you an experienced ETL Developer with deep data migration knowledge and hands-on experience with Azure and Microsoft Dynamics 365 CE? This role offers a chance to contribute to a high-impact transformation project by validating and ensuring the quality of data migration from legacy systems to modern Microsoft platforms.
Our client is seeking a Senior Software Developers (ETL) for a hybrid contract role based in Toronto , of 8 months. You will be responsible for testing, validating, and refining data pipelines to support a seamless transition to Dynamics 365 and Dataverse, ensuring clean, accurate, and compliant data migration.

QUALIFICATIONS

Must Have:

• 5+ years of proven working experience in ETL roles
• Expertise in ETL principles: extraction, transformation, and loading
• Strong SQL skills and experience with Azure SQL Databases and Dataverse
• Working knowledge of Microsoft Dynamics 365 Customer Engagement (CE)
• Experience in testing, validating, and troubleshooting data migrations
• Understanding of data structures, data relationships, and query tuning
• Experience with ETL code modification, data quality KPIs, and reconciliation
• Familiarity with Azure tools like Synapse, Azure DevOps, and Power Platform

Nice to Have:

Azure certifications (e.g., Azure Fundamentals, Data Engineer Associate)

• ️ Familiarity with CI/CD pipelines and DevOps tools

  Experience with version control (Azure Repos), XRM Toolbox
  Knowledge of data governance, sensitivity, and security compliance

SUMMARY

This role offers an excellent opportunity to contribute to a mission-critical data migration into Microsoft Dynamics 365 and Azure-based platforms. As a Senior ETL Developer, you will help ensure that business data is migrated with integrity, accuracy, and reliability to support enterprise-wide adoption of new technologies.
If you are passionate about data quality, Azure integration, and large-scale migration testing, If you are interested in this role, please apply online at www.randstad.ca. Qualified candidates will be contacted.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada’s workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process

• Analyze legacy system data structures, quality, and relationships
• Read and interpret data migration mappings and transformation logic
• Conduct rigorous validation of migrated data in Dynamics 365 CE
• Create and execute detailed test plans, cases, and scripts for ETL quality checks
• Build KPIs and dashboards to report data migration completeness and quality
• Write and maintain documentation of test plans, scripts, and outcomes
• Modify ETL code as needed to resolve data quality or mapping issues
• Support data reconciliation, data profiling, and performance tuning
• Collaborate with project teams to deliver migration readiness for go-live
• Address post-migration data issues and optimize new data pipelines
• Participate in knowledge transfer sessions and document technical activities