OBIEE Technical Lead/Architect

TekFortune INC

Miami, FL, United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

6 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Information Systems 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

+3 more

Information Technology Star Schema 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).

Education/Experience : Bachelor s Degree or equivalent in Computer Science, Information Systems or related field and 6-10 years of relevant experience. Specialization Domains: Supply Chain, Warehouse Management Distribution Technologies: Oracle BI - OBIEE, Oracle Database tools like TOAD, SQL Plus and Oracle Tools