Technical Lead-Salesforce Data Migrations

OpenText; Mississauga; On-site; CAD 110,000 - 140,000; Full time

Job summary

A leading company in information management seeks a Sales Technical Lead to direct data migration projects into Salesforce. The role involves planning and executing strategies for data quality and integrity, managing technical teams, and ensuring successful data mapping and transformation. Candidates should have extensive experience in Salesforce migration, strong leadership skills, and proficiency in relevant technologies.

Qualifications

• 8–12+ years in enterprise data projects, with 4+ in Salesforce data migration.
• Expertise in ETL tools (Informatica, MuleSoft, Talend).
• Hands-on experience with Salesforce Data Loader, APIs, SOQL.

Responsibilities

• Lead application solution design and data migration strategy into Salesforce.
• Manage tasks for technical teams of developers and analysts.
• Design ETL processes and maintain documentation for migrations.

Skills

Salesforce Data Loader

APIs

SQL

Data profiling

Large-volume data handling

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica

MuleSoft

Talend

Job description

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.