Data Conversion Validator Consultant

This is a fully remote position, open to applicants in New York.

📋 Description

• Execute record-by-record reconciliation, validate aggregate totals, and identify exceptions during the migration from PeopleSoft to Workday.

• Enhance data crosswalks that illustrate PeopleSoft field equivalents, data type conversions, formula translations, and integration points with Workday FDM.

• Detect data quality concerns, unmapped fields, transformation failures, and process deviations between the legacy and target systems.

• Assess and confirm the integration of PeopleSoft budget data into Workday via the Financial Data Model.

• Document validation results and the steps taken for remediation.

• Create validation reports that include exception logs, root cause analyses, and suggested corrective actions.

• Collaborate with various teams to identify and address issues.

• Assist in User Acceptance Testing (UAT) and sign-off processes.

• Work together with Budget team members and project stakeholders to validate reconciliation outcomes and ensure readiness for go-live.

• Carry out assigned responsibilities as needed.

⛳️ Requirements

• Senior/Expert level with over 7 years of experience.

• 84 months of experience in developing and executing data extraction and transformation processes specifically for Budget and Finance.

• 84 months of experience in optimizing SQL queries, Application Engine, and SQR scripts to enhance data migration efficiency.

• 84 months of experience in mapping PeopleSoft data fields to their Workday equivalents and addressing inconsistencies.

• 84 months of experience implementing ETL tools and validating data accuracy after migration.

• 84 months of experience collaborating with functional teams and Workday consultants to ensure a seamless transition.

• 84 months of experience in developing and maintaining clear and consistent documentation for data and conversion processes and procedures.

• 84 months of experience collaborating with technical teams, including PeopleSoft, Workday, database administrators, and cybersecurity analysts.

• Proficiency with the MS Platform, including Outlook, Teams, Project, Excel, PowerPoint, Visio, Word, Tumbleweed, VDI, ORACLE Products, PeopleSoft, and Workday.

🏝️ Benefits

• 100% remote work.

• Engagement duration of 12 months.

• Daily working hours from 9:00 AM to 6:00 PM with a 1-hour lunch break.

• No travel requirements.

• No security requirements.