Job Description

Role: Software Developer - ETL - Senior
Location: Toronto, ON(Hybrid)
Duration: 6 Months with Possible extension
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.

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.

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.

Must haves:

• 5+ years working 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.
• 5+ years of proven working experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools.
• 5+ years of experience working on, preferably leading, testing teams and efforts.
• In-depth 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.
• Proficiency in Azure Data Factory, Azure Synapse workspaces
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
• Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
• Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning

Nice to have:

• Azure cloud certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)
• Knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
• Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.

Skills Required