Description :

- Extensive experience in Oracle Data Integrator (ODI) architecture, design, and implementation.

- Proven expertise in designing large-scale ODI data integration pipelines for enterprise systems.

- Strong experience implementing end-to-end data pipelines from Oracle EBS R12 (on-premise) to Oracle Autonomous Data Warehouse (ADW).

- Expertise in ODI architecture, repository design, knowledge modules customization, and performance optimization.

- Strong experience in data warehouse design, dimensional modeling, and data integration frameworks.

- Experience designing scalable ETL frameworks, reusable ODI components, and automation pipelines.

- Strong expertise in data extraction strategies from Oracle EBS R12 modules (Finance, SCM, Procurement, etc.).

- Experience in high-volume data processing and performance tuning of ODI jobs.

- Strong knowledge of Oracle SQL, PL/SQL, and advanced transformation logic.

- Experience working with Oracle Autonomous Data Warehouse (ADW) as target for enterprise analytics platforms.

- Exposure to Oracle Analytics Cloud (OAC) for analytics, reporting, and semantic modeling is an added advantage.

- Experience leading data integration teams and mentoring developers.

- Strong stakeholder communication and solution design capabilities.

Responsibilities :

- Lead the design and implementation of enterprise data integration pipelines using ODI.

- Architect ODI-based data pipelines extracting data from Oracle EBS R12 and loading into ADW.

- Define ETL architecture standards, frameworks, and best practices.

- Optimize ODI performance for large datasets and complex transformations.

- Work with business and analytics teams to define data models and data integration strategies.

- Lead ETL design reviews, code reviews, and architecture governance.

- Implement data quality, data validation, and monitoring mechanisms for ODI pipelines.

- Provide technical leadership and mentoring to ODI developers.

- Support integration of ADW datasets with OAC analytics platforms.

- Drive continuous improvement in ETL frameworks, automation, and performance tuning.