Salesforce ETL Developer

About the job
Work Model: Hybrid, 2 days per week in office

Location: Mississauga, Ontario

Duration: 6 month contract, 40 hours per week

Industry: Healthcare

Role Overview

We are seeking an experienced Salesforce focused ETL Developer to design, build, and optimize data migration and integration pipelines between Salesforce and enterprise systems. This role will play a critical part in ensuring accurate, scalable, and high quality data movement across platforms, with a strong emphasis on Salesforce data structures and APIs.

Key Responsibilities

Design, develop, and maintain ETL processes with a strong focus on Salesforce data integration and migration
Build and optimize data pipelines between Salesforce and SQL Server environments
Analyze Salesforce objects, relationships, and metadata to develop effective migration and integration strategies
Develop ETL solutions from scratch or enhance existing integrations involving Salesforce
Extract and transform Salesforce data using SOQL and API based integrations
Implement scheduling, orchestration, and automation of ETL workflows including Salesforce data loads
Translate complex business logic into efficient SQL and ETL processes aligned with Salesforce data models
Design, code, and debug ETL processes and participate in code reviews
Perform unit, integration, and performance testing to ensure data accuracy and consistency across Salesforce and downstream systems
Promote ETL solutions across environments using SSIS and deployment best practices
Document ETL processes, Salesforce data mappings, and transformation rules
Collaborate with architects, analysts, DBAs, and business stakeholders to resolve data and integration challenges
Provide regular status updates, estimates, and risk identification
Evaluate and recommend new tools and technologies for Salesforce data integration

Required Qualifications

Bachelor’s degree in Computer Science, Computer Engineering, or related field
5 to 7 plus years of experience as an ETL Developer in data warehouse environments
Strong hands on experience with Salesforce data integration and migration
Proficiency in SOQL and Salesforce data structures including standard and custom objects
Experience working with Salesforce APIs, data extraction, and bulk data operations
Strong expertise in SQL Server, T SQL, and stored procedures
Experience with SSIS for ETL development and deployment
Solid understanding of data mapping and data transformation concepts
Experience optimizing and debugging SQL queries and stored procedures
Familiarity with data migration between Salesforce and relational databases
Knowledge of PL SQL scripting is an asset
Experience working with MS Access and legacy data sources
Strong data analysis skills with attention to data quality and integrity

Preferred Skills

Experience integrating Salesforce with healthcare or regulated data environments
Knowledge of Salesforce data governance, security, and best practices
Familiarity with middleware or integration platforms is an asset
Ability to convert complex business requirements into scalable ETL processes

Soft Skills

Ability to work independently and collaboratively with minimal supervision
Strong problem solving and analytical thinking
Ability to manage multiple priorities and meet deadlines
Effective communication with technical and non technical stakeholders

Note: As part of our hiring process, we use AI‑based systems to support initial applicant screening.

TO APPLY: https://directitrecruiting.com/job/salesforce-etl-developer-hybrid-1867/