Oracle ODI Developer -ETL, SQL, OBIEE

Role: Oracle ODI Developer -ETL, SQL, OBIEE

Duration: 6 Months (Contract)

Location: Hartford, CT (On-Site)

Key Skills: Oracle Data Integrator 12C, ETL, BI, SQL, OBIEE

Requirements: • 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: • Experience with ODI 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

Email your resume to: [email protected]

To learn more about Mavensoft visit us online at http://www.mavensoft.com/