ODI Developer

New Hartford, Connecticut

GSK Solutions
Apply for this Job
Job Title: ODI Developer (Onsite - Locals Only)
Location: Hartford, CT
Duration: 6 Months+

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:

• 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

Recruiter Details:

Recruiter Name: Jyothi at gsksolutions dot com

Contact Number: Eight three two - nine nine zero - Two zero three nine
Date Posted: 31 March 2025
Apply for this Job