About the role

What will you do at NOVA22 | SunSoftOnline?

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

Which skills does this role require?

Salesforce Service CloudData ArchitectureLegacy-to-cloudRelational MappingData IntegritySOQL FluencyFixed-width Flat FilesCross-system Comparison

Make your next move

Build a shortlist and prepare

Identify the requirements you can demonstrate, then choose examples from your work to discuss with the hiring team.

Build a focused shortlist before you applyCompare role requirements with your experience and give each application a clear reason.
Practice explaining your experience in an interviewRehearse your answers before meeting the hiring team.

Review the responsibilities and requirements before adding an opening to your shortlist.