Senior Oracle Data Engineer

Role Summary

We are seeking an experienced Senior Data Engineer with hands-on mastery in Oracle Data Integrator (ODI) and deep understanding of ETL and ELT frameworks . This role centers on architecting robust data pipelines across on-prem and cloud Oracle ecosystems, automating ingestion from varied sources including APIs. Exposure to Oracle FDI (Fusion Data Intelligence) is a strong advantage.

️ Key Responsibilities

Design, develop, and optimize ETL / ELT data pipelines using Oracle Data Integrator (ODI)

Build and automate data ingestion workflows through Python and shell scripting

Integrate structured and unstructured data from APIs, databases, and cloud platforms

Configure ODI load plans, packages, and interfaces for scalable, high-performance data processing

Develop and maintain metadata layers, subject areas, and dashboards in OAC (RPD Modeling)

Collaborate with stakeholders to implement self-service analytics via OTBI and Oracle Cloud tools

Document integration logic and ensure transparency across transformation layers and data lineage

Work with architects and DBAs to implement security, governance, and compliance measures

Required Skills

Hands-on expertise in ODI Studio , Knowledge Modules , and Load Plan architecture

Proficiency in ETL / ELT frameworks , performance tuning, and staging optimization

Advanced scripting in Python and Unix shell for workflow automation and validation

Strong knowledge of API data integration , including authentication, filtering, and normalization

OBIEE experience with RPD modeling , dashboard development, and analytic views

Familiarity with OTBI and Oracle Fusion modules for transactional data access

Preferred Qualifications

Exposure to Oracle FDI (Fusion Data Intelligence) for cloud-native data modeling and insight generation

Experience with Oracle Cloud Infrastructure (OCI) and Oracle Autonomous Data Warehouse (ADW)

Candidate from OBIEE / BI Apps background is strongly preferred

Solid PL / SQL skills with a knack for query optimization

Excellent collaboration and communication skills across business and technical teams