REQUIREMENTS:

Total Experience 9+ Years
Strong expertise in Oracle Data Integrator (ODI) architecture, design, and implementation.
Strong experience in data integration and data warehousing.
Proven experience building large-scale, enterprise data integration pipelines.
Hands-on experience implementing end-to-end ETL pipelines from Oracle EBS R12 (on-premise) to Oracle Autonomous Data Warehouse (ADW).
Deep understanding of ODI components including repository design, Knowledge Modules (KM), and customization.
Strong experience in performance tuning and optimization of ODI jobs.
Expertise in data warehouse design and dimensional modeling (star/snowflake schemas).
Experience designing scalable ETL frameworks, reusable components, and automation pipelines.
Strong knowledge of data extraction from Oracle EBS modules (Finance, SCM, Procurement, etc.).
Proficiency in Oracle SQL and PL/SQL with complex transformation logic.
Experience handling high-volume data processing.
Familiarity with Oracle Autonomous Data Warehouse (ADW).
Exposure to Oracle Analytics Cloud (OAC) is an added advantage.
Strong leadership, communication, and stakeholder management skills.
Experience mentoring and guiding development teams.

RESPONSIBILITIES:

Lead and manage the technical execution of Oracle EBS to Oracle Fusion Cloud migration projects.
Lead the design and implementation of enterprise data integration solutions using ODI.
Architect and develop ODI pipelines to extract data from Oracle EBS R12 and load into ADW.
Define ETL standards, frameworks, best practices, and governance models.
Optimize ODI jobs for performance, scalability, and reliability.
Collaborate with business and analytics teams to design data models and integration strategies.
Conduct design reviews, code reviews, and ensure adherence to architecture standards.
Implement data quality checks, validation rules, and monitoring mechanisms.
Provide technical leadership and mentor ODI developers.
Support integration of ADW data with reporting and analytics platforms like OAC.
Drive continuous improvement in ETL processes, automation, and performance tuning.

Senior Staff Engineer, ERP Oracle Technical (ODI & EBS)

Job Description