Data Lake Implementation Specialist (Oracle Autonomous DB / OCI / ODI)

Data Lake Implementation Specialist (Oracle Autonomous DB / OCI / ODI)

Overview

We are seeking a highly skilled and hands-on Data Lake Implementation Specialist

with expertise in building data lake solutions on Oracle Autonomous Database. The

ideal candidate will have deep technical knowledge of Oracle Cloud Infrastructure

(OCI) Data Integration, Oracle Data Integrator (ODI), Oracle Data Transform, ETL job

scheduling, and API integrations. This role requires strong experience in designing

and implementing database structures, integrating data pipelines, and ensuring

scalable and efficient data solutions in cloud and object storage environments.

Key Responsibilities

• Design, develop, and implement data lake solutions on Oracle Autonomous

Database.

• Proficient knowledge in creating data pipelines using Oracle Transform

• Create and manage database schemas, tables, partitions, and indexes within

Oracle Autonomous DB.

• Work with OCI Data Integration and ODI to build and optimize data pipelines

for ingestion, transformation, and loading.

• Design and manage data ingestion frameworks from multiple sources

(structured, semi-structured, unstructured).

• Implement and optimize ETL processes, including job scheduling and

automation.

• Integrate with external systems and applications through APIs.

• Manage and optimize Object Storage usage for data storage and retrieval.

• Ensure data security, governance, and compliance in all implemented

solutions.

• Collaborate with architects, data engineers, and business stakeholders to

translate requirements into scalable data solutions.

• Monitor, troubleshoot, and optimize data workflows for performance and cost

efficiency.

Required Skills & Qualifications

• Proven experience in building and implementing data lakes on Oracle

Autonomous Database.

• Strong expertise in Oracle Cloud Infrastructure (OCI) Data Integration and

Oracle Data Transform & ODI

• Hands-on experience with ETL development, job scheduling, and process

orchestration.

• Strong knowledge of database design, optimization, and performance tuning

in Oracle Autonomous DB.

• Experience with Object Storage (Oracle or equivalent cloud storage).

• Solid understanding of API-based data integration and automation.

• Proficiency in SQL, PL/SQL, and scripting languages (Python/Shell preferred).

• Strong troubleshooting skills and ability to optimize large-scale data

workflows.

• Excellent communication and collaboration skills to work with cross-functional

teams.

Preferred Qualifications

• Oracle Certified Professional (OCP) or OCI certifications in Autonomous

Database / Data Integration.

• Experience with real-time data streaming tools (e.g., Kafka, GoldenGate, or

equivalent).

• Familiarity with data governance and security best practices in Oracle Cloud.

• Experience in data analytics and reporting integration with Autonomous DB.