Key Responsibilities:
-
Design, develop, and maintain BI dashboards, reports, and analytics using Oracle OBIEE and Oracle Analytics Server (OAS).
-
Develop data models, metadata repositories (RPD), and presentation layers in OBIEE/OAS.
-
Build and optimize ETL processes using Oracle Data Integrator (ODI) to extract, transform, and load data from various source systems.
-
Create and manage data pipelines, mappings, and workflows in ODI.
-
Design and optimize SQL queries, stored procedures, and views in Oracle Database to ensure efficient data retrieval.
-
Ensure data quality, consistency, and performance tuning across all BI layers.
-
Support and maintain existing BI solutions, performing troubleshooting, debugging, and enhancements as needed.
Required Skills and Qualifications:
-
Bachelor’s degree in Computer Science, Engineering, or related field.
-
3–7 years of hands-on experience as a BI Developer or Data Engineer using Oracle BI tools.
Strong expertise in:
-
Oracle OBIEE (RPD development, dashboards, reports, security setup)
-
Oracle Analytics Server (OAS) (modern analytics, self-service capabilities)
-
Oracle Data Integrator (ODI) (interfaces, packages, scenarios, scheduling, load plans)
-
Oracle Database (SQL, PL/SQL, performance tuning, data modeling)
-
Solid understanding of data warehousing concepts, ETL best practices, and dimensional modeling.
-
Experience in performance tuning of BI reports and ETL processes.
-
Strong analytical thinking, communication, and problem-solving skills.
-
Preferred Qualifications
-
Experience in migration or upgrade from OBIEE to OAS or Oracle Analytics Server.