Software Developer - ETL - Senior

Software Developer - ETL - Senior:

On behalf of our Government client, Procom is searching for a Software Developer - ETL - Senior for a 4 month contract role. This position is a hybrid position with 2 days onsite at our client’s Toronto office.


Software Developer - ETL - Senior - Job Description:

This role involves interfacing a new Dynamics 365 solution and data warehouse with internal and external systems. The project focuses on integrating various data sources and systems using Azure services, contributing to high-impact projects with the Ontario Government.


Software Developer - ETL - Senior - Responsibilities:

• Design, develop, and execute test plans, cases, scripts, and test data based on functional and technical specifications
• Perform manual and automated testing to validate system/integration functionality and performance
• Collaborate with stakeholders to integrate tests into the continuous integration/continuous delivery (CI/CD) pipeline
• Plan and execute data migration activities, ensuring integration from external/internal sources to Microsoft Dynamics
• Verify configuration, tuning, and optimization of Dynamics 365 applications for seamless integration
• Analyze and optimize system integration performance
• Provide functional guidance to CRM users through documentation and training
  
  
  

Software Developer - ETL - Senior - Mandatory Skills:

• 5+ years of experience with Microsoft Azure Cloud technology, especially MS Dynamics 365 CRM and ERP applications
• 5+ years of experience in integrating various data sources and systems using Azure ETL services or other ETL tools
• 5+ years of experience working on or leading testing teams and efforts
• Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data modeling, and query performance analysis
• Proficiency in Azure Data Factory and Azure Synapse workspaces
• Strong SQL skills and experience with Azure SQL Databases and Dataverse
• Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
  
  
  

Software Developer - ETL - Senior – Nice-to-Have Skills:

• Azure cloud certifications (e.g., Azure Administrator, Azure Developer)
• Experience with CI/CD processes around DevOps and data workflows
• Understanding of data pipeline architectures and Azure workflow orchestration tools
• Familiarity with version control systems and collaboration tools like Azure DevOps
• Experience with data warehousing concepts and Azure Synapse Analytics
  
  
  

Software Developer - ETL - Senior – Assignment Length:

This is a 4 month contract position with the possibility of extension based on business case approvals.


Software Developer - ETL - Senior - Start Date:

ASAP


Software Developer - ETL - Senior - Assignment Location:

Toronto, Ontario, Canada. This is a hybrid role requiring 2 days onsite per week.