Salesforce Data Conversion Tester

Job Title: Salesforce Data Conversion Tester
Job Type: Fort Detrick, MD 21702

Job Summary

We are seeking an experienced Salesforce Data Conversion Tester with strong hands-on experience in Salesforce data migration and conversion testing. The ideal candidate will have a strong background in SQL/SOQL, ETL processes, data validation, reconciliation, and end-to-end migration testing.

The candidate will be responsible for validating data migrated from legacy systems into Salesforce, identifying data discrepancies, analyzing defects, and ensuring data completeness, accuracy, and integrity throughout the conversion lifecycle.

Key Responsibilities

• Perform end-to-end Salesforce data conversion testing across legacy and target Salesforce environments.
• Create and execute detailed test cases, test scripts, and data validation scenarios for migration projects.
• Validate migrated data using SQL and SOQL queries and perform source-to-target reconciliation.
• Compare legacy system data against Salesforce data to identify missing, duplicate, incorrect, or transformed records.
• Validate data extraction, transformation, and loading processes across ETL workflows.
• Review and validate data mapping documents, transformation rules, and business requirements.
• Perform data quality checks including completeness, accuracy, consistency, uniqueness, and referential integrity.
• Analyze conversion defects, determine root causes, and work closely with development and ETL teams to resolve issues.
• Execute regression and validation testing following data conversion and migration activities.
• Validate relationships and dependencies between Salesforce objects and migrated data.
• Prepare test execution results, reconciliation reports, defect reports, and validation documentation.
• Participate in defect triage meetings and communicate data quality issues and testing status to project stakeholders.
• Support multiple migration cycles, mock conversions, dress rehearsals, and production data conversion validation.

Mandatory Skills & Experience

• Hands-on experience with Salesforce Data Conversion / Data Migration Testing.
• Strong experience writing and executing SQL and SOQL queries for data validation and reconciliation.
• Proven experience with end-to-end data conversion testing, including legacy-to-Salesforce migrations.
• Strong understanding of ETL processes and data extraction, transformation, and loading concepts.
• Experience with ETL/Data Integration tools.
• Hands-on experience performing source-to-target data comparison and reconciliation.
• Strong understanding of data mapping, transformation rules, data quality, and migration testing methodologies.
• Experience identifying, analyzing, documenting, and tracking data conversion defects.
• Experience creating and executing test cases, test scripts, validation scenarios, and test reports.
• Strong analytical and problem-solving skills with excellent attention to detail.
• Ability to work effectively with Salesforce developers, ETL developers, business analysts, and project stakeholders.

Preferred Skills

• Experience with large-scale Salesforce data migration projects.
• Knowledge of Salesforce objects, relationships, and data structures.
• Experience with Salesforce Data Loader or similar Salesforce data migration utilities.
• Familiarity with data profiling and data quality tools.
• Experience working in Agile/Scrum environments.
• Experience with Jira or similar defect management tools.

Expected Deliverables

• Data conversion test cases
• Test scripts
• Test execution results
• Source-to-target reconciliation results
• Data validation reports
• Defect documentation and tracking
• Data conversion testing status and summary reports