Senior Data Migration Validation Analyst – Mainframe/SQL/Salesforce – $60-65/hr W2 – Phoenix (H[...]

SunSoft Online; Phoenix (AZ); Hybrid; USD 83,000 - 90,000; Full time

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

Senior Data Migration Validation Analyst – Mainframe/SQL/Salesforce – $60-65/hr W2 – Phoenix (Hybrid, ~1 Day/Week Onsite)

Contract | SunSoft Online | United States

Posted On 08/03/2026

Job Information

Job Opening ID 2956

Location Phoenix

Client Name AZ State Agency

Job Opening Status In-progress

Technology

Number of Positions 1

City Phoenix

State/Province Arizona

85001

Job Description

Senior Data Migration Validation Analyst – Mainframe/SQL/Salesforce – $60-65/hr W2 – Phoenix (Hybrid, ~1 Day/Week Onsite)

Own data integrity on a high-stakes legacy-to-cloud migration.

A state agency is migrating from a legacy mainframe through SQL staging into Salesforce CRM, and needs a senior analyst to guarantee 100% data integrity across every hop: zero record loss, perfect relational mapping, clean reconciliation.

Why this role stands out:

• $60-65/hr W2 depending on experience, 6-month contract starting early September
  
• Hybrid, genuinely: onsite about once a week in central Phoenix
  
• Senior-level ownership of validation strategy on a complex, visible migration
  

What you'll do:validate data at every migration hop (mainframe → SQL → Salesforce), record counts, hash totals, financial summaries review Source-to-Target Mapping (STTM) documents and write complex SQL to verify transformation logic validate Salesforce relational integrity post-load (SOQL, Data Loader, Workbench, External IDs, parent-child relationships) triage defects (encoding issues, orphaned records, null violations) with Informatica ETL and Salesforce developers

Required:Bachelor's degree(CS, IS, Business, or related) 5+ years with SQL Server, Salesforce Service Cloud, and data conversion testing/validation advanced SQL (complex joins, CTEs, window functions, profiling) Salesforce data architecture and SOQL fluency legacy data literacy (fixed-width flat files, EBCDIC-to-ASCII validation) Python/Pandas or advanced Excel/Power Query for automated cross-system comparison AI experience a plus

The firm stuff:Phoenix-area residents only (current city on resume) in-person interview within a week start within two weeks of offer HireRight background check and drug screening W2 only, no C2C, no sponsorship closes Wednesday, August 5 at 3:00 PM