Job Description :
The Oracle/ PeopleSoft EPM BI Developer/ Administrator will be responsible for the installation, configuration, development and deployment of BI and supporting tools in EPM. Activities:
Customize and develop RPD layers of BI (Physical, BMM and presentation layers), configuring metadata objects and Web catalog objects.
Design and configure multidimensional ERDs (star and snowflake) schemas; data model.
Interpret complex delivered multi-dimensional ETL maps.
Oversee and/or assist in the design and development of multi-dimensional ETL maps and views.
Performance tune ETL jobs, BI tools, sessions and queries.
Participate in installation/ configuration of BI tools.
Participate in definition of Security in Oracle/PeopleSoft EPM and BI tool.
Develop reports, dashboards, and hierarchies and implement security using OBIEE.
Develop and test application messages, spreadsheet uploads, automated interface processes and tree imports/ exports.
Write SQL scripts and views.
Manage BI sessions, web browser, BI server and query cache.
Troubleshoot and resolve system and data issues.
Conduct unit, integration and user acceptance testing.
Participate in build out and test of cybermation batch schedule.
Participate in deployment of BI Solution.
Monitor, troubleshoot and resolve production support issues.
Pre-Requisites:
Experience in dimensional data modeling and data profiling experience for data warehouse development.
Experience with Enterprise data warehouse architecture and/ or design.
Experience in ETL development and system analysis.
Experience with Oracle/ PeopleSoft Enterprise 9.1+.
Experience PTools 8.54 or higher.
Multi-module experience preferred.