Search Jobs | Dice.com

Job Details

Skills

Data Migration
Migration
SQL
Salesforce
Data Conversion
Data Integrity
Microsoft SQL Server
Database
Data Architecture
Data Profiling
Data Structure

Summary

Job Title: Data Migration Validation Analyst

Location: Phoenix, AZ ( Hybrid - once a week or as needed)

Duration: 6 Months
Candidates must be local to AZ and available for an in-person interview Required Skills:

SQL Server
Salesforce Service Cloud
Data Conversion Testing/Validation

Preferred Skills:

AI experience
Legacy Data
Scripting/Automation

Job 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:

Minimum of 5 years of experience with SQL Server, Salesforce Service Cloud and data conversion testing / validation.
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 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

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: 10202300
Position Id: 9044453
Posted 8 hours ago

Fitment

Dice Job Match Score™

📊 Calculating match score...

Create job alert

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

Hybrid in Phoenix, Arizona

•

Today

Role: Senior Data Migration Validation Analyst--F2FLocation: Phoenix, AZ-HybridNote: F2F Inetrview, Only locals to Arizona 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 da

Easy Apply

Contract

Depends on Experience

Senior Data Migration Validation Analyst

Hybrid in Phoenix, Arizona

•

Today

Idealforce has contract position available immediately for a Senior Data Migration Validation Analyst to join our customer in Phoenix,AZ. This is Hybrid Position.Please find below additional details about this job.Local Candidates. Job 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 Salesfo

Contract

Depends on Experience

Senior Data Migration Validation Analyst (Only Phoenix AZ)

Phoenix, Arizona

•

Today

Easy Apply

Contract, Third Party

Senior Data Migration Analyst - Primarily remote - Only Local to AZ Candidates

Phoenix, Arizona

•

Today

Title:Senior Data Migration Analyst - Primarily remote -Only Local to AZ Candidates Location:Phoenix,AZLength:Long termRestriction:w2 or c2cDescription:In Person interview.Initial PO for 12 months (usually projects with this customer goes for 3+ years )HybridOnly Local to AZ Candidates Job DescriptionLocal To Phoenix Only.Hybrid once a week or as needed. We are seeking a Senior Data Migration Validation Analyst to oversee the end-to-end data reconciliation and quality assurance for a complex mi

Easy Apply

Contract

Depends on Experience

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

Data Migration Validation Analyst - Phoenix, AZ || Only Local to AZ

Skills

Summary

Dice Job Match Score™

Similar Jobs

Data Migration Validation Analyst - Phoenix, AZ || Only Local to AZ

Job Details

Skills

Summary

Dice Job Match Score™

Similar Jobs