| immediate Sr ETL Developer at Dallas, Texas, USA |
| Email: [email protected] |
| From: Geetha, Paramount software solutions [email protected] Reply to: [email protected] Hi, Role: Sr ETL Developer Work location: DALLAS, TX (Remote) Duration: 6-8 months + Senior & Junior Only US CITIZENS JOB DESCRIPTION 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 ETLs 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 Bachelors 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. Regards, Geetha Raghavendra T: 770-299-4020 Keywords: business intelligence Texas |
| [email protected] View all |
| Wed Feb 22 01:00:00 UTC 2023 |