Oracle/PeopleSoft EPM Business Intelligence Developer/Administrator

Job Title: ODI Developer/Administrator - IV (Locals Only - Onsite)

Location: Hartford, CT

Duration: 6 Months (Extension possible for six months)

Job Type: C2C ,1099, Contract W2

Job Description:

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) tool

About GSK Solutions Inc.:

GSK Solutions Inc. is a leading information technology (IT) Services Company that specializes in providing complete consulting solutions and staff augmentation to its clients. We provide on-time, on-budget, and quality service to our clients and consistently meet their expectations. We are known for our superior execution on a sustained basis.