The ideal candidate will design, develop, and maintain Oracle OBIEE and BIP reports, dashboards, and data reconciliation models.
This role involves close collaboration with ETL, application teams, and end users to deliver high-quality solutions.
Key Responsibilities:
· Design, develop, and test Oracle OBIEE/BIP reports, ad-hoc analyses, dashboards, and report schedules.
· Maintain and enhance the data layer, RPD (Repository), and web catalog in OBIEE version 12c.
· Develop reconciliation model-related reports and perform report-to-report comparison and validation.
· Conduct Oracle query performance analysis and implement necessary fixes.
· Debug and resolve report issues, ensuring timely and efficient production support.
· Collaborate with ETL and application teams to address report-related challenges and suggest solutions.
· Assist in production support activities such as data fixes, source data validation for ETL, and report validation.
· Communicate effectively with end users to understand requirements, provide fixes, and validate solutions.
Required Skills:
· Expertise in Oracle OBIEE version 12c, including:
o BIP Reports
o OBIEE Reports/Analysis/Dashboards
o Scheduling reports
o Data layer and RPD maintenance
o Web catalog maintenance
· Strong knowledge of Oracle Database, including tables, views, queries, functions, and procedures.
· Experience in Oracle query performance analysis and optimization.
· Debugging skills and understanding of reconciliation models.
· Secondary skills: Scheduler and admin functions (OBI and BIP), connection management.
·
Experience Required:
· 4+ years of relevant experience in Oracle OBIEE and BIP development.