Data Conversion Validator Consultant
Data Conversion Validator Consultant – Senior/Expert (7+ Years) Engagement Details - Term of Engagement: 12 months - Estimated Completion: October 15, 2027 - Daily Work Hours: 9:00 AM – 6:00 PM (1-hour lunch) - Work Location: 100% Remote - Office Address: New York, NY 10006 - Security Requirements: None - Travel Requirements: None - Typical Software Used for Engagement: MS Platform including Outlook, Teams, Project, Excel, PowerPoint, Visio, Word, Tumbleweed, VDI, ORACLE - Products: Peoplesoft, Workday - Project: Workday Implementation - Project Description: Data Conversion Validation to support Budget team during the migration of budgeting and commitment control data from PeopleSoft to Workday. 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 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 - Duties as assigned Data Conversion Validator Qualifications: (Senior/Expert (7) years) or more - 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 (but not limited to) such as PeopleSoft, Workday, database administrators, cybersecurity analysts to ensure comprehensive identity management practices