Data Conversion Validator

TheCorporate LLC; United States; Remote; USD 110,000 - 140,000; Full time

Job summary

TheCorporate LLC is seeking a Data Conversion Validator for a remote, long-term engagement in the United States. You will perform reconciliation, data mapping, and validation across PeopleSoft to Workday migrations, ensuring data integrity and successful go-live readiness.

You will refine crosswalks, validate FDM schema alignment, and document findings, collaborating with cross-functional teams to resolve issues and support UAT.

Qualifications

• 84 months of experience developing and executing data extraction and transformation processes for Budget and Finance.
• 84 months of experience optimizing SQL queries, Application Engine, and SQR scripts for efficient data migration.
• 84 months of experience mapping PeopleSoft data fields to Workday equivalents and resolving inconsistencies.
• 84 months of experience implementing ETL tools and validating data accuracy post-migration.
• 84 months of experience collaborating with functional teams and Workday consultants for seamless transition.
• 84 months of experience developing and maintaining clear and consistent documentation for data and conversion processes and procedures.
• 84 months of experience working collaboratively with various technical teams such as PeopleSoft, Workday, database administrators, cybersecurity analysts to ensure comprehensive identity management practices.

Responsibilities

• Perform record-by-record reconciliation, aggregate totals validation, and exception identification to ensure no data loss or corruption during migration.
• Refine data crosswalks showing field equivalents, data type conversions, and transformation points.
• Identify data quality issues, unmapped fields, transformation failures, and process deviations between legacy and target systems.
• Review and validate how budget data integrates into Workday via FDM schema requirements.
• Document validation findings and remediation steps with detailed reports and root cause analysis.
• Work closely with other teams to identify and solve issues.
• Support UAT and sign-off activities; collaborate with Budget team and project stakeholders to validate reconciliation results and readiness for go-live.
• Duties as assigned

Skills

ETL processes

SQL optimization

Data migration

Data quality validation

Cross-team collaboration

Documentation

Data mapping

Data reconciliation

Tools

SQR scripts

Application Engine

ETL tools

Job description

Job Title: Data Conversion Validator

Location: Remote

Duration: Long term

Interview Mode: Phone then Video

Day to day tasks to be performed by the Consultant:

• Perform record-by-record reconciliation, aggregate totals validation, and exception identification to ensure no data loss or corruption during the PeopleSoft-to-Workday migra
• Refine data crosswalks showing PeopleSoft field equivalents, data type conversions, formula translations, and Workday FDM integration points
• Identify data quality issues, unmapped fields, transformation failures, and process deviations between legacy and target systems
• Review and validate how PeopleSoft budget data integrates into Workday via Financial Data Model, ensuring compliance with FDM schema requirements
• Document validation findings and remediation steps. Prepare detailed validation reports with exception logs, root cause analysis, and recommended corrective actions for data issues
• Work closely with other teams to identify and solve issues.
• Support UAT and sign-off activities & Collaborate with Budget team members and project stakeholders to validate reconciliation results and certify readiness for go-liv
• Duties as assigned

Position Mandatory Qualifications

Data Conversion Validator

1. 84 months of experience developing and executing data extraction and transformation processes for Budget and Finance.
2. 84 months of experience optimizing SQL queries, Application Engine, and SQR scripts for efficient data migration.
3. 84 months of experience mapping PeopleSoft data fields to Workday equivalents and resolving inconsistencies.
4. 84 months of experience implementing ETL tools and validating data accuracy post-migration.
5. 84 months of experience collaborating with functional teams and Workday consultants for seamless transition.
6. 84 months of experience developing and maintaining clear and consistent documentation for data and conversion processes and procedures.
7. 84 months of experience working collaboratively with various technical teams (but not limited to) such as peoplesoft, workday, database administrators, cybersecurity analysts to ensure comprehensive identity management practices.