Highlights
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. • 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.
Numbers & Facts
| Location | Phoenix, AZ |
| Industry | Staffing/Employment Agencies |
| Company Size | 100 to 499 employees |
| Year Founded | 1990 |
| Website | http://www.sunrisesys.com/ |
Description
Senior Data Migration Validation Analyst
6 Months from projected start date
Phoenix, AZ 85007 Hybrid
Local 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 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.
Required Skills
SQL Server
Salesforce Service Cloud
Data Conversion Testing/Validation
Preferred Skills
AI experience
Legacy Data
Scripting/Automation
6 Months from projected start date
Phoenix, AZ 85007 Hybrid
Local 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 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.
Required Skills
SQL Server
Salesforce Service Cloud
Data Conversion Testing/Validation
Preferred Skills
AI experience
Legacy Data
Scripting/Automation
About Company
Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.
We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.
Our collective business experience spans over two and a half decades and ranges from:
- Business, management, and technical fields
- Information technology consulting and software solutions.
- Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
- Motivating technology staff and establishing partnerships with Fortune 500 companies
Sunrise Systems has a vast range of competence in:
- Design, development, and support of cloud-based solutions from simple to highly complexed
- Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
- Data processing and data migration
- Application re-engineering and platform migration
- Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.