Required Technical Skill Set
- Minimum 5+ years of experience in OBIEE development, support and Maintenance.
- Experience in Oracle PL/SQL (packages, functions, Collections etc..).
Desired Experience Range : 5 - 6 years
Desired Competencies (Technical/Behavioral Competency)
- Understanding and Collecting requirements from Business user side or Business Analyst and make the model using the requirement.
- Working with OBIEE Administration Tool.
- Converting Complex SQL query solutions in to OBIEE model solutions.
- Working with 3 layers of RPD
- Performance tuning of OBIEE Application at repository level.
- Security implementation of OBIEE repository level.
- Translating business requirements in to technical requirements.
- Implementing Repository variables as well as system variables as per business requirement.
- Working with PL SQL Procedures,Functions,Packages,Views,Materialized views whenever necessary.
- Adding current columns in OBIEE Reports as per business requirement.
- Working with aggregates,cubes,hierarchies whenever necessary.
- Enhancing the reports as per customer requirements.
- Understand the business requirement and implement different graphs,charts as per requirement.
- Creating interactive dashboards as per business requirement.
- Working with Scheduling the different reports as per requirement.
- Working with Cache feeding techniques at application level.
- Giving rights and access to the specific reports and dashboards.
- Understand the OBIEE application performance issues and provide solution.
Responsibility of / Expectations from the Role
Design, develop and maintain OBIEE reports, dashboards, and analytics solutions.
Collaborate with business users to gather requirements and translate them into technical specifications.
Create and Optimize SQL queries and database objects for data extraction and transformation.
Ensure data quality and accuracy in OBIEE reports and dashboards.