Job Description

Position: Oracle SQL and PL/SQL Consultant

Location: Malvern, PA

Job Mode: Contract

Job Description:

• 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.

Job Tags

Similar Jobs