Senior Software Developer-ETL, Randstad

Randstad

Location:
Canada, North York

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

Our client is looking for a Senior Software Developer-ETL role for 1-month contract in North York. The role involves integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools. The candidate will work with Microsoft Azure Cloud technology, especially MS Dynamics 365 CRM and ERP applications.

Job Responsibility:

Design, development, and execution of test plans, cases, scripts, and test data based on functional and technical specifications to validate solutions
Perform manual and automated testing to validate system /integration functionality and performance
Collaborate with stakeholders to ensure proper integration of tests into the continuous integration/continuous delivery (CI/CD) pipeline
Provide analytical, development, and testing support and execute project level testing of the applications and solutions
Plan and execute data migration activities, ensuring various systems integration from external/internal sources to Microsoft Dynamics Customer Engagement and Finance & Operation
Verify the configuration, tuning, and optimization of Dynamics 365 applications to ensure seamless integration with other external/internal enterprise systems
Analyze and optimize the performance of the system integration
Provide functional guidance to CRM users through documentation, training sessions, and the resolution of system issues
Perform data validation tasks such as to validate the extracted/imported data to ensure its accuracy, completeness, and consistency
Develop processes for transferring data and files between internal and external environments via network, sFTP, APIs, Microsoft Power Platform, Logic Apps
Develop processes for encryption and decryption in an Azure environment
Perform testing and quality assurance related tasks such as to conduct thorough testing to verify the accuracy and integrity of the data manipulated in interfaces
Document the processes developed

Requirements:

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
Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
Proficiency in Azure Data Factory, Azure Synapse workspaces
Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
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

Nice to have:

Azure cloud certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)
Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces
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

What we offer:

Hybrid work model
Competitive rate within the industry

Additional Information:

Job Posted:
May 30, 2025

Expiration:
July 10, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Senior Software Developer-ETL