Salesforce Data Conversion Tester

Position Overview

We are seeking an experienced Salesforce Data Conversion Tester with strong expertise in data migration, conversion testing, SQL/SOQL validation, and ETL processes. The ideal candidate will be responsible for validating data migrated from legacy systems into Salesforce, ensuring data accuracy, completeness, integrity, and consistency throughout the conversion lifecycle.

Key Responsibilities

• Perform end-to-end Salesforce data conversion and migration testing from legacy/source systems to Salesforce.

• Develop and execute comprehensive test cases, test scripts, and validation scenarios for data conversion projects.

• Write and execute SQL and SOQL queries to validate, reconcile, and compare source and target data.

• Perform legacy-to-Salesforce data comparison and reconciliation, identifying data mismatches, missing records, duplicates, and transformation issues.

• Validate data extraction, transformation, and loading processes using ETL/data integration tools.

• Review and validate data mapping specifications, transformation rules, and business requirements.

• Perform data quality checks to verify completeness, accuracy, consistency, and integrity of migrated data.

• Analyze conversion defects, determine root causes, and work closely with development and data migration teams to resolve issues.

• Validate data across multiple conversion cycles, including mock conversions, system/integration testing, and production migration.

• Track and manage defects using standard defect management processes and tools.

• Prepare detailed test execution results, reconciliation reports, validation reports, and defect documentation.

• Collaborate with Salesforce developers, data engineers, business analysts, and project stakeholders to ensure successful data conversion.

• Support troubleshooting and root-cause analysis of data migration and integration issues.

Mandatory Skills & Experience

• Hands-on experience in Salesforce Data Conversion Testing / Data Migration Testing.

• Strong experience with SQL and SOQL queries for data validation and reconciliation.

• Proven experience with ETL tools and data extraction, transformation, and loading processes.

• Strong experience performing end-to-end data conversion testing for legacy-to-Salesforce migrations.

• Experience with source-to-target data comparison, reconciliation, and defect analysis.

• Strong understanding of data mapping, transformation rules, data quality, and migration testing methodologies.

• Experience creating and executing test cases, test scripts, test scenarios, and validation reports.

• Experience identifying, documenting, tracking, and retesting data conversion defects.

• Strong analytical and problem-solving skills with the ability to investigate data discrepancies.

• Excellent communication and collaboration skills.

Preferred Experience

• Experience with Salesforce data migration/conversion projects involving large and complex datasets.

• Experience with ETL/data integration platforms such as Informatica, Talend, MuleSoft, or similar tools.

• Experience working with legacy systems and relational databases.

• Experience in Agile/Scrum development environments.

• Familiarity with Salesforce objects, relationships, and data models.

• Experience with defect management and test management tools such as Jira, Azure DevOps, or similar platforms.

Expected Deliverables

• Data conversion test plans and test scenarios

• Detailed test cases and test scripts

• SQL/SOQL validation and reconciliation queries

• Source-to-target data validation results

• Data reconciliation and comparison reports

• Test execution results and evidence

• Data conversion defect reports and tracking

• Retest and defect closure results

• Final data conversion validation/sign-off reports