Senior Data Migration Validation Analyst – Mainframe/SQL/Salesforce – W2 – Phoenix; H
Listed on 2026-08-30
-
IT/Tech
Data Analyst, Database Administrator, IT Business Analyst
Senior Data Migration Validation Analyst – Mainframe/SQL/Salesforce – $60-65/hr W2 – Phoenix (Hybrid, ~1 Day/Week Onsite)
Contract | Sun Soft Online | United States
Posted On 08/03/2026
Job InformationJob Opening
Location Phoenix
Client Name AZ State Agency
Job Opening Status In-progress
Technology
Number of Positions 1
City Phoenix
State/Province Arizona
85001
Job DescriptionSenior 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 Hire Right background check and drug screening W2 only, no C2C, no sponsorship closes Wednesday, August 5 at 3:00 PM
#J-18808-Ljbffr(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).