{"schemaVersion":"jobsearcher.job.v1","id":"05be0f04551b3f3bb213a4a1","url":"https://jobsearcher.com/jobs/05be0f04551b3f3bb213a4a1","canonicalUrl":"https://jobsearcher.com/jobs/05be0f04551b3f3bb213a4a1","title":"Senior Data Migration Validation Analyst","description":"Position 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 perfect relational mapping.Job 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.Skills Required: 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.SQL Server.Salesforce Service Cloud.Data Conversion Testing/Validation.Education Required: Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field.Experience Required: Scripting/Automation: Experience using Python (Pandas) or advanced Excel/Power Query to perform automated, row-by-row cross-system file comparisons.Minimum of 5 years of experience with SQL Server, Salesforce Service Cloud, and data conversion testing/validation.Experience Preferred: AI experience would be a plus.**** We provide health benefits and a 401K plan ****","company":"Sysazzle","rawCompany":"sysazzle","city":"Phoenix","state":"AZ","isRemote":false,"isActive":false,"createdAt":"2026-08-06T23:37:01.150Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1211.00","title":"Computer Systems Analysts","slug":"computer-systems-analysts"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior Data Migration Validation Analyst","description":"Position 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 perfect relational mapping.Job 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.Skills Required: 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.SQL Server.Salesforce Service Cloud.Data Conversion Testing/Validation.Education Required: Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field.Experience Required: Scripting/Automation: Experience using Python (Pandas) or advanced Excel/Power Query to perform automated, row-by-row cross-system file comparisons.Minimum of 5 years of experience with SQL Server, Salesforce Service Cloud, and data conversion testing/validation.Experience Preferred: AI experience would be a plus.**** We provide health benefits and a 401K plan ****","datePosted":"2026-08-06T23:37:01.150Z","dateModified":"2026-08-06T23:37:01.150Z","hiringOrganization":{"@type":"Organization","name":"Sysazzle","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Phoenix","addressRegion":"AZ","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"05be0f04551b3f3bb213a4a1"},"url":"https://jobsearcher.com/jobs/05be0f04551b3f3bb213a4a1"}}