Oracle/PeopleSoft EPM Business Intelligence Developer/Administrator - Level 4./ Hartford,CT,6+ Month

Six months Contract with possible extension. Onsite position.**** This is NOT a REMOTE Position ****

looking for local candidates or candidates willing to relocate.

** Looking for ODI Expert **

9 yrs exp The Oracle/ PeopleSoft BI Developer/ Administrator will be responsible for the installation, configuration, development and deployment of BI and supporting tools.

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 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 Agent batch schedule.
Participate in deployment of BI Solution.
Monitor, troubleshoot and resolve production support issues.
Develop and maintain application using APEX (Oracle Application Express) tool

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.

• Specific skill with OBIEE/ OBI Apps/ ODI with exposure to PeopleSoft source data is preferred.

• Multi-module experience preferred.

• Working Knowledge in ODI 12c

• OBIEE/OBIA upgrade experience preferred. Knowledge in Upgrading ODI 11g to ODI 12c ( WebLogic and OBIEE Components)

• Experience with Oracle APEX (Oracle Application Express) desirable

Last updated on Apr 6, 2022