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

5 - 9 years

12 - 22 Lacs

Posted:1 month ago| Platform: Naukri logo

Apply

Work Mode

Remote

Job Type

Full Time

Job Description

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You