Senior Software Developer ETL

Randstad Canada; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

Randstad Canada is seeking a Senior Software Developer ETL in Toronto for an 8-month contract. The ideal candidate will have at least 8 years of experience in ETL development and enterprise-level data integration, specifically with Microsoft Dynamics 365. Responsibilities include designing robust ETL processes, migrating data from legacy systems, and collaborating across teams to ensure seamless data flows.

Benefits

Competitive rate within the industry

Working 7.25 hours a day, Monday to Friday

Qualifications

• At least 8 years of hands-on experience in data integration and ETL development.
• Strong focus on integrating with Microsoft Dynamics 365 and Azure data services.
• Excellent collaborative abilities required.

Responsibilities

• Design, develop, and implement ETL processes for data migration and integration.
• Lead all phases of data migration from legacy systems to D365 CE and F&O.
• Collaborate with stakeholders to ensure data accuracy and integrity.

Skills

Data Integration

ETL Development

Microsoft Dynamics 365

Azure Data Services

Collaboration

Tools

Azure Data Factory

SSIS

Job description

Do you have at least 8 years of hands-on experience in enterprise-level data integration and ETL (Extract, Transform, Load) development, with a significant focus on integrating with Microsoft Dynamics 365 (Customer Engagement and/or Finance & Operations) and related Azure data services? If so, this would be a great opportunity for you!

Our client is looking for a Senior Software Developer ETL for a 8 month contract in Toronto.
This is an onsite role.


Advantages
• Working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive
• Earn a competitive rate within the industry


Responsibilities
• ETL Solution Design and Development:

o Design, develop, and implement robust ETL (Extract, Transform, Load) processes for data migration and ongoing integrations between diverse source systems (e.g., internal legacy systems, external vendor platforms) and Microsoft Dynamics 365 Customer Engagement (CE) and Finance & Operations (F&O).

o Develop and optimize data transformation logic to ensure data quality, consistency, and adherence to business rules and D365 data models.

o Utilize and recommend appropriate ETL tools and technologies (e.g., Azure Data Factory, SSIS, other cloud-based ETL services) to build efficient and scalable data pipelines.

o Implement data cleansing, validation, and error handling mechanisms within ETL processes.

• Data Migration Planning and Execution:

o Lead and execute all phases of data migration activities from legacy systems to D365 CE and F&O, including data profiling, mapping, cleansing, transformation, and loading.

o Develop and maintain data migration strategies, cutover plans, and rollback procedures.

o Collaborate with data owners and business users to ensure data accuracy and completeness during migration.

• Testing and Quality Assurance:

o Design, develop, and execute comprehensive test plans, cases, scripts, and test data (e.g., manufactured, obfuscated) based on functional and technical specifications to validate ETL solutions and data integrity.

o Create and maintain a full test plan, testing procedures, and an associated library of reusable test cases and scripts, ensuring full traceability from requirements to test outcomes.

o Perform both manual and automated testing to validate system and integration functionality, data accuracy, performance, and scalability. This includes unit testing, integration testing, system testing, and performance testing for ETL processes.

• Collaboration and CI/CD Integration:

o Actively collaborate with stakeholders across business units, development teams, and external vendors to understand integration requirements and ensure proper data flow.

o Ensure proper integration of ETL processes and tests into the continuous integration/continuous delivery (CI/CD) pipeline to support automated deployments and efficient release cycles.

• Support and Documentation:

o Provide analytical, development, and testing support for ETL processes and data integrations throughout the project lifecycle.

o Develop and maintain detailed technical documentation for all ETL processes, data mappings, data dictionaries, and integration architectures.

o Assist in troubleshooting and resolving data integration issues, providing timely support and solutions.


Qualifications
Must haves:

• At least 8 years of hands-on experience in enterprise-level data integration and ETL (Extract, Transform, Load) development, with a significant focus on integrating with Microsoft Dynamics 365 (Customer Engagement and/or Finance & Operations) and related Azure data services.

Nice to Have Requirements

• The ideal candidate for this ETL Developer role will possess a strong blend of technical expertise in data integration, a deep understanding of Microsoft's data ecosystem, and excellent collaborative abilities.


Summary
If you are interested in the Senior Software Developer ETL role in Toronto, please apply online at www.randstad.ca. Qualified candidates will be contacted.


Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [e-mail] to ensure their ability to fully participate in the interview process.