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

REQUIREMENTS: • Total Experience 8+ 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.