Description

You will manage the extraction of legacy PeopleSoft data to support integration with Workday Prism.

Responsibilities

• Extract HR and Fiscal PeopleSoft legacy data for loading into Workday Prism.
• Load and publish extracted data into Prism while validating data accuracy.
• Create reports in Prism using historical data merged with current Workday Financial and Human Resource system data.
• Provide guidance on best practices for extracting PeopleSoft data to ensure ease of joining report data between Prism and PeopleSoft.
• Collaborate with functional and technical staff during requirements gathering, design, and development phases.

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.
• Strong oral and written communication skills for technical and functional collaboration.
• Bachelor's degree or equivalent graduation.

Preferred Skills

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

Key Skills

Education

Any graduate