This senior-level technical consulting role requires expertise in a specialized discipline, focusing on solving complex problems and leading projects with minimal guidance.
Data Conversion Validator Consultant
📜 Description
- Perform record-by-record reconciliation and aggregate totals validation to prevent data loss during migration.
- Refine data crosswalks for PeopleSoft field equivalents and Workday integration points.
- Identify data quality issues and process deviations between legacy and target systems.
- Document validation findings and prepare detailed reports with root cause analysis and corrective actions.
- Collaborate with teams to support UAT and certify readiness for go-live.
🛠️ Requirements
- 7+ years of experience in data extraction and transformation processes for Budget and Finance.
- 7+ years of experience optimizing SQL queries and SQR scripts for data migration.
- 7+ years of experience mapping PeopleSoft data fields to Workday equivalents.
- 7+ years of experience implementing ETL tools and validating data accuracy post-migration.
- 7+ years of experience collaborating with functional teams and Workday consultants.
- 7+ years of experience developing and maintaining documentation for data processes.
Full job description
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-liv
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. |
Similar jobs
Search more Consultant jobsDesign and deliver advanced AI and machine learning solutions to enhance IT managed services, collaborating with cross-functional teams to integrate AI/ML across various systems.
As a Sr Technical Consultant, you will leverage your expertise to solve complex challenges, lead projects, and support less-experienced colleagues while driving process improvements.
As an Oracle Fusion CX Functional Consultant, you will lead workshops, configure Oracle systems, define integration requirements, and support data migration and testing processes.
Principal Supply Chain Consultant - SD | MM | EWM
Lead the design and delivery of complex SAP supply chain solutions as a Principal SAP Supply Chain Consultant, collaborating with stakeholders and mentoring junior consultants.
