Six months Contract with possible extension. Onsite position
Candidate must be local or willing to commute or relocate.
9 years 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
Type
| | Category | | Qualification | | Description | | Competency | | Required | | |
| | Skills | | Others | | APEX | | Oracle Application Express | | Novice (1-3 Years) | | No | |
| | Skills | | Others | | OBIA | | Oracle Business Intelligence Applicationa | | Advanced (7-9 Years) | | Yes | |
| | Skills | | Others | | OBIEE | | Oracle Business Intelligence Enterprise Edition | | Advanced (7-9 Years) | | Yes | |
•
Last updated on Mar 4, 2022