Oracle Analytics Cloud and Fusion Analytics Warehouse Consultant
Centroid is looking for a Senior Oracle Analytics Cloud Consultant. We are seeking candidates that have expert level experience with OAC, Oracle Fusion Analytics Warehouse and preferably with BI Applications experience as well.
Start date: ASAP
Employment Type: Full time employee, Contract, Contract to Hire
Location: 100% Remote
Oracle Analytics and BI Classic Foundation Experience:-
Hands on Experience in Designing and Developing Data Visualizations in OAC
-
Experience working with Data Sets, building data flows to combine different sources of data and presenting them to the users via data visualizations
-
Hands on experience in utilizing the different machine learning algorithms for predicting and identifying patterns and “hidden” relationships within the data
- Hands on experience with the BI Classic (aka OBIEE) functionality including designing, developing & deploying RPD, including physical layer, business model and mapping layer, and presentation layers in OAC BI Classic and OAS/OBIEE 12c.
-
Experience creating Semantic Models using OAC’s Semantic Modeler.
-
Hands on experience in developing and deploying Analysis, Dashboards, BI Publisher, and Web Catalog.
-
Experience developing complex data models and RTF templates using BI publisher.
-
Experience with different migration techniques to promote objects, projects, etc. within different environments
-
Experience with advanced OAC features for performance tuning such as aggregates and cache management.
-
Experience modeling and implementing security at object and data levels.
Oracle Fusion Data Intelligence/FDI (formerly known as: Fusion Analytics Warehouse/FAW) Experience:-
Experience implementing and extending Fusion Analytics Warehouse.
-
Experience with Data Extensibility, loading data from different sources into the shared ADW and use connectors to add or enrich the data using Oracle Data Integrator (ODI).
- Experience with Security Extensibility to create custom roles and predicates to manage authentication, authorization and data access.
- Experience with Analytic Modelling Extensibility to extend the packaged semantic model with custom subject areas, metrics, dimensions and hierarchies.
-
Experience with Presentation Extensibility to build custom KPIs, reports and dashboards.
-
Experience with Fusion Applications as a source for FAW
-
Experience developing and extending ETL data mappings in Oracle Data Integrator (ODI)
-
Experience with tuning data integration flows to ensure optimum use of resources.
Oracle BI Applications Experience:-
Experience implementing and extending BI Analytics Applications/Offerings (Financial Analytics, Sales Analytics, Procurement & Spend Analytics, Supply Chain Analytics, Apps Service Analytics.) for Oracle E-Business Suite (EBS).
-
Experience developing and extending ETL data mappings in Oracle Data Integrator (ODI) and Informatica.
-
Experience with tuning data integration flows to ensure optimum use of resources.
-
Experience developing and extending the Oracle Business Analytics Warehouse.
Oracle Database and Data Warehousing Experience:-
Data warehouse design and development experience.
-
Excellent command of Data Warehousing, OLAP, and ETL best practices.
-
Expertise in understanding Oracle database and OLAP concepts.
-
Data modeling expertise with relational, multi-dimensional, and star and snowflake schemas.
-
Proficient use of Oracle technologies like materialized views, PL/SQL, & Stored Procedures (triggers, functions).
General Experience:-
3+ years of experience in Oracle Analytics Cloud
-
4+ years of combined experience in the different releases of OBIEE (Oracle Business Intelligence Suite Enterprise Edition) or Oracle Analytics Server.
-
3+ years of Oracle FAW experience including ODI.
- Oracle BI Applications experience is a plus.
Education Required:-
Bachelor's degree in Computer Science, Business Information Systems, or Computer Information Systems or equivalent required. Master’s degree preferred.