OAC (Oracle Analytic Cloud) OR Oracle Fusion Warehouse OR FDI Dev.

Role & responsibilities

Technical Requirements

Strong knowledge of SQL and PL/SQL is foundational to optimize query performance

Strong knowledge of RPD development focused on complex cross functional data models

Experience of working with OBIA RPD and FAW Data modeler is desirable

Experience in designing complex OAC reports and dashboards and interactive workbooks in DV

Experience in designing data flows to create business defined data sets

Experience in designing and configuring IDCS Groups and Application roles for Object level security and Data level security in OAC

Experience with one or more relational Oracle Databases (ADW and ExaCS preferred)

Experience with ODI tool to back track integration design

Prior experience of OBIA implementation, OBIEE to OAC migration or OBIEE upgrades is desirable

Fair understanding of the agile and waterfall development process

Excellent understanding of Oracle Cloud platform and services

Any Oracle Cloud Certifications in OAC, ADW or Architect certification is a plus

Consulting Requirements

3-6 years of relevant consulting, industry or technology experience

Proven knowledge of Oracle Analytics Cloud platform and tools

Independent, detail oriented, responsible team player with strong interpersonal and written communication skills

Ability to work in fast paced environment and deal with ambiguity

Coach and mentor junior resources

Strong problem solving and troubleshooting skills

Willingness to travel in case of project requirement

Ability to adapt quickly to an existing, complex environment and learn new concepts and software

Passionate about building high-performance cloud based applications

Professionalism and integrity

Preferred candidate profile

Experience in Oracle BI Apps (RPD, Data model and ERP source design)

Business Process understanding of RTR, PTP, OTC, ATR, and PTC

Experience with Fusion Analytic Warehouse Data modeler, augmentation and security design

Experience of performance tuning in Cloud based Databases such as ADW and ExaCS

Oracle Cloud Platform Enterprise Analytics certified

Exposure to one or more of the following: Python, R or UNIX shell