Job ID: CT-56928 (912290317)
Local OBIEE Developer/Admin with OBIA, APEX, ETL, data modeling, SQL, UAT, Agent batch, DW, ODI, PeopleSoft, WebLogic, and upgrade experience
Location: Hartford CT (Office of Policy and Management)
Duration: 6 months
Type CategoryQualification 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
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