Data Lake Engineer (Oracle Autonomous DB) - 100% Remote Job

Data Lake Engineer (Oracle Autonomous DB) - 100% Remote Job

Duration: 12 Months

Position Type: Contracting

Experience: 6+ Years

Rate: 1.00 LPM

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.