OBIEE Technical Lead

Gurus Infotech, Inc.

New York, NY, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

dice.com

Tech stack

Extract Transform Load (ETL) Web Servers Microsoft SQL Server Oracle Business Intelligence Enterprise Edition Oracle Databases Oracle (Applications) Performance Tuning SQL*Plus SQL Server Integration Services Bi Publisher Usage Tracking Star Schema

+1 more

Toad (Software)

Requirements

Experience in OBIEE RPD modeling, designing start/snowflake schemas
OBIEE Expert with a thorough understanding of OBIEE architecture and the role of different OBIEE components like Analytic Server, Web Server, RPD, Web Catalog, Security, Dashboards, Reports, iBots and Scheduler
Experience in writing and profiling complex PL/SQL queries and fetch appropriate data from huge data sets efficiently (SQL Server)
Experience in OBIEE Features (i.e. Cache, Usage tracking, Dimensional hierarchy, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical & Logical Data Modeling.
Possess good communication, interpersonal skills, an ability to quickly grasp new concepts- both technical and business related. Flexible and experienced to work independently or in a team environment.
Knowledge and Experience in Performance tuning.
Basic knowledge in ETL tools (Preferably SSIS).

Specialization Domains: Supply Chain, Warehouse Management Distribution Technologies: Oracle BI - OBIEE, Oracle Database tools like TOAD, SQL Plus and Oracle Tools