Data lake implementation specialist

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.

Job Types: Full-time, Permanent

Pay: ₹200,000.00 - ₹220,000.00 per month

Benefits:

• Health insurance
• Provident Fund

Work Location: In person