Job Description :
The Oracle/ PeopleSoft EPM Technical Analyst will be responsible for design, development and test modifications to optimize the Oracle/ PeopleSoft EPM data staging, reporting, analytics and BI environments and troubleshooting production issues.
Activities:
Analysis, development and maintenance of staging/ reporting/ view tables, ETL maps and public queries in the Oracle/ PeopleSoft EPM OWS, OWE and MDW or Oracle Business Intelligence (“BI”) Applications.

Develop, maintain and process XLS, XML and CSV FTP files for in/ outbound interfacing. Develop Cybermation batch job control scripts.
Develop and performance tune SQL statements.
Troubleshoot EPM production issues.
Analyze and install Oracle/ PeopleSoft updates, fixes and bundles.
Participate in installation and configuration of BI technology.
Participate in implementation of EPM business intelligence and analytical reporting.
Perform conversion of historical data to retire legacy information systems.
Develop reporting approach to provide access to information from retired systems.
Work with developers to determine optimal ETL, PS Query and batch performance.

Mandatory:

Experience working with Oracle/ PeopleSoft EPM 9.1 is required.
Experience working with PeopleTools 8.54 or higher.
Strong ETL experience in Ascential 7.5.2 or higher is required.
Advanced PL/SQL skills are required.
Analytical problem solving and excellent written/oral communication skills are also required.
Experience with Oracle Data Integrator (“ODI”) is preferred.
Experience developing EPM business intelligence and analytical reporting.
Experience with OBIEE is preferred.
Experience with PilotFish is preferred.
Experience with Ascential DataStage ETL or ODI is preferred.
Experience with EPM Oracle/ PeopleSoft Analytics is preferred.