Watsonite Oracle Analytics Cloud Developer

We are seeking an experienced Oracle Analytics Cloud Developer with a strong focus on optimizing PeopleSoft reporting performance to join our team. The ideal candidate will have a robust background in Oracle Business Intelligence Enterprise Edition (OBIEE), data warehousing, and Oracle database optimization. This role involves designing, developing, and optimizing analytics solutions using Oracle's suite of tools, primarily focusing on the Oracle Analytics Cloud (OAC) while enhancing the speed and efficiency of PeopleSoft reports.

Key Responsibilities:

The Oracle Analytics Cloud Developer will design and develop high-performance OBIEE reports and dashboards, maintain dimensional data models in the OBIEE Repository (RPD) with a focus on the BMM layer, and optimize Oracle database queries through indexing and execution plan analysis. They will troubleshoot and enhance existing OBIEE reports, create custom reports with CSS styling, implement analytics solutions in the Oracle Analytics Cloud, and apply performance optimization techniques for PeopleSoft reports by refining SQL queries, leveraging caching, and scheduling reports during off-peak hours.

Required Skills:

Strong in OBIEE 11g/12c: Extensive experience with OBIEE development, configuration, and deployment. DWH Data Modeling Expertise: Proficient in data warehousing concepts and dimensional modeling techniques. Oracle Database Optimization: In-depth knowledge of query optimization techniques including indexing, partitioning, and understanding execution plans. OBIEE RPD Proficiency: Expertise in designing and managing the physical, BMM, and presentation layers of OBIEE RPDs, particularly focusing on BMM layer dimensional modeling. Report Optimization Skills: Strong troubleshooting skills for optimizing report performance and resolving query-related issues. Custom Report Development: Experience in building custom reports with a good grasp of CSS for styling enhancements. Oracle Analytics Cloud Experience: Familiarity with OAC functionalities and best practices. Understanding of PeopleSoft Tables: Good knowledge of Oracle PeopleSoft data structures as they relate to reporting in OBIEE.

Qualifications:

Bachelor's/BE/Master's degree in computer science, Information Technology, or a related field.

Minimum of 5 years of experience in Oracle analytics solutions, including OAC and OBIEE.

Strong problem-solving skills and ability to work independently or as part of a team.

Excellent communication skills to interact effectively with clients and stakeholders.

Excellent in troubleshooting