Senior ETL Software Developer

Cynet Systems Inc; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading technology solutions provider in Ontario is seeking an experienced ETL Developer. The ideal candidate will have over 5 years of experience with data extraction, transformation, and loading, as well as strong SQL skills and familiarity with Azure technologies. Responsibilities include analyzing data, conducting tests, and ensuring compliance with standards. This role offers a dynamic work environment and opportunities for professional growth.

Qualifications

• 5+ years of proven working experience in an ETL role.
• Strong understanding of data extraction, transformation, and loading.
• Experience with Azure ETL services.

Responsibilities

• Analyze data in legacy applications for structure and quality.
• Conduct thorough testing to verify data migration accuracy.
• Create comprehensive test plans and scripts for data migration.

Skills

ETL principles

Strong SQL skills

Microsoft Dynamics 365 CE

Azure SQL Databases

Data migration expertise

Automated testing solutions

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Synapse

Azure DevOps

SQL Server Management Studio

Job description

Job Description:

Requirement/Must Have:

• 5+ years of proven working experience in an ETL role, with a strong understanding of ETL principles (data extraction, transformation, and loading).
• Strong SQL skills and experience with Azure SQL Databases and Dataverse.
• Knowledge of Microsoft Dynamics 365 Customer Engagement (CE).

Experience:

• Experience with data migration from legacy applications to Dynamics 365 CE.
• Experience with ETL development, data pipelines, workflow orchestration, and integrating various data sources (on-premises and cloud) using Azure ETL services.
• Experience working with Azure Synapse workspaces, including pipelines, data flows, integration runtimes, triggers, and monitoring.
• Experience designing, implementing, and supporting automated data migration testing solutions for Dynamics 365.
• Experience with SQL Server, Azure SQL Databases, and Dataverse.
• Experience conducting application data migration testing or data quality testing for Dynamics 365 model-driven apps.

Responsibilities:

• Analyze data in legacy applications to understand structure, quality, and relationships.
• Review existing migration code to determine mapping from legacy systems to Dynamics 365 CE.
• Conduct thorough testing to verify data migration accuracy and integrity.
• Define test cases, perform data reconciliation, and resolve issues or discrepancies.
• Develop KPIs to track migration progress, completeness, and quality.
• Create comprehensive test plans, test cases, and scripts for data migration.
• Modify the migration code to address data issues.
• Maintain detailed documentation of test activities and results.
• Provide post-migration support and optimize data management processes.
• Ensure compliance with security, architecture, and technology standards.
• Transfer knowledge to designated staff.

Should Have:

• Azure cloud certifications (Azure Fundamentals, Azure Data Engineer Associate, Azure Database Administrator Associate).
• Familiarity with Dataverse / Common Data Service (CDS), data entities, APIs, and Azure storage technologies.
• Expertise in data cleansing, aggregation, enrichment, and normalization using Azure cloud technologies.
• Understanding of data governance, privacy regulations, and best practices for data security and compliance.
• Familiarity with version control systems (Azure Repos) and collaboration tools (Azure DevOps).
• Experience with CI/CD processes for data workflows and Synapse workspaces.
• Experience with SQL Server Management Studio, Azure data management tools, and XRM Toolbox.

Qualification and Education:

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).