Data migration ETL Developer (Salesforce)

Altis Technology; Mississauga; On-site; CAD 85,000 - 115,000; Full time

Job summary

Altis Technology in Mississauga, ON, is hiring for a data migration specialist focused on Salesforce. You will design and implement ETL pipelines, map and validate data, and migrate data into Salesforce while ensuring integrity and alignment with the CRM model.

The role emphasizes hands-on SQL/T-SQL development, SOQL usage, and collaboration with business stakeholders to deliver high-impact enterprise transformations.

Qualifications

• Recent, hands-on experience developing complex ETL scripts using SQL Stored Procedures.
• Strong expertise in SQL, T-SQL, and Stored Procedure development.
• Proven experience delivering enterprise data migration projects, preferably with Salesforce as the target platform.
• Working knowledge of the Salesforce CRM data model and experience using SOQL.
• Demonstrated experience with data mapping, transformation, and data validation.
• Strong analytical, problem-solving, and communication skills with the ability to collaborate across technical and business teams.
• Candidates with recent, hands-on experience in these technologies are strongly preferred

Responsibilities

• Develop and maintain complex ETL scripts using SQL Stored Procedures to support large-scale data migration activities.
• Design, optimize, and troubleshoot SQL and T-SQL queries to ensure efficient and accurate data processing.
• Map, transform, and validate data to meet business and technical requirements before migration.
• Migrate data into Salesforce while ensuring data integrity and alignment with the Salesforce CRM data model.
• Leverage SOQL to validate and retrieve Salesforce data throughout the migration lifecycle.
• Collaborate with cross-functional stakeholders to resolve data issues and deliver successful project outcomes

Skills

SQL

T-SQL

ETL development

Salesforce data model

Tools

SQL Stored Procedures

Salesforce

Job description

Location

Location: Mississauga, ON. Hybrid (minimum 2 days per week in office)

Language: Excellent written and verbal English communication skills

Background Check: Successful candidates must complete a criminal background check

About the Opportunity

Join a collaborative team delivering a high-impact data migration initiative within a dynamic enterprise environment. This opportunity is ideal for someone who enjoys solving complex data challenges, building scalable ETL processes, and ensuring high-quality data transitions that support critical business operations. In this role, you'll work closely with technical and business stakeholders to transform, validate, and migrate data into a Salesforce CRM environment. Strong SQL/T-SQL ETL developer + enterprise data migration experience + enough Salesforce knowledge to migrate and validate data correctly inside Salesforce.

Your expertise will directly contribute to the success of a major technology initiative while working alongside experienced professionals in a collaborative and supportive setting.

Whats In It for You

Work on a meaningful enterprise transformation project where your technical expertise will have a direct impact. You'll gain exposure to complex Salesforce data migration work while collaborating with a team that values knowledge sharing, quality delivery, and continuous improvement.

Your Responsibilities

• You'll develop and maintain complex ETL scripts using SQL Stored Procedures to support large-scale data migration activities.
• You’ll design, optimize, and troubleshoot SQL and T-SQL queries to ensure efficient and accurate data processing.
• You’ll map, transform, and validate data to meet business and technical requirements before migration.
• You’ll migrate data into Salesforce while ensuring data integrity and alignment with the Salesforce CRM data model.
• You’ll leverage SOQL to validate and retrieve Salesforce data throughout the migration lifecycle.
• You’ll collaborate with cross-functional stakeholders to resolve data issues and deliver successful project outcomes

Skills and Qualifications

• Recent, hands-on experience developing complex ETL scripts using SQL Stored Procedures.
• Strong expertise in SQL, T-SQL, and Stored Procedure development.
• Proven experience delivering enterprise data migration projects, preferably with Salesforce as the target platform.
• Working knowledge of the Salesforce CRM data model and experience using SOQL.
• Demonstrated experience with data mapping, transformation, and data validation.
• Strong analytical, problem-solving, and communication skills with the ability to collaborate across technical and business teams.
• Candidates with recent, hands-on experience in these technologies are strongly preferred

We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals. All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.