Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The State of Arizona is seeking a Senior Data Migration Validation Analyst to support a large-scale data migration initiative. The role involves validating end-to-end data migration, performing reconciliation, ensuring data integrity, and verifying source-to-target mappings.

Responsibilities

• Validate data throughout the migration pipeline (Mainframe → SQL Server → Salesforce).
• Perform record count, hash total, and financial reconciliation across environments.
• Review and validate Source-to-Target Mapping (STTM) documentation.
• Develop complex SQL scripts to validate data transformation logic.
• Validate Salesforce data using SOQL, Data Loader, and Workbench.
• Verify relational integrity, object relationships, and external IDs.
• Identify, document, and resolve data migration defects.
• Work closely with ETL and Salesforce development teams to resolve data issues.
• Automate validation and reconciliation processes using Python or Power Query where applicable.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field.
• 5+ years of experience with SQL Server.
• 5+ years of experience with Salesforce Service Cloud.
• 5+ years of experience in Data Conversion Testing & Validation.
• Advanced SQL (Joins, CTEs, Window Functions, Data Profiling).
• Salesforce Data Architecture, SOQL, Data Loader, Workbench.
• Data reconciliation and migration validation.
• Data mapping and Source-to-Target Mapping (STTM) validation.
• Financial and statistical reconciliation.
• Defect tracking and data quality analysis.
• Local Phoenix, AZ candidates only.
• Resume must clearly indicate current Phoenix-area location.
• Candidate must be available for an in-person interview within one week of the posting close date.
• Candidate must be able to start within two weeks of receiving an offer.
• HireRight background check and drug screening required.

Skills

• SQL Server
• Salesforce Service Cloud
• Data Migration
• Data Conversion Testing
• Data Validation
• Data Reconciliation
• SQL
• SOQL
• Data Loader
• Workbench
• ETL
• Data Mapping
• Source-to-Target Mapping (STTM)
• Data Profiling
• Python
• Pandas
• Power Query
• Excel
• Legacy Mainframe
• EBCDIC
• ASCII
• Data Integrity
• Scripting
• Automation
• Salesforce CRM
• Data Quality
• AI

Location

• Phoenix, AZ

Work Type

• Hybrid

Experience Level

• Senior
• 5+ years of experience with SQL Server
• 5+ years of experience with Salesforce Service Cloud
• 5+ years of experience in Data Conversion Testing & Validation

Education Level

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field

About the Company

• The State of Arizona – AZDES (Department of Economic Security)