SonicJobs Logo
Left arrow iconBack to search
  1. Home
  2. Phoenix, AZ
  3. Senior Data Migration Validation Analyst – Mainframe/SQL/Salesforce – $60-65/hr W2 – Phoenix (Hybrid, ~1 Day/Week Onsite)

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

SunSoft Online
Posted 2 months ago, valid for 12 days
Location

Phoenix, AZ, US

Salary

$60 - $65 per hour

Contract type

Contract

By applying, a Sonicjobs account will be created for you. Sonicjobs's Privacy Policy and Terms & Conditions will apply.

SonicJobs' Terms & Conditions and Privacy Policy also apply.

Sonic Summary

info
  • The position is for a Senior Data Migration Validation Analyst with a salary of $60-65/hr W2, located in Phoenix with a hybrid work model requiring about one day onsite per week.
  • The role involves ensuring data integrity during a legacy-to-cloud migration from a mainframe to Salesforce CRM, focusing on zero record loss and perfect relational mapping.
  • Candidates must have a Bachelor's degree and at least 5 years of experience with SQL Server, Salesforce Service Cloud, and data conversion testing/validation.
  • Key responsibilities include validating data at each migration stage, reviewing Source-to-Target Mapping documents, and addressing defects in collaboration with developers.
  • The position requires advanced SQL skills, familiarity with Salesforce data architecture, and the ability to conduct automated cross-system comparisons using tools like Python or Excel.

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





Learn more about this Employer on their Career Site

Apply now in a few quick clicks

By applying, a Sonicjobs account will be created for you. Sonicjobs's Privacy Policy and Terms & Conditions will apply.

SonicJobs' Terms & Conditions and Privacy Policy also apply.

Logo
SonicJobs
Your next career move. Sorted.
Search jobsbackground image

Contact us

© 2017 - 2026 SonicJobs Inc. All rights reserved

Terms & Conditions | Privacy Policy | Browse Jobs