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 architectureProficiency in ETL / ELT frameworks, performance tuning, and staging optimizationAdvanced scripting in Python and Unix shell for workflow automation and validationStrong knowledge of API data integration, including authentication, filtering, and normalizationOBIEE experience with RPD modeling, dashboard development, and analytic viewsFamiliarity with OTBI and Oracle Fusion modules for transactional data access Preferred QualificationsExposure to Oracle FDI (Fusion Data Intelligence) for cloud-native data modeling and insight generationExperience with Oracle Cloud Infrastructure (OCI) and Oracle Autonomous Data Warehouse (ADW)Candidate from OBIEE / BI Apps background is strongly preferredSolid PL / SQL skills with a knack for query optimizationExcellent collaboration and communication skills across business and technical teams(ref : hirist.tech)