Supporting data warehousing, data modelling, data integration, business intelligence and Oracle fusion processes
Use Oracle Cloud Data Integration (OCDI) to create/update mapping using different transformations required to move data into data warehouse
Develops ETL’s using Informatica/OCDI to facilitate Extraction Transformation and data load from Oracle Cloud Fusion R13 22C CSM
Provide expertise of different modules within Oracle Fusion including BICC public view objects (PVO) associated with Oracle BI Applications
Determine data orchestration and storage needs – evaluate the exact storage needs for the current data situation and analyze different orchestration of data loading options into the EDW
Design and create a data warehouse – designs a data warehousing system that meets needs and work with a development team to build the warehouse – conceptual, logical and physical data models to include data conversion, data conversion and data mining.
Test and troubleshoot – test designs of new integration to ensure smooth operations and fix any issues that arise.
Design schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
Identify and capture lessons learned, best practices, and information gained during performance of tasks.
Qualifications:
US Citizenship is mandatory
Bachelor’s degree in engineering, or a related scientific or technical discipline with at least 4-6 years of relevant experience
Experience with Informatica Cloud, Oracle Cloud Fusion R13 22C CSM and Oracle Cloud Data Integration (OCDI)
Experience extracting and summarizing data from Oracle Cloud Fusion
Experience in using Oracle PLSQL or SQL Plus
Dimensional modelling experience
Experience interfacing with business users and consultants and understanding their requirements
Ability to learn and implement new and different techniques
Outstanding written and verbal communication skills