Senior Data Migration Validation Analyst

• Senior Data Migration Validation Analyst
• Location: Phoenix, AZ (Local Candidates Only)
• Work Mode: Hybrid (Onsite once a week or as needed)
• Duration: 6 Months
• Employment Type: Contract (40 Hours/Week)
• Visa: US Citizens and local to Phoenix, AZ

Job Summary:

Seeking a Senior Data Migration Validation Analyst to support a large-scale data migration project involving migration from a Legacy Mainframe system to SQL Server and Salesforce Service Cloud. The ideal candidate will ensure end-to-end data integrity, validate migration accuracy, and perform detailed reconciliation across multiple systems.

Key Responsibilities:

• Validate end-to-end data migration from Mainframe to SQL Server and Salesforce.
• Perform data reconciliation using record counts, hash totals, and financial/statistical summaries.
• Review Source-to-Target Mapping (STTM) documents and validate transformation logic.
• Develop complex SQL queries for data validation and profiling.
• Verify Salesforce data integrity using SOQL, Data Loader, and Workbench.
• Validate parent-child relationships, External IDs, and object mappings.
• Identify, analyze, document, and resolve data quality issues including:
• Missing records
• Data truncation
• Character encoding issues
• Null constraint violations
• Orphaned records
• Work closely with ETL developers, Salesforce developers, and business stakeholders.
• Automate validation and comparison processes using Python (Pandas) or Excel/Power Query.
• Ensure zero data loss and complete relational integrity throughout the migration lifecycle.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field.
• Minimum 5 years of experience in:
• SQL Server
• Salesforce Service Cloud
• Data Conversion Testing and Validation
• Strong experience in SQL development and data validation.
• Experience with Salesforce data architecture, standard/custom objects, SOQL, Data Loader, and Workbench.
• Knowledge of legacy data migration and fixed-width file validation.
• Experience performing cross-system data reconciliation.

Required Technical Skills:

• SQL Server (Advanced SQL)
• Salesforce Service Cloud
• SOQL
• Data Loader
• Salesforce Workbench
• Data Conversion Testing
• Data Validation
• Data Reconciliation
• Source-to-Target Mapping (STTM)

Preferred Skills:

• Python (Pandas)
• Excel Power Query
• Legacy Mainframe Data
• Fixed-width File Processing
• EBCDIC to ASCII Conversion
• AI experience

Nice to Have:

• Informatica ETL experience
• Data profiling and automation experience
• Financial/statistical reconciliation
• Experience with enterprise-scale migration projects

Must Have:

• Local to Phoenix, AZ
• Available for an in-person interview within one week of posting closure.
• Able to start within two weeks of an offer.
• Hybrid work schedule (onsite once weekly or as needed).