ETL Developer (1757) Contract HYBRID $60-70 / hr

freelance.ca; Mississauga; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A reputable freelancing platform is seeking an experienced ETL Developer for a 6-month contract based in Mississauga, Ontario. In this role, you will design and develop ETL processes, analyze data sources for migration strategies, and collaborate with stakeholders. Candidates should have a Bachelor's degree in Computer Science or related field, coupled with 5-7 years of experience in a data warehouse environment. This position offers a hybrid work model, requiring 2 days per week in the office.

Qualifications

• 5-7+ years of hands-on experience as an ETL Developer in a data warehouse environment.
• Solid understanding of database migration and ETL processes.
• Able to work independently or in a group under limited supervision.

Responsibilities

• Design, develop, and maintain ETL processes for data migration projects.
• Analyze and understand data sources to create effective migration strategies.
• Collaborate with internal and external stakeholders to resolve issues.

Skills

ETL design

SQL Server

SSIS

Data Mapping

T-SQL

Performance Tuning

Education

Bachelor’s degree in Computer Science / Computer Engineering

Tools

SQL

MS Access

Job description

Overview

NOTE : HYBRID work model, 2-days / week in office. Office located in Mississauga, Ontario. Type: 6 Month Contract, 8 hours / day, 40 hours / week. Work Experience: 5-7+ years. ETL Developer, MS Access, SQL, T-SQL, SSIS, Data Mapping, SQL Stored Procedures. Industry: Healthcare

Responsibilities

• Design, develop, and maintain ETL processes focused on SQL Server for data migration projects.
• Perform development lifecycle tasks, including :
• Analyze and understand data sources and targets to create effective data migration strategies.
• Develop data migration solutions from scratch or adapt existing components.
• Implement data pipelines, schedule and orchestrate jobs, and automate migration tasks.
• Design, code, and debug according to pre-determined standards; participate in code reviews as required.
• Perform unit testing, integration, and performance testing to ensure data accuracy and integrity.
• Promote ETL processes to different environments using SSIS Deployments.
• Document ETL processes, data mappings, and migration solutions.
• Be proactive and provide status of effort accomplished, estimates of remaining effort, and issues impacting progress.
• Collaborate with internal (architect, analyst, DBA and others) and / or external stakeholders where needed to solve problems.
• Participate in the evaluation and identification of new technologies.

Requirements

• Bachelor’s degree in Computer Science / Computer Engineering
• 5-7+ years of hands-on experience as a ETL Developer in a data warehouse environment, including ETL design, development, testing, and deployment
• Solid understanding of database migration and experience and knowledge of Databases and ETL
• SQL Server, T-SQL, Stored Procedures, Performance Tuning, Debugging, Optimizing Stored Procedures
• SSIS
• Data Mapping
• MS Access
• Converting business logic into SQL code
• Ability to work independently or in a group under a limited degree of supervision
• Team player, with an ability to motivate and be a positive role model for others
• Ability to work efficiently under pressure and manage multiple assignments