OACS Developer

Primary skillsets

1. 5 to 8 years of BI experience
2. 5 years of experience on Informatica OBI OAC SQL minimum 2year experience on each of the tool mentioned Oracle Apex
3. Must have worked on at least 2 complete life cycle implementations of BI projects

Detailed JD

1. Should have worked extensively in OAC RPD development involving time series calculations YTD measures and configuring security
2. Experience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business users
3. Worked to build complex reports in OAC in a performant way and has good understanding of role security aspects
4. Data modelling expertise using STAR and SNOWFLAKE schema design
5. Should have worked extensively in OAC RPD development involving time series calculations YTD measures and configuring security
6. Experience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business users
7. Worked to build complex reports in OAC in a performant way and has good understanding of role security aspects
8. Should have Strong knowledge of Oracle database PLSQL development
9. Must know how to write advance SQL use Oracles SQL aggregate and analytic function
10. Expert in debugging optimizing and Performance Tuning of OAC visualizations Oracle BI Repository Dashboards Reports
11. Recognize and adopt best practices in reporting and analysis data integrity test design analysis validation and documentation
12. Understand and design data models to setup robust Datawarehouse environment
13. Hands on experience in tuning mappings identifying and resolving performance bottlenecks in various levels like sources targets mappings and sessions
14. Monitor and tune the performance of the OAC environment