Salesforce ETL Developer

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, SQL Server database, Data analysis, Data migration, Salesforce Health Cloud, SOQL, PL/SQL scripting, AI, Agile

Industry: Healthcare

DESCRIPTION:

Design, develop, and maintain ETL processes focused on SQL Server for data migration
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
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
SQL Server, T-SQL, Stored Procedures, Performance Tuning, Debugging, Optimizing Stored Procedures
SSIS
Data Mapping
MS Access
Converting business logic into SQL code
SQL Server database, Data analysis, Data migration, Salesforce Health Cloud, SOQL, PL SQL scripting
Ability to work independently or in a group under a limited degree of supervision
Ability to work efficiently under pressure and manage multiple assignments
As part of our hiring process, we use AI‑based systems to support initial applicant screening.

TO APPLY: https://directitrecruiting.com/job/salesforce-etl-dev-1849/

Requirements added by the job poster

• Commute to this job’s location