Primary skillsets
- 5 to 8 years of BI experience
- 5 years of experience on Informatica OBI OAC SQL minimum 2year experience on each of the tool mentioned Oracle Apex
- Must have worked on at least 2 complete life cycle implementations of BI projects
Detailed JD
Should have worked extensively in OAC RPD development involving time series calculations YTD measures and configuring securityExperience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business usersWorked to build complex reports in OAC in a performant way and has good understanding of role security aspectsData modelling expertise using STAR and SNOWFLAKE schema designShould have worked extensively in OAC RPD development involving time series calculations YTD measures and configuring securityExperience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business usersWorked to build complex reports in OAC in a performant way and has good understanding of role security aspectsShould have Strong knowledge of Oracle database PLSQL developmentMust know how to write advance SQL use Oracles SQL aggregate and analytic functionExpert in debugging optimizing and Performance Tuning of OAC visualizations Oracle BI Repository Dashboards ReportsRecognize and adopt best practices in reporting and analysis data integrity test design analysis validation and documentationUnderstand and design data models to setup robust Datawarehouse environmentHands on experience in tuning mappings identifying and resolving performance bottlenecks in various levels like sources targets mappings and sessionsMonitor and tune the performance of the OAC environmentSkills Required
snowflake , Plsql, Sql, Oracle Database, Datawarehousing