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

ODI ExpertCandidate Must Be LocalSix 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.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