> Markdown version of [/jobs/ext/2606577-data-migration-validation-analyst](https://www.wearedevelopers.com/jobs/ext/2606577-data-migration-validation-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Migration Validation Analyst

- **Company:** TexcelVision Inc.
- **Location:** United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Microsoft Excel, Artificial Intelligence, Software Bug Management, Encodings, Information Systems, Databases, Customer Data Management, Data Conversion, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Migration, Data Profiling, Data Structures, Intrusion Detection Systems, Mainframes, Microsoft SQL Server, Parsing, Salesforce.Com, SQL Databases, Scripting, American Standard Code for Information Interchange (ASCII), Powerquery, Pandas, Data Loader, Information Technology, Salesforce Object Query Language (SOQL), Data Objects
- **Published:** August 2, 2026
- **Apply:** https://www.dice.com/job-detail/ec258dbd-3dce-4579-892b-039917b840ba

## About the Role

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., * SQL Server

 * Salesforce Service Cloud
 * Data Conversion Testing/Validation

Preferred Skills

 * AI experience
 * Legacy Data
 * Scripting/Automation

## 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.


## Related Videos

- [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation)
- [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript)
- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [A Brief History of Data Storage](https://www.wearedevelopers.com/videos/974-a-brief-history-of-data-storage)
- [A Developer's Framework for Any Tool Migration](https://www.wearedevelopers.com/videos/2035-a-developer-s-framework-for-any-tool-migration)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)

## Related Articles

- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [13 AI Tools for Developers](https://www.wearedevelopers.com/magazine/302-13-ai-tools-for-developers)