Software Engineer

Job Title : Senior Software Developer - ETL

Location : Toronto, ON

Duration : 8+ Months

Job Description :

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8 : 00 AM and 5 : 00 PM (excluding breaks), Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

Must have :

• 5+ years of working experience with 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 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, and Synapse workspaces.

Nice to have :