OBIEE, PL/SQL

Skill: OBIEE, PL/SQL

Experience: 4 to 9 Years

Location: AIA – Pune

Job description

We are seeking an experienced Lead OBIEE Developer with strong expertise in Oracle BI Publisher, OBIEE, SQL, and PL/SQL to join our team. The ideal candidate will be responsible for designing, developing, and supporting enterprise BI solutions, ensuring high-quality reporting, dashboards, and reconciliation models. This role requires strong analytical, troubleshooting, and communication skills with the ability to collaborate across ETL, application, and business teams.

Key Responsibilities

• Design, develop, and unit test OBIEE/BIP reports, ad hoc analyses, schedules, and dashboards.
• Develop and maintain the data layer, RPD, and web catalog in OBIEE.
• Work on Oracle database objects (tables, views, queries, functions, procedures).
• Perform query optimization and performance analysis to improve reporting efficiency.
• Design and develop reconciliation model-related reports and validations.
• Debug, analyze, and fix reporting issues in OBIEE and BI Publisher.
• Collaborate with ETL and application teams to troubleshoot and propose effective solutions.
• Support production activities, including data fixes, ETL validations, and end-user queries.
• Review and resolve issues in reports, schedules, and connections.
• Communicate effectively with end users and stakeholders regarding issues, fixes, and validations.
• Lead and mentor junior developers in OBIEE and BI reporting best practices.

Required Skills

• Strong hands-on experience with Oracle OBIEE 12c (Reports, Analysis, Dashboards, BI Publisher).
• Proficiency in Oracle SQL and PL/SQL (queries, stored procedures, functions, performance tuning).
• Experience in RPD maintenance, web catalog management, and data layer design.
• Strong debugging and analytical skills, including reconciliation model understanding and report-to-report validation.
• Excellent communication skills (email and verbal).

Secondary Skills

• Knowledge of OBIEE/BIP scheduling and admin functions.
• Experience with connection management and report automation.
• Familiarity with data validation and production support processes.