OBIEE Developer

Position Function :

This position is responsible for the development and support of ETL’s used for loading Oracle Business Intelligence Data Warehouses. The ETL tools used for loading is Oracle Data Integrator (ODI). The candidate will be required to implement ETL’s between Oracle EBS, cloud bases data sources, third party environments and the Oracle BI Data Warehouses. Primary responsibilities include designing, implementing and supporting all areas of data loading process as well as troubleshooting, monitoring and coordinating the release of ETL processes.

Essential Duties and Responsibilities

Overall technical owner and administrator for OBIEE and any supplemental BI Solutions.

Maintain daily ETL loads and work with offshore team leading the development of ODI interfaces and the Datawarehouse additions.

Development of new data models

Create Datawarehouse data marts and subject areas in OBIEE for Business Intelligence, Reporting and Analytics.

Gain an understanding from business users of requirements for reporting Metrics, KPIs and standard analytics. Transform these requirements into Business Intelligence solutions available to end users.

This position is responsible for maintaining a very high level of technical expertise on industry standards concerning business intelligence applications and processes.

Document and deliver technical specifications

Skills / Experience Requirements

5+ years’ years of experience designing, developing, and supporting complex data warehousing, data marts and ETL environments in a senior position. Proven experience in performing conceptual, logical, and physical data modeling in a highly complex environment.

5+ years using : Oracle E-Business Suite (12.x or higher)

Oracle BI Applications (OBIA) exposure to versions 11.1.1.10 +

Exposure to Microsoft SSIS 2022

Strong proven expertise in PL / SQL and Data Modeling

Exposure to Oracle Analytics Server is beneficial

Experience developing, designing and maintaining Cloud data extracts

Excellent communication and documentation skills

Must have expertise in the following :

ODI with BI Apps (OBIA) 11.1.1.10

ODI11.1.1.9 / 12c

OBIEE 11g\12c Repository (RPD)

Oracle Analytics Server

Exposure to BI Cloud adaptors