US Citizen
Green Card
H1B Work Permit
Corp-Corp
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 15th Feb 2023
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: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.