OBIEE Developer

Infojini Inc; New York (NY); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A leading IT services provider in New York is seeking an Oracle BI Specialist for a 12-month contract. This hybrid role requires expertise in Oracle technologies, ETL processes using ODI, and dashboard creation with OBIEE and Power BI. Ideal candidates will have at least 5 years of relevant experience, including Dimensional Data Modelling. Enjoy a dynamic work environment at the forefront of data integration and analytics.

Qualifications

• 5+ years of experience in Oracle technologies such as SQL and PL/SQL.
• 3+ years of experience in Dimensional Data Modelling.
• 5+ years of experience in ETL using Oracle Data Integrator (ODI).
• 5+ years of experience in creating Dashboards using Oracle OBIEE and Power BI.

Responsibilities

• Researching the backend database to identify required Objects.
• Creating Rest API’s in SOA/Fusion version 12.2.1.4.
• Creating ETLs using Oracle Data Integrator (ODI) Tool version 12.2.1.
• Creating Dimensional Model and Snowflake Schemas.
• Creating Dashboards and Reports using OBIEE and Power BI.

Skills

Oracle technologies (SQL, PL/SQL)

Dimensional Data Modelling

ETL using ODI

Dashboards using Oracle OBIEE

Power BI

Job description

Oracle BI Specialist

Location: New York, NY 10007 (Hybrid - 3-day onsite, 2 days remote)

Duration: 12 Months (with possible extension)

Working Hours: 35 hours/week

Daily Duties

• Researching the backend database to figure out the required Objects to work on
• Creating Rest API’s in SOA / Fusion version 12.2.1.4
• Creating the ETL's using Oracle Data Integrator (ODI) Tool version 12.2.1
• Creating Dimensional Model and Snowflake Schemas using Data Cardinality principles
• Creating Dashboards and Reports using OBIEE and Power BI

Skill Set

• Must have minimum of 5 years of proficient level experience in Oracle technologies such as SQL, PL/SQL
• Must have minimum of 3 years of proficient level experience Dimensional Data Modelling
• Must have minimum of 5 years of proficient level experience in ETL using ODI
• Must have minimum of 5 years of proficient level experience in creation on Dashboards using Oracle OBIEE and Power BI and custom reports
• Must understand Oracle SOA Dehydration Store schema structure to create custom ETL out of it for SOA / Fusion version 12.2.1.4

Seniority Level

Mid-Senior level

Employment Type

Contract

Job Function

Information Technology