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.
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: IT & Information Security
Role Category: IT Infrastructure Services
Role: IT Infrastructure Services - Other
Employement Type: Full time
Contact Details:
Company: FCS Infotech Thane
Location(s): Mumbai
Keyskills:
Data Lake Implementation Specialist
Oracle Data Integrator
Oracle Data Transform
oci
ODI