Senior ETL Architect - Azure Data Factory & Dynamics

Rubicon Path; Toronto; Hybrid; CAD 100,000 - 120,000; Full time

Job summary

A technology consulting firm in Toronto seeks a Senior Software Developer specializing in ETL to lead data migration projects. Responsibilities include data analysis, transformation, and migration to Dynamics 365 platforms. Candidates should possess extensive experience in Azure technologies and strong SQL skills to ensure data integrity throughout the migration process. This role offers a flexible hybrid working environment.

Qualifications

• 5+ years of proven working experience in an ETL role.
• Strong understanding of ETL principles, including data extraction, transformation, and loading processes.
• Proficiency in data pipeline architectures and Azure workflow orchestration tools.

Responsibilities

• Perform data migration activities from legacy applications to Dynamics 365.
• Analyze existing data and design migration strategy.
• Conduct thorough testing to verify the accuracy of migrated data.

Skills

5+ years of ETL experience

Proficiency in Azure Data Factory

Strong SQL skills

Knowledge of Dynamics integration technologies

Experience with PowerApps

Tools

Azure Synapse workspaces

PowerShell

Azure SQL Databases

Job description

A technology consulting firm in Toronto seeks a Senior Software Developer specializing in ETL to lead data migration projects. Responsibilities include data analysis, transformation, and migration to Dynamics 365 platforms. Candidates should possess extensive experience in Azure technologies and strong SQL skills to ensure data integrity throughout the migration process. This role offers a flexible hybrid working environment.