Salesforce Developer(Intermediate Senior)

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

Job summary

OpenText is seeking a Salesforce Developer to drive data migration efforts, leveraging expertise in SQL and ETL processes to ensure accurate and efficient data handling. You will collaborate with teams to build robust data extraction, transformation, and loading mechanisms, contributing significantly to our digital transformation initiatives. Ideal candidates will have hands-on experience in Salesforce environments and data migration best practices.

Qualifications

• 3–5+ years of experience in Salesforce data migration projects.
• Hands-on experience with Salesforce Data Loader and ETL tools.
• Strong scripting skills in SQL and Python.

Responsibilities

• Responsible for executing development activities for data migration into Salesforce.
• Build and optimize ETL pipelines ensuring data accuracy.
• Support UAT and business users in data verification.

Skills

SQL

Data Transformation

ETL Processes

Salesforce Data Migration

APIs

Education

Salesforce Administrator Certification

Platform App Builder Certification

Tools

Salesforce Data Loader

Informatica

Talend

MuleSoft

Boomi

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 Salesforce Developer is responsible for executing development activities to deliver capabilities and enhancements with a keen focus on end-to-end process of migrating data into Salesforce from legacy or external systems. This role involves building and optimizing data extraction, transformation, and loading (ETL) pipelines, ensuring data accuracy, and working closely with technical leads and stakeholders to meet migration objectives.

WHAT THE ROLE OFFERS

Data Extraction

• Extract data from source systems (databases, files, legacy platforms, third-party applications).
• Work with SQL, APIs, or connectors to pull raw data efficiently and accurately.

Data Transformation

• Develop transformation logic to align source data with Salesforce data models.
• Cleanse, deduplicate, and enrich data to ensure consistency and usability.
• Apply business rules for formatting, validation, and relationship mapping.

Data Loading

• Load data into Salesforce using Salesforce Data Loader, Bulk API, Workbench, or third-party ETL tools.
• Sequence object loads considering dependencies (Accounts, Contacts, Opportunities, etc.).
• Handle large data volumes using chunking and batch processing techniques.

Testing & Validation

• Perform data reconciliation to confirm accuracy post-load.
• Conduct pre-load and post-load validations to ensure integrity.
• Support business users in data verification and user acceptance testing (UAT).

Error Handling & Optimization

• Identify and resolve load failures, transformation errors, and data mismatches.
• Implement retry logic and log/audit mechanisms.
• Optimize performance of ETL processes.

Documentation & Support

• Maintain field mapping documents and transformation scripts.
• Document all steps of the migration process for auditing and repeatability.
• Support cutover activities and post-migration support phases.

WHAT YOU NEED TO SUCCEED

• 3–5+ years of experience with Salesforce data migration projects
• Strong skills in SQL and data transformation scripting (Python, Excel, etc.)
• Hands-on experience with Salesforce Data Loader, Workbench, Dataloader.io
• Familiarity with ETL platforms like Informatica, Talend, MuleSoft, or Boomi
• Understanding of Salesforce data model and object relationships
• Experience managing data dependencies, lookup relationships, and record ownership

Preferred Qualifications

• Salesforce Administrator or Platform App Builder Certification
• Experience working on Sales Cloud, Service Cloud, or CPQ migrations
• Familiarity with Salesforce APIs (Bulk, REST, SOAP)
• Knowledge of LDV (large data volume) migration best practices

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.