Data Conversion Validator (PeopleSoft to Workday

• For a Workday Implementation, this project is to develop Data Conversion Validation to support the Budget team during the migration of budgeting and commitment control data from PeopleSoft to Workday., * Perform record-by-record reconciliation, aggregate totals validation, and exception identification to ensure no data loss or corruption during the PeopleSoft-to-Workday migration
• 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-live

Qualified candidates will know the following:

• How source-to-target validation was performed
• Validation approaches used (record counts, field-level comparisons, financial balancing, exception reporting)
• Risk-based validation techniques
• Sampling methodologies
• Data quality assessment criteria
• Validation sign-off procedures
• SQL queries
• Reconciliation reports
• Exception reports
• Count comparison reports

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