Description

You will extract legacy PeopleSoft data for Workday Prism integration, ensuring accurate loading and reporting.

Responsibilities

• Extract HR and Fiscal PeopleSoft legacy data for Workday Prism loading.
• Load and publish extracted data into Prism while validating data accuracy.
• Create reports in Prism by merging historical data with current Workday Financial and Human Resource data.
• Provide guidance on PeopleSoft data extraction best practices to facilitate joining report data.
• Collaborate with functional and technical staff during requirements gathering, design, and development.

Required Skills

• Experience with PeopleSoft Financials and Human Resource Applications (version 9.0).
• Proficiency with PeopleTools 8.48, including Application Designer, DataMover, Configuration Manager, and PeopleCode.
• Working knowledge of Oracle Database Enterprise Edition 11g.
• Ability to read database schemas, table keys, and table relationships.
• Experience using Oracle SQL Developer to write complex SQL scripts for joining multiple tables.
• Ability to extract data into delimited CSV file formats.
• Bachelor's degree or equivalent graduation.

Preferred Skills

• Experience with Workday Prism, specifically loading, publishing, and reporting on data.

Key Skills

Education

Any graduate