OBIEE Developer : Experienced Professional Interview Questions

Dear All,

Oracle Business Intelligence Foundation Suite 11g provides comprehensive capabilities for business intelligence, including enterprise reporting, dashboards, ad-hoc analysis, multi-dimensional OLAP, scorecards, and predictive analytics on an integrated platform. It is also a core component of Oracle Exalytics, the industry’s first engineered in-memory analytics machine designed to deliver extreme performance.



Business Intelligence has widely captured the IT industry. There are various jobs available for an OBIEE developer. As the world is progressing, so is the data, so is the business, so is the need of the decision, so is the reporting, so is the OBIEE, and last but not the least OBIEE Developer.

Here in this post, I will be putting the list of questions that are being asked when you will appear for an interview for a OBIEE Developer job profile. I will keep updating this post so as to add more questions.
please find below the list of the questions:

Star Schema

Snow Flake Schema

Bridge Table

Slowly Changing Dimension

Dimensional Modelling

OLTP versus OLAP

ER Modelling

Best practices in RPD

Good practice for connection pool

Authentication and Authorization

Aggregate Navigation

Time series Functions

Expression builder -> Logical column

Example of different variables in OBIEE 11G

Column Selector

View selector

Guided Navigation

Different views in OBIEE 11g Analysis

Architectural difference between OBIEE 11G and OBIEE 10G

Tuning OBIEE Reports

Write Back in OBIEE 11G

Uses of EM and Console Link

Grain

Slice and Dice


We will keep updating the post.

If you need the answers of all the questions, please reach to me at shuklaangadkumar@gmail.com

Thanks and Regards,
Angad