Senior Data Migration Validation Analyst

Location: Phoenix, AZ - Hybrid
Duration: 06 months contract with possible extension
Payrate: $69.76/HR on W2

Summary:

We are seeking a Senior Data Migration Validation Analyst to oversee the end-to-end data reconciliation and quality assurance for a complex migration pipeline moving data from a legacy Mainframe system, through a SQL staging database, and into Salesforce CRM. The ideal candidate will bridge the gap between legacy data structures and modern cloud architecture, ensuring 100% data integrity, zero record loss, and accurate relational mapping.

Key Responsibilities

• End-to-End Reconciliation: Validate data at every stage of the migration pipeline (Mainframe to SQL and SQL to Salesforce), ensuring record counts, hash totals, and financial/statistical summaries match across all environments.
• Schema & Mapping Verification: Review Source-to-Target Mapping (STTM) documents and write complex SQL scripts to verify that data transformation logic, data types, and truncation rules are accurately implemented.
• Salesforce Target Validation: Use SOQL, Data Loader, and Workbench to verify relational integrity (parent-child relationships), External IDs, and object schemas remain intact after data loads.
• Defect Triage: Identify, document, and track data anomalies such as character encoding issues, orphaned records, and null constraint violations. Collaborate with Informatica ETL and Salesforce developers to resolve data quality issues.

Required Technical Skills

• SQL Mastery: Advanced SQL skills including complex joins, Common Table Expressions (CTEs), window functions, and data profiling scripts.
• Salesforce Core: Strong understanding of Salesforce data architecture, standard and custom objects, SOQL, and Salesforce data loading mechanisms.
• Legacy Data Literacy: Experience parsing fixed-width flat files and validating EBCDIC-to-ASCII conversions.
• Scripting/Automation: Experience using Python (Pandas) or advanced Excel/Power Query to perform automated row-by-row cross-system data comparisons.
• AI Experience: Experience with AI tools or technologies is a plus.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field.
• Minimum of 5 years of experience with SQL Server, Salesforce Service Cloud, and data conversion testing/validation.

Required Skills

• SQL Server
• Salesforce Service Cloud
• Data Conversion Testing / Validation

Preferred Skills

• AI Experience
• Legacy Data
• Scripting / Automation

#LI-TD1