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 solid 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