Description

You will design, develop, and optimize ETL processes within an Oracle Cloud Infrastructure and Oracle Autonomous Data Warehouse environment.

Responsibilities

• Design and implement ETL scripts and jobs using Oracle Data Integrator (ODI) to move data from various sources to target warehouses.
• Create and maintain data pipelines that transform data according to business rules.
• Develop physical data models and document data mappings, lineage, and the Kimball Dimensional Data Modeling Framework.
• Troubleshoot data quality issues, resolve performance bottlenecks, and monitor the Enterprise Data Warehouse for incidents.
• Collaborate with stakeholders to develop requirements, design specifications, and testing plans.

Required Skills

• Minimum 7 years of experience in database design, development, and warehouse architecture in an Oracle environment.
• At least 2 years of experience performing ETL development in Oracle Autonomous Data Warehouse (ADW) within Oracle Cloud Infrastructure (OCI).
• 5 years of experience developing in Oracle data warehouses within the last 10 years.
• 5 years of experience performing ETL activities using Oracle tools.
• Strong proficiency in Oracle Database, PL/SQL, and SQL.
• Hands-on experience with Oracle Data Integrator (ODI) or Oracle GoldenGate.
• Solid understanding of data warehousing concepts and dimensional modeling.
• Proven ability to develop testing approaches, plans, and documentation.

Preferred Skills

• Oracle Autonomous Database Cloud or Oracle Machine Learning specialist certifications, or Oracle Cloud Infrastructure 2021 Certified Architect Professional.
• Technical leadership experience covering data modeling, DBA, and warehouse administration.
• Familiarity with Oracle Business Intelligence Enterprise Edition (OBIEE).

Key Skills

Education

Any Gradute