Return to jobs

RQ06844 - Software Developer - ETL - Senior

Ref: CA_EN_6_919740_1528997

Posted on 29 January 2024
Toronto, Ontario
Contract Type

Job Description: Senior ETL Developer - Azure Data Platform

Experience and Skill Set Requirements:

Mandatory Requirements:

  • 5+ years of proven ETL experience with expertise in data extraction, transformation, and loading (ETL) principles, including knowledge of common ETL design patterns.

  • Proficiency in Azure Data Factory, Azure Synapse Workspaces, PolyBase, Azure SQL Databases, and Dataverse.

  • Strong SQL skills, experience with scripting languages like Python, and knowledge of Azure-specific scripting using PowerShell or Azure CLI.

  • Expertise in data manipulation languages (T-SQL, PL/SQL), data modeling, and query performance analysis.

  • Experience with integration technologies used in Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.

  • Familiarity with data warehousing concepts, Azure Synapse Analytics, SSIS, SSRS, and PowerBI.

Nice to Have Skills and Experience:

  • Azure cloud certifications (e.g., Azure Fundamentals, Azure Data Engineer Associate, Azure Database Administrator Associate).

  • Experience with PowerApps platform, Power Automate, Dynamics CE, and F&O.

Skills and Knowledge:

  • Demonstrated experience in ETL development, data pipelines, workflow orchestration, and data ingestion, transformation, and movement.

  • Proficiency in Azure Data Factory, Synapse Workspaces, PolyBase, and scripting languages like Python.

  • Expertise in data manipulation languages (T-SQL, PL/SQL), data governance principles, and data quality management practices.

  • Experience with CI/CD processes, DevOps, and version control systems like Azure Repos.

  • Familiarity with data warehousing concepts and tools, including ERWIN for data modeling.


Data Migration, ETL

  • Demonstrated experience with ETL development, data pipelines, and Azure ETL services.

  • Proficiency in Azure Data Factory, Synapse Workspaces, PolyBase, and data manipulation languages.

  • Experience with SQL Server, Oracle, and data modeling tools (preferably, ERWIN).

Data Warehousing and Reporting

  • Experience with Azure Synapse Analytics or similar platforms for large-scale data warehousing.

  • Familiarity with data warehousing modeling concepts and tools, including SSIS, SSRS, and PowerBI.

Azure Platform

  • Experience with Azure Data Factory (ADF), Synapse Workspaces, and Azure data management tools.

  • Familiarity with Azure resource configuration and administration, cloud platform, and Azure cloud certifications.

Dynamics 365

  • Experience with integration technologies in Dynamics, such as DataVerse / CDS, Data Entities, and APIs.

  • Demonstrated experience with PowerApps platform, Power Automate, Dynamics CE & F&O.

DevOps and CI/CD

  • Experience with CI/CD tools and processes in DevOps, data workflows, and Synapse workspaces.

    Knowledge Transfer:

  • Document tasks executed as a member of the data migration team using the project manager's specified approach and tools.

Find your local office.

Find your local office. Modis has over 100 offices in the United States, Canada and Europe. With both industry and location-specific expertise, our people know their area and their labor market and can find the right position for you.