Sr. Data Conversion Validator

ZealHire Inc.; Northern (KY); Hybrid; USD 90,000 - 150,000; Full time

Job summary

ZealHire Inc. in Kentucky seeks a Sr. Data Conversion Validator to support the Budget team during the PeopleSoft to Workday migration. You will perform reconciliation, validate crosswalks, and ensure no data loss.

The role requires 7+ years in data extraction, ETL, SQL optimization, and collaboration with Workday consultants. You will document findings, prepare remediation steps, and assist with UAT to certify readiness for go-live.

Qualifications

• 7+ years of experience developing and executing data extraction and transformation processes for Budget and Finance.
• ],
• job_responsibilities_description

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.
• ],
• CoT_job_summary_short
• job_summary_short

Skills

Data extraction

ETL processes

SQL optimization

Workday integration

PeopleSoft to Workday mapping

QA validation

cross-team collaboration

Tools

SQL

Application Engine

SQR

ETL tools

Workday

PeopleSoft

Job description

We need Sr. Data Conversion Validater to support Budget team during the migration of budgeting and commitment control data from PeopleSoft to Workday.

Daily Task Need 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

Required Skills

• Min 7+ years of experience developing and executing data extraction and transformation processes for Budget and Finance.
• Min 7+ years of experience optimizing SQL queries, Application Engine, and SQR scripts for efficient data migration.
• Min 7+ years of experience mapping PeopleSoft data fields to Workday equivalents and resolving inconsistencies.
• Min 7+ years of experience implementing ETL tools and validating data accuracy post-migration.
• Min 7+ years of experience collaborating with functional teams and Workday consultants for seamless transition.
• Min 7+ years of experience developing and maintaining clear and consistent documentation for data and conversion processes and procedures.
• Min 7+ years 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.

$000,000 – $000,000 Salary range is not shown on the candidate portal