ETL Developer
Job Description
About the job
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
DESCRIPTION:
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
