Job Description

Role: Software Developer - ETL - Senior
Location: Toronto, Ontario (Hybrid)
Duration: 6 Months with possible extension
Experience and Skillset Requirements
Mandatory Requirements

• 10+ years of experience working in IT software development and testing teams.
• 5+ years of proven working experience in integrating various data sources and systems, preferably integration with Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as D365 Finance & Operations, using platform and tools such as PowerApps, Power Automate and Azure Data Factory, Azure Synapse Analytics.
• 2+ years working experience of configuring D365 Customer Engagement security model to meet business requirement.
• Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
• Proficiency in Azure Data Factory, Azure Synapse workspaces
• Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
• In-depth knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
• Knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
• Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.

Resumes Evaluation/Criteria:
Criteria 1: Microsoft Dynamics 365 CRM & ERP Applications and Azure Cloud Experience - 40 Points

• Demonstrated experience of Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance & Operations, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.

Criteria 2: Data Manipulation Skills and Experience - 30 Points

• Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement.
• Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
• Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning.

Criteria 3: Testing and Quality Assurance - 20 Points

• Demonstrated experience of creation and execution of test cases, test scripts, and test data based on functional and technical specifications.
• Maintain comprehensive testing documentation, including test plans, test cases, test results, and defect reports and ensure all documentation is up-to-date and accessible to relevant parties.
• Identify potential risks related to testing and implement mitigation strategies.

Criteria 4: Communication Skills - 10 Points

• Ability to effectively communicate complex technical information to non-technical stakeholders.
• Ability to work collaboratively with cross-functional teams.
• Strong interpersonal skills to build relationships with stakeholders.

Must haves:

• 10+ years of experience working in IT software development and testing teams.
• 5+ years of proven working experience in integrating various data sources and systems, preferably integration with Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as D365 Finance & Operations, using platform and tools such as PowerApps, Power Automate and Azure Data Factory, Azure Synapse Analytics.
• 2+ years working experience of configuring D365 Customer Engagement security model to meet business requirement.
• Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
• Proficiency in Azure Data Factory, Azure Synapse workspaces
• Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies

Skills Required