Overview
Skills
Job Details
Job Role:
Job Locations : Malvern, Pennsylvania., Charlotte, NC
Job type: Full Time
Job Description:
" Oracle Analytics - Data engineer :
Strong Oracle SQL and PL/SQL skills
Solid experience with Oracle Database and Data Warehousing (ADW, ATP etc)
Comfortable with Git and version control
Experience with Oracle Cloud or similar (Oracle Integration, Oracle Object Storage, Oracle Data Integration Service is a plus, PySpark is a plus)
Some Python experience (a plus)
Expert knowledge in Autonomous Data Warehouse (ADW) and Oracle Integration cloud (OIC) .Experience building, deploying and scaling end to end solutions in Oracle Cloud using Autonomous Data Warehouse (ADW); including data ingestion, transformation, curation and visualization
Expert knowledge in using Oracle data integrator(ODI) and Oracle dataflow
Solid grasp of Oracle Database, Data Modelling, Oracle SQL Developer, Data Warehouse concepts, advanced analytics concepts, and implementation.
Working knowledge of Oracle Analytics Cloud (OAC), Oracle BI Repository (RPD)/Semantic modeler, Oracle Cloud Infrastructure (OCI) artifacts, Oracle object storage, other Oracle Business Intelligence Technologies like BICC, OTBI, etc.
Experience in data design, data modeling, data mapping, data interrogation, data quality, and master data management is desired.
Experience in Building data pipelines from multiple data sources by performing necessary ETL tasks including processing, cleansing, and verifying the integrity of data used for analysis.
Experience in handling large data sets by writing python programs using Apache spark.
Experience in developing integrations to/from Oracle Fusion (AR, AP, Procurement & GL modules) and EPM applications.