Senior Data Migration Validation Analyst – Mainframe/SQL/Salesforce – $60-65/hr W2 – Phoenix (Hybrid, ~1 Day/Week Onsite)
SunSoft Online · Phoenix, Arizona, United States · $125K–$135K/yr
Administrative and Support Services · 2-10 employees
About the role
The analyst will ensure 100% data integrity during a legacy mainframe to Salesforce migration by validating data across all hops. Responsibilities include reviewing source-to-target mapping documents, writing complex SQL for transformation logic, and triaging defects with developers.
What they look for
Requirements
Candidates must have a bachelor's degree and at least 5 years of experience with SQL Server, Salesforce Service Cloud, and data conversion testing. Proficiency in advanced SQL, SOQL, and legacy data formats like EBCDIC is required.
Full 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
Keywords: Data Migration, Data Validation, Data Conversion, ETL Testing, Mainframe Migration, EBCDIC, SQL Server, SOQL, Salesforce Data Loader, Workbench, Informatica, Python, Pandas, STTM, Data Reconciliation, QA Analyst, Phoenix, Hybrid, W2
