Description :

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.

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

- 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

- Proficiency in SQL and PL/SQL is required for developing, optimizing, and maintaining data pipelines and stored procedures within our Oracle database environment.

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

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

Preferred Qualifications :

- Candidate from OBIEE /BI Apps background is strongly preferred

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

- Excellent collaboration and communication skills across business and technical teams