Sr ETL Developer

Job ID: 19035515Reference Number: 23-00379Title: Sr ETL DeveloperLocation: Iselin, NJ, 08830Posted Date: 2023-02-15Company: HAN Staffing JOB DESCRIPTION Only US CITIZENS 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 8-10 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.