Oracle Analytics Cloud (OAC) Consultant
As an OAC Consultant, you will work with technical teams and projects to deliver cutting edge reporting solutions on Oracle cloud platforms for some of our Fortune 1000 clients. You will have the opportunity to build multi-cloud Enterprise Analytics platforms around Oracle and to migrate on-premise OBIEE platforms to OAC. You will closely work with clients to focus on outcome and deliver value, and work with Cloud Architects to develop high performance cloud analytics applications. Our teams have a diverse range of skills and we are always looking for new ways to innovate and help our clients succeed.
Work Youll Do
As OAC developer you will have multiple responsibilities depending on project type. One type of project may involve migrating existing applications to Oracle cloud infrastructure. Another type of project might involve building reporting solution on both on- premise and Oracle Cloud. The key responsibilities may involve some or all the areas listed below:
Engage with clients to
understand business requirements, document user stories and focus on user experience
build Proof-of-concept to showcase value of Oracle Analytics vs other platforms
socialize solution design and enable knowledge transfer
drive train-the trainer sessions to drive adoption of OAC
partner with clients to drive outcome and deliver value
Collaborate with cross functional teams to
understand dependencies on source applications
analyze data sets to understand functional and business context
understand Data Warehousing data model and integration design
understand cross functional process such as Record to Report (RTR), Procure to Pay (PTP), Order to Cash (OTC), Acquire to Retire (ATR), Project to Complete (PTC)
communicate development status to key stakeholders
Design, build, test and deploy
OAC repository (RPD) data models
OAC classic dashboards and reports with focus on user experience
DV workbooks with focus on exploratory analysis
BI Publisher data models and reports
BI Agents
Data and Object level security
High performance reporting platform to deliver a seamless user experience
Focus on designing, building and documenting re-usable code artifacts
Track, report and optimize OAC performance to meet client SLA
Migrate OBIEE artifacts from on-premise to OAC and fix issues
Identify risks and suggest mitigation plan
Document all processes and procedures in assigned areas of responsibility
Technical Requirements
Education: BE./B.Tech/M.C.A./M.Sc (CS)
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
4-8 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
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
Experience in Machine Learning