Senior ETL Developer

Newport Williams; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A recruitment firm is seeking a Senior Software Developer – ETL in Toronto to integrate Dynamics 365 with various systems. The role requires designing ETL processes, leading data migrations, and conducting quality assurance. Ideal candidates will have hands-on experience with ETL tools like Azure Data Factory. This is a contract position offering a hybrid work model.

Qualifications

• Hands-on experience in ETL processes and tools.
• Ability to lead data migration activities.
• Strong testing and QA abilities.

Responsibilities

• Design, develop, and implement ETL processes.
• Lead data migration planning and execution.
• Develop test plans and perform testing.
• Collaborate with stakeholders for data flow.
• Provide support and documentation.

Skills

ETL processes

Azure Data Factory

SSIS

Data migration strategies

Testing and QA

Job description

Get AI-powered advice on this job and more exclusive features.

Continue with Google

Contract position, hybrid role!

Please apply only if you have hands-on experience in the following skillset.

Our public sector client requires a Senior Software Developer – ETL to perform activities for interfacing the new Dynamics 365 solution and data warehouse with internal (OPS) and external systems as a member of the integrations team made up of internal and vendor staff.

As a member of the integrations team, the ETL Developer will be responsible for integrating the new Dynamics 365 solution, the data warehouse, and various internal (OPS) and external systems. This team will comprise both internal staff and vendor resources.

A high-level list of deliverables for the ETL Developer includes:

1. ETL Solution Design and Development: Design, develop, and implement robust ETL processes for data migration and ongoing integrations between source systems and Dynamics 365 (Customer Engagement and Finance & Operations). Optimize data transformation logic, utilize appropriate ETL tools (e.g., Azure Data Factory, SSIS), and implement data cleansing and validation mechanisms.
2. Data Migration Planning and Execution: Lead data migration activities, develop migration strategies, and collaborate with data owners to ensure data accuracy during migration.
3. Testing and Quality Assurance: Develop test plans, perform manual and automated testing, and ensure data integrity and system performance.
4. Collaboration and CI/CD Integration: Work with stakeholders to understand requirements, ensure proper data flow, and integrate ETL processes into CI/CD pipelines.
5. Support and Documentation: Provide support throughout the project, develop technical documentation, and troubleshoot data issues.

Seniority level: Mid-Senior level

Employment type: Contract

Job function: Information Technology, Public Assistance Programs

Note: This job is active and not expired.