Peoplesoft Developer

Client: Oakland County

Job Title: PeopleSoft Developer

Duration: 5+Month

Start Date: ASAP

Location: Pontiac, MI 48341 (Hybrid)

Position Type: Contract

Interview Type: Web Interview/ In-person

Ceipal ID: SMI_PEOP447_MA

SOW:

Seeking a PeopleSoft developer who is knowledgeable with PeopleSoft Financials and Human Resource Applications (currently on version 9.0) with expertise working with PeopleTools (currently on version 8.48). PeopleTools include Application Designer, DataMover, Configuration Manager and PeopleCode. Candidate must have good experience working with Oracle Database Enterprise Edition (currently on version 11g) which includes able to read database schemas, table keys and table relationships. Ability to use Oracle SQL Developer tool to write complex SQL scripts to join multiple tables and extract the data into delimited CSV file format. Candidate must have strong oral and written communication skills to work with functional and technical staff during requirements gathering, design and development of project. Preferred candidate would also have experience with Workday Prism as project assignment is to extract HR and Fiscal PeopleSoft legacy data to load into Workday Prism. This includes knowing how to load and publish the extracted data into Prism and able to validate data accuracy . Ability to create reports in Prism with historical data and merger current data from Workday Financial and Human Resource system. Candidate should be able to provide guidance and best practices on how to extract the PeopleSoft legacy data in a manner that it is easy to compose and join report data between Prism and Peoplesoft. Prefer local candidate as work environment is hybrid but remote only candidates will be considered based on qualifications.

Environment: PeopleSoft Application 9.0, PeopleTools 8.48, Application Designer, DataMover, PeopleCode, Configuration Manager, Oracle Database Enterprise Edition 11g, Oracle SQL Developer