Oracle ODI Developer/ Expert / Hartford, CT ( Onsite ), 6+ Months Contract

ODI ExpertSix months contract with possible extension. Onsite position. This is NOT a remote position.Looking for ODI Expert Pre-Requisites/Activities:Over 9 years of experience with 4-5 years in ODI Development.Working knowledge in ODI 12cOversee 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:Experience with ODI 12CBIApps 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