Data Migration Validation Lead: Mainframe to Salesforce

SunSoft Online

Phoenix (AZ)

Hybrid

USD 83,000 - 90,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

SunSoft Online seeks a Senior Data Migration Validation Analyst to guarantee 100% data integrity across a legacy mainframe to SQL to Salesforce migration in the Phoenix area. The role demands senior expertise in validation strategies, complex SQL, and Salesforce data architecture to prevent record loss and ensure accurate mappings.

Responsibilities include validating at each hop, maintaining STTM documentation, and collaborating with Informatica ETL and Salesforce developers to triage issues.

Qualifications

5+ years with SQL Server, Salesforce Service Cloud, and data conversion testing/validation.
Advanced SQL skills including joins, CTEs, and window functions.
Knowledge of Salesforce data architecture and SOQL fluency.
Legacy data literacy with fixed-width files and EBCDIC/ASCII validation.
Python/Pandas or advanced Excel/Power Query for cross-system comparisons; AI experience a plus.

Responsibilities

Validate data at each migration hop (mainframe → SQL → Salesforce) and verify counts and sums.
Review STTM documents and write complex SQL to validate transformation logic.
Validate Salesforce relational integrity post-load using SOQL, Data Loader, and Workbench.
Triage defects with Informatica ETL and Salesforce developers.

Skills

SQL

Salesforce Service Cloud

Data validation

Python

Excel/Power Query

Education

Bachelor's degree (CS/IS/Business or related)

Tools

Informatica ETL

SOQL

Data Loader

Workbench

Job description

Responsibilities include validating at each hop, maintaining STTM documentation, and collaborating with Informatica ETL and Salesforce developers to triage issues.

Get your free, confidential resume review.

or drag and drop your file here.