Technical Lead-Salesforce Data Migrations

OpenText; Richmond Hill; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading company in information management is seeking a Technical Lead for Salesforce Data Migrations. This role entails designing and leading data migration strategies, ensuring data quality and performance. Ideal candidates will possess significant experience in data projects, especially with Salesforce and relevant ETL tools.

Qualifications

• 8–12+ years in enterprise data projects, with 4+ years in Salesforce data migration.
• Hands-on experience with Salesforce Data Loader, APIs, SOQL, and Bulk API.
• Proficient in SQL and data profiling.

Responsibilities

• Plan and manage data migration strategies into Salesforce.
• Lead development teams through migration execution.
• Establish data validation rules and conduct UAT.

Skills

Data Migration

Salesforce

ETL Development

SQL

Education

Bachelor's degree in IT or related field

Tools

Informatica

MuleSoft

Talend

Salesforce Data Loader

Job description

Technical Lead-Salesforce Data Migrations

Join to apply for the Technical Lead-Salesforce Data Migrations role at OpenText

Technical Lead-Salesforce Data Migrations

4 days ago Be among the first 25 applicants

Join to apply for the Technical Lead-Salesforce Data Migrations role at OpenText

Opentext - The Information Company

OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that shape the future of digital transformation.

AI-First. Future-Driven. Human-Centered.

At OpenText, AI is at the heart of everything we do—powering innovation, transforming work, and empowering digital knowledge workers. We're hiring talent that AI can't replace to help us shape the future of information management. Join us.

Opentext - The Information Company

OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that shape the future of digital transformation.

AI-First. Future-Driven. Human-Centered.

At OpenText, AI is at the heart of everything we do—powering innovation, transforming work, and empowering digital knowledge workers. We're hiring talent that AI can't replace to help us shape the future of information management. Join us.

YOUR IMPACT

The Sales Technical Lead is responsible for planning, designing, and leading application solution design with an emphasis on end-to-end data migration strategies into Salesforce from legacy or external systems. This role ensures high solution and data quality, integrity, and performance, while managing tasks for technical teams of developers and analysts.

What The Role Offers

Migration Strategy & Planning

• Define and own the Salesforce data migration roadmap aligned to project phases.
• Analyze source systems, assess data complexity, and plan extraction, transformation, and loading (ETL) strategies.
• Lead data profiling, gap analysis, and mapping workshops with business and technical teams.
  
  

Technical Leadership

• Lead a team of developers, analysts, and data engineers through migration execution.
• Review data models, object relationships, and ensure alignment with Salesforce architecture.
• Ensure adherence to Salesforce best practices and enterprise data policies.
  
  

Data Mapping & Transformation

• Design and validate mapping between legacy systems and Salesforce objects (standard and custom).
• Implement transformation logic for field-level conversions, deduplication, enrichment, and normalization.
• Maintain detailed field mapping and business rules documentation.
  
  

ETL Development & Execution

• Lead ETL design using tools like Informatica, Talend, MuleSoft, Jitterbit, or custom scripts (Python, SQL).
• Oversee development of migration scripts, APIs, and batch jobs for large data volumes.
• Ensure performant and scalable data loads using Salesforce Bulk API, Data Loader, Workbench, etc.
  
  

Data Quality & Validation

• Establish data validation rules and pre-load/post-load reconciliation mechanisms.
• Run mock loads, trial migrations, and conduct UAT with business stakeholders.
• Coordinate error handling, rollback plans, and data integrity checks.
  
  

Environment & Cutover Management

• Plan and manage data loads across development, test, staging, and production orgs.
• Own cutover activities and production data migration readiness checks.
• Work with release managers to align data migration with deployment cycles.
  
  

Documentation & Knowledge Transfer

• Maintain detailed documentation including data dictionaries, migration approach, and audit logs.
• Provide training and handover to operations teams for post-migration support.
  
  

What You Need To Succeed

• 8–12+ years in enterprise data projects, with 4+ years in Salesforce data migration
• Hands-on experience with Salesforce Data Loader, APIs, SOQL, and Bulk API
• Expertise in at least one ETL/Integration tool (Informatica, MuleSoft, Talend, Boomi, etc.)
• Proficient in SQL, data profiling, and large-volume data handling (LDV best practices)
• Experience with multiple full-cycle Salesforce migration projects (Sales, Service, CPQ, etc.)
  
  

Preferred Certifications

• Salesforce Certified Data Architecture and Management Designer
• Salesforce Platform Developer or Administrator Certification
• ETL tool certifications (e.g., Informatica PowerCenter, MuleSoft Developer)
  
  

OpenText's efforts to build an inclusive work environment go beyond simply complying with applicable laws. Our Employment Equity and Diversity Policy provides direction on maintaining a working environment that is inclusive of everyone, regardless of culture, national origin, race, color, gender, gender identification, sexual orientation, family status, age, veteran status, disability, religion, or other basis protected by applicable laws.

If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please contact us at [e-mail]. Our proactive approach fosters collaboration, innovation, and personal growth, enriching OpenText's vibrant workplace.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Software Development

Referrals increase your chances of interviewing at OpenText by 2x

Get notified about new Information Technology Technician jobs in Richmond Hill, Ontario, Canada.

Information Technology Support Specialist - Tier 1

Richmond Hill, Ontario, Canada 2 weeks ago

Richmond Hill, Ontario, Canada 1 week ago

information technology (IT) security specialist

Richmond Hill, Ontario, Canada 2 days ago

Network Technician - WLAN and Operation Support Systems

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.