Full Remote - DATA CONVERSION VALIDATOR (Peoplesoft - Workday)

Full Remote - DATA CONVERSION VALIDATOR (Peoplesoft - Workday)

• New York, NY

Intermedia Group has an opening for the following Consultant:

TITLE:DATA CONVERSION VALIDATOR

TYPE: Either w2 or Corp to Corp

LOCATION:FULLY REMOTE (Client is in NYC)

DURATION: 12 months +

SUMMARY

• For a Workday Implementation, this project is to developData Conversion Validation to support the Budget team during the migration of budgeting and commitment control data from PeopleSoft to Workday.

RESPONSIBILITIES

• 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

CANDIDATE REQUIREMENTS:

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

STEPHEN FLEISCHNER

Recruiting Manager

INTERMEDIA GROUP, INC.

EMAIL:

LINKEDIN: