RQ09230 - Software Developer - ETL - Senior
On-siteToronto, Ontario, Canada
Toronto, Ontario, CanadaOn-siteContractSenior LevelSmall
ContractSenior LevelSmall
Job Summary
Design, develop, and execute test plans and scripts to validate Dynamics 365 integrations with internal and external systems. Perform manual and automated testing, optimize Azure data pipeline performance, and manage data migration activities between on-premises and cloud environments. Collaborate with stakeholders to integrate testing into CI/CD pipelines and provide functional guidance through documentation and training. Develop encryption processes in Azure and document all technical processes for knowledge transfer. Submit deliverables for approval and notify the project manager of any material concerns immediately.
Required Qualifications
- 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
- Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces
- Must be available for onsite work (Hybrid, 7.25 hours per calendar day, Monday to Friday inclusive)
Desired Qualifications
- Azure cloud certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)
- 5+ years of experience working on, preferably leading, testing teams and efforts
- 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
- Expertise in data transformation techniques, aggregation, enrichment, and normalization using Azure cloud technologies
- Understanding of data governance principles, data privacy regulations and experience working with high-sensitivity data, and knowledge of best practices for data security and compliance in Azure
- Ability to monitor and troubleshoot integration processes and implement efficient data processing techniques in Azure
- Expertise with Microsoft Power Platform, Logic Apps
- Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members
- Experience with SQL Server Management Studio, Azure data management tools, XRM toolbox, data modeling tools (ERWIN or PowerDesigner)
- Familiarity with data warehousing concepts and experience working with Azure Synapse Analytics
- Experience with PowerApps platform, Power Automate, Dynamics CE and F&O
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.