Lead Salesforce Developer

OpenText; Waterloo; On-site; CAD 100,000 - 140,000; Full time

Job summary

A leading company in information management is seeking a Salesforce Lead Developer to spearhead large-scale data migration projects. In this role, you will leverage your extensive Salesforce experience to ensure effective data transitions and architecture. You'll work with cross-functional teams, utilizing your leadership skills in data modeling, transformation, and governance, to optimize data processes and enhance performance. If you have a passion for innovation and collaboration, join us on this exciting journey.

Qualifications

• 6+ years of experience in Salesforce platform development.
• 3+ years hands-on experience with large-scale data migration.
• Proficient in data modeling and Salesforce object relationships.

Responsibilities

• Lead and deliver large-scale Salesforce data initiatives.
• Design end-to-end migration including data modeling and ETL.
• Collaborate with teams for seamless data transition.

Skills

Salesforce platform development

data migration

data modeling

data transformation logic

data governance

problem-solving

communication

leadership

Education

Salesforce Platform Developer I & II certifications

Tools

ETL tools

Salesforce APIs

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

We are seeking an experienced Salesforce Lead Developer with a strong focus on data migration to lead and deliver large-scale Salesforce data initiatives. You will be responsible for end-to-end migration design, including data modeling, extraction, transformation, load (ETL), validation, and performance tuning for Salesforce org-to-org migrations or legacy system migrations.

You will work closely with cross-functional teams including data architects, integration specialists, business analysts, and Salesforce developers to ensure clean, secure, and seamless data transition.

WHAT THE ROLE OFFERS

Data Extraction

• Extract data from source systems (databases, files, legacy platforms, third-party applications,Slaesforce Org).
• 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

• 6+ years of experience in Salesforce platform development (Apex, SOQL, APIs)
• 3+ years of hands-on experience with large-scale data migration
• Proficient in data modeling, data transformation logic, and Salesforce object relationships
• Experience with ETL tools (e.g., MuleSoft, Jitterbit, Talend, Informatica) and Salesforce APIs
• Solid understanding of Salesforce data limits, governor limits, and performance considerations
• Strong understanding of data governance, PII handling, and data quality controls
• Familiarity with version control (Git), DevOps pipelines, and CI/CD processes
• Excellent problem-solving and analytical skills
• Strong communication and leadership capabilities

Preferred Qualifications

• Salesforce Platform Developer I & II certifications
• Experience with Salesforce, Big Objects, and bulk data APIs
• Experience with Salesforce org consolidations, carve-outs, or M&A migrations
• Knowledge of agile and DevOps best practices

Nice to Have

• Experience with Python/SQL scripting for data prep
• Knowledge of Salesforce Metadata APIs and CLI tools

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.