Oracle PL SQL with OBIEE

3-5 Years

Save

Early Applicant

Job Description

Key Responsibilities

Design, develop, and optimize PL/SQL packages, stored procedures, functions, triggers, and queries.
Perform data modelling, ETL processing, and database performance tuning.
Develop, enhance, and maintain OBIEE dashboards, analyses, KPIs, and reports.
Translate business requirements into technical specifications and reporting solutions.
Work on data extraction, transformation, and loading to support reporting needs.
Collaborate with cross-functional teams to troubleshoot and resolve complex database and reporting-related issues.
Ensure accuracy, quality, and integrity of data across systems.
Participate in code reviews, UAT support, and production release activities.
Maintain documentation for all database and BI solutions developed.

Required Skills & Qualifications

Bachelor's degree in Computer Science, Information Technology, or related field.
35 years experience in Oracle PL/SQL development.

Strong proficiency in:

Writing advanced PL/SQL queries, packages, functions, and procedures
Performance tuning and optimization
Data modelling concepts
Hands-on experience with OBIEE (Oracle Business Intelligence Enterprise Edition), including:
Repository (RPD) development
Dashboard and analysis creation
BI Publisher (optional but preferred)
Experience working with large datasets and complex relational databases.
Strong analytical and problem-solving skills.
Ability to work independently and in team-oriented environments.

Preferred Qualifications