Apply Now

Senior Data Migration Validation Analyst

Hybrid in Phoenix, AZ, US • Posted 4 hours ago • Updated 4 hours ago

Contract W2

Contract Corp To Corp

Contract Independent

1 Year

25% Travel Required

Hybrid

Depends on Experience

SR International Inc.

Fitment

Dice Job Match Score™

🎯 Assessing qualifications...

Job Details

Skills

Automation
Scripting
Legacy Data
AI
Validation
Data Conversion Testing
Salesforce Service Cloud
SQL Server

Summary

LOOKING FOR ONLY CURRENT ARIZONA RESIDENTS

Job Title: Senior Data Migration Validation Analyst (Legacy Mainframe to Salesforce Service Cloud)

Job ID: 13094 (Hybrid)

Client: State of Arizona - AZDES - DTS

Closing Date & Time: 8/5/2026@ 4 PM

Local To Phoenix Only. Hybrid once a week or as needed.

Skill Required:

SQL Server
Salesforce Service Cloud
Data Conversion Testing/Validation

Preference:

AI experience
Legacy Data
Scripting/Automation

Position Description
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 perfect relational mapping.

Key Responsibilities:

• End-to-End Reconciliation: Validate data at every hop 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 that relational integrity (parent-child relationships), External IDs, and object schemas are perfectly intact post-load.

• Defect Triage: Identify, document, and track data anomalies (e.g., character encoding issues, orphaned records, null constraint violations) and collaborate with Informatica ETL and Salesforce developers to remediate them.

Required Technical Skills

• SQL Mastery: Advanced querying skills (complex joins, CTEs, window functions, and data profiling scripts).

• Salesforce Core: Strong understanding of Salesforce data architecture, standard/custom objects, SOQL, and data loading mechanisms.

• Legacy Data Literacy: Familiarity with parsing fixed-width flat files, or validating EBCDIC-to-ASCII conversions.

• Scripting/Automation: Experience using Python (Pandas) or advanced Excel/Power Query to perform automated, row-by-row cross-system file comparisons.

• AI Exp: would be a plus

Required Qualifications:

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10117029
Position Id: 1115-41787-1785793192
Posted 4 hours ago

Company Info

About SR International Inc.

SR International has been a leading name among the IT consulting companies with offices in US and India. For the past 20+ years, our industry experience and domain knowledge have enabled us to provide innovative solutions to our customers.

We Are Leading IT Based Solution Providers

Today, the world of business information represents the realization of our collective efforts toward improving the future. Held only by the limits of our imagination, the business world is accelerating at an ever-increasing pace. Imagine a better way of doing business, of implementing the perfect software, of refining practice or business integration. All it takes are benchmark standards in service, support, and technical know-how, which have been our bread and butter.

Our Vision.

Established in 2002, SR International Inc is one of the fastest growing and reputed provider of Information Technology Services and Solutions in the USA. Since our inception, we have been a trusted IT partner for our clients. We take pride in our highly skilled IT Resources and unique engagement model. We have been consistently delivering on our promises as a high-performance team. Our expertise in Cloud Computing, Mobility, Web Technologies, ERP and CRM are second to none. Our industry-leading flagship product iMathSmart is re-defining math learning experience for school students.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Hybrid in Phoenix, Arizona

•

Today

LOOKING FOR ONLY CURRENT ARIZONA RESIDENTS Job Title: Senior Data Migration Validation Analyst (Legacy Mainframe to Salesforce Service Cloud) Job ID: 13094 (Hybrid) Client: State of Arizona - AZDES - DTS Closing Date & Time:8/5/2026@ 4PM Local To Phoenix Only. Hybrid once a week or as needed. Skill Required: SQL Server Salesforce Service Cloud Data Conversion Testing/Validation Preference:AI experience Legacy Data Scripting/Automation Position Description We are seeking a Sen

Easy Apply

Contract, Third Party