Software Developer - ETL - Senior

2iResourcing; Ontario; Hybrid; CAD 90,000 - 135,000; Full time

Job summary

A leading company is seeking a Senior Software Developer specializing in ETL, data integration, and Azure cloud technologies. This role requires over 10 years of experience in software development, particularly with Microsoft Dynamics 365 CRM and ERP systems. The developer will work onsite in Toronto with a hybrid model, collaborating with cross-functional teams and ensuring high-quality integration and deployment processes.

Qualifications

• Must have 10+ years of IT software development experience.
• Strong expertise in Azure and Microsoft Dynamics 365.
• Proficient in ETL processes and data manipulation.

Responsibilities

• Integrate various data sources and systems using Azure tools.
• Create and execute test cases based on specifications.
• Communicate complex technical information to stakeholders.

Skills

SQL

Data Manipulation

Azure Cloud

Data Integration

Azure Data Factory

ETL Development

Testing and QA

Communication Skills

Tools

Microsoft Dynamics 365

PowerApps

Power Automate

Azure Synapse Analytics

Azure CLI

Power BI

Logic Apps

Job description

If interested please share your resume at [e-mail] | [e-mail]

RQ09445 - Software Developer - ETL - Senior
Client: Ministry of Public and Business Service Delivery and Procurement
Location: Onsite / 595 Bay Street, Toronto

Working Hrs: 7.25/hrs
Hybrid: 3 days onsite / 2 days remote

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.

Criteria 1: Microsoft Dynamics 365 CRM & ERP Applications and Azure Cloud Experience -

• 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 -

• 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 -

• 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 -
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.

If interested please share your resume at [e-mail] | [e-mail]