Oracle/PeopleSoft EPM Business Intelligence Developer/Administrator - Level 4/ Hartford,CT,24 Months

Candidate Must Be Local

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

Competitive Pricing and looking for local candidates or candidates willing to relocate.

** Looking for ODI Expert **

Pre-Requisites/Activities:

• Over 9 years of experience with 4-5 years in ODI Development.

• Working Knowledge in ODI 12c

• Oversee and/or assist in the design and development of multi-dimensional ETL/ELT maps and views.

• Interpret complex delivered multi-dimensional ETL maps.

• Performance tune ETL/ELT jobs, BI tools, sessions and queries.

• Write SQL scripts and views.

• Troubleshoot and resolve system and data issues.

• Participate in build out and test of Agent batch schedule.

• Conduct unit, integration and user acceptance testing.

Good to have/Desirable:

• Upgrade Experience converting mappings from ODI 11g to 12C

• BIApps Knowledge including subject areas like Financial Analytics, HR Analytics, Procurement and Spend etc.

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

• OBIEE Knowledge. 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.

• Develop reports, dashboards, and hierarchies and implement security using OBIEE.

• Participate in deployment of BI Solution.

• Develop and maintain application using APEX (Oracle Application Express) too

Last updated on May 4, 2022