Senior Data Migration Validation Analyst

Location: Phoenix, AZ - Hybrid
Duration: 6-month contract with possible extension
Pay rate: $69.76/HR on W2

About the role

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.

Responsibilities

• 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.
• 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.
• Use SOQL, Data Loader, and Workbench to verify relational integrity (parent-child relationships), External IDs, and object schemas remain intact after data loads.
• 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.

Requirements

• 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.

Skills

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