The purpose of this PeopleSoft Developer role is to perform a variety of advanced professional duties in the analysis, design, development, testing, installation & maintenance of large-
scale complex applications with overall responsibility for system development, upgrades, maintenance & production performance.
Role serves as a technical expert on the use of PeopleSoft technologies.
Specific role responsibilities :
o Develop structured parent / child data record structures
o Develop multi-page / multi-record components
o Understand & perform search records & usage
o Knowledge of File Attach architecture
o Knowledge of PeopleCode language
o Perform efficient data retrieval & manipulation (SQLExec, SQL Objects, SQL Fetch etc.)
o Perform component buffer data manipulation (Rowset processing etc.)
o Debug online problems such PeopleCode & SQL errors & incorrect functionality
o Perform App Package coding & referencing
o Manage PeopleSoft security, roles, permission lists etc.
o Develop structured & maintainable AE programs
o Understand & appropriate use of AE actions including SQL, PeopleCode, Call Section & looping actions (e.g. Do Select, Do While)
o Experience using dynamic call sections
o Use of app engine libraries
o AE Reporting solutions (e.g. stage data & generate via BI Publisher)
o AE Interface solutions & use of file layout objects (for reads & writes)
o Trace & debug AE processes
o Strong understanding of relational database concepts, indexing etc.
o Write structured SQL containing multiple tables
o Debug SQL
o Knowledge in Advanced SQL concepts such as in-line views, analytical functions etc.
o Tune SQL to achieve optimal performance
o Understand & use of BI Publisher
o Knowledge of IB configuration & structure
o Build message schemas
o Create & configure service operations
o Create PeopleCode events to be referenced by handlers
o Analyze functional specifications to facilitate successful development in line with business requirements
o Liaise with functional team to clarify business requirements & resolve issues
Knowledge / Skills / Abilities
o Enterprise Learning Management (ELM)
o Global Payroll