Technical Lead-Salesforce Data Migrations

OpenText; Waterloo; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading company focused on innovation, OpenText is looking for a Sales Technical Lead responsible for leading data migration strategies into Salesforce. With over 8 years of experience required, this role involves overseeing data integrity and facilitating technical collaboration. Join their inclusive environment and help shape the future of information management.

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.
• Expertise in at least one ETL/Integration tool (like Informatica, MuleSoft, Talend).

Responsibilities

• Lead application solution design with an emphasis on data migration strategies into Salesforce.
• Ensure high solution and data quality, integrity, and performance.
• Manage tasks for technical teams of developers and analysts.

Skills

Salesforce Data Loader

ETL development

SQL

Data profiling

Data Mapping

Education

Salesforce Certified Data Architecture and Management Designer

Salesforce Platform Developer or Administrator Certification

Tools

Informatica

MuleSoft

Talend

Job description

Hiring Manager: Gautam Ghosh

Talent Acquisition Advisor: Gaurav Sehgal

Job Code Level: IRP4

Refer Your Friends!

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 submit a ticket at Ask HR. Our proactive approach fosters collaboration, innovation, and personal growth, enriching OpenText's vibrant workplace.