Sharp Decisions
Sharp Decisions

Senior Data Migration Validation Analyst

Phoenix, AZ, US • Posted 2 hours ago • Updated 2 hours ago
Full Time
On-site
USD 69.76 per hour
Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

  • Data Migration
  • Management
  • Quality Assurance
  • Database
  • Data Structure
  • Cloud Architecture
  • Data Integrity
  • Migration
  • Mainframe
  • Finance
  • Mapping
  • IDS
  • Collaboration
  • Informatica
  • Extract
  • Transform
  • Load
  • Data Quality
  • SQL
  • Data Profiling
  • Data Architecture
  • SOQL
  • Data Loading
  • Flat File
  • Python
  • Pandas
  • Microsoft Excel
  • Computer Science
  • Information Systems
  • Business Administration
  • Microsoft SQL Server
  • Salesforce.com
  • Cloud Computing
  • Data Conversion
  • Testing
  • Artificial Intelligence
  • Scripting
  • Technical Direction

Summary

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

#LI-TD1
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: sharpdec
  • Position Id: 53164
  • Posted 2 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Data Migration Validation Analyst-Phoenix, AZ-Hybrid(F2F Inetrview, Only locals to Arizona)

Hybrid in Phoenix, Arizona

•

Today

Easy Apply

Contract

Depends on Experience

Senior Data Migration Validation Analyst

Hybrid in Phoenix, Arizona

•

Today

Contract

Depends on Experience

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

Hybrid in Phoenix, Arizona

•

Today

Easy Apply

Contract, Third Party

Depends on Experience

Senior Data Migration Validation Analyst

Hybrid in Phoenix, Arizona

•

Today

Easy Apply

Contract

Depends on Experience

Search all similar jobs
More jobs at Sharp Decisions in Phoenix, AZ