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