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, PL/SQL, SSIS, Data Mapping, SQL Stored Procedures, Salesforce Data Integration
Industry: Healthcare
DESCRIPTION:
-
Design, develop, and maintain ETL processes focused on SQL Server for data migration and integration.
-
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.
-
Develop and optimize complex SQL and PL/SQL scripts for data extraction, transformation, and loading.
-
Write, maintain, and optimize Stored Procedures and packages in SQL Server/SSIS to implement business logic.
-
Design and execute data migration plans, ensuring accurate and efficient transfer of data between systems.
-
Load and integrate data into Salesforce objects, ensuring data integrity and adherence to Salesforce data model best practices.
-
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 an 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.
-
Strong SQL and PL/SQL scripting experience.
-
Experience in writing, optimizing, and debugging Stored Procedures and packages in SQL Server/SSIS.
-
Proven data migration experience.
-
Hands-on experience loading data to Salesforce objects.
-
SQL Server, T-SQL, Stored Procedures, Performance Tuning, Debugging, Optimizing Code.
-
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.
-
Ability to work efficiently under pressure and manage multiple assignments.
