Senior ETL Engineer - Azure & Dynamics 365 Integrations

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

Job summary

A government agency in Ontario is seeking a Senior Software Developer specializing in ETL to join the integrations team. This position focuses on interfacing a new Dynamics 365 solution with various systems. Candidates must have over 5 years of experience in Microsoft Azure Cloud technology, particularly with Dynamics 365, strong SQL skills, and expertise in ETL processes. The role involves testing, data migration, and performance optimization in a hybrid work setting.

Benefits

Hybrid work model

Qualifications

• 5+ years working experience in Microsoft Azure Cloud technology, especially MS Dynamics 365.
• In-depth knowledge of integration technologies like DataVerse, Data Entities, and APIs.
• Strong SQL skills with experience in Azure SQL Databases.

Responsibilities

• Design, develop, and execute test plans and test cases based on specifications.
• Perform manual and automated testing of system integration functionality.
• Collaborate with stakeholders to ensure proper integration of tests into the CI/CD pipeline.

Skills

Microsoft Azure Cloud technology

Microsoft Dynamics 365 integration

ETL tools

SQL skills

Data manipulation languages (T-SQL, PL/SQL)

Tools

Azure Data Factory

PowerApps

Power BI

Azure SQL Databases

Job description

A government agency in Ontario is seeking a Senior Software Developer specializing in ETL to join the integrations team. This position focuses on interfacing a new Dynamics 365 solution with various systems. Candidates must have over 5 years of experience in Microsoft Azure Cloud technology, particularly with Dynamics 365, strong SQL skills, and expertise in ETL processes. The role involves testing, data migration, and performance optimization in a hybrid work setting.