
Salesforce Developer
- Waterloo, ON
- Permanent
- Full-time
- 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.
- 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.
- 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.
- 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).
- Identify and resolve load failures, transformation errors, and data mismatches.
- Implement retry logic and log/audit mechanisms.
- Optimize performance of ETL processes.
- 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.
- 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
- 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
- Experience with Python/SQL scripting for data prep
- Knowledge of Salesforce Metadata APIs and CLI tools