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.
- 37 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.
