Oracle ODI/BIAPPS Analyst

We are seeking a skilled Oracle Data Integrator (ODI) Developer with strong experience in designing, developing, and maintaining ETL processes within the Oracle BI ecosystem. The ideal candidate will have deep expertise in ODI, along with exposure to BIAPPS/OBIA and Oracle databases, and will play a key role in data integration, transformation, and data pipeline optimization. This role is highly technical and requires hands-on development, troubleshooting, and performance tuning of data integration processes supporting enterprise reporting and analytics solutions.

• Design, develop, and maintain ETL workflows using Oracle Data Integrator (ODI)
• Develop and optimize data extraction, transformation, and loading (ETL) processes from multiple source systems
• Work on BIAPPS/OBIA data pipelines, including customization, extensions, and enhancements
• Troubleshoot and resolve data load failures, performance issues, and data quality problems
• Perform ODI repository management, including versioning and migration across environments
• Write and optimize complex SQL queries for data transformation and validation
• Collaborate with BI and reporting teams (OAS, OBIEE, BI Publisher) to ensure accurate and timely data delivery
• Support production deployments, monitoring, and performance tuning of ETL jobs
• Maintain documentation for ETL processes, data mappings, and transformation logic
• Work closely with business and technical teams to understand data requirements and deliver scalable solutions

• 8+ years of experience in ETL development / Business Intelligence Analyst in IT or BI environments
• Strong hands-on experience with Oracle Data Integrator (ODI) 
• Experience with Oracle BI Applications (BIAPPS) / OBIA is highly preferred
• Strong expertise in SQL and Oracle Database concepts
• Experience working with ETL performance tuning and optimization
• Exposure to OAS / OBIEE / BI Publisher is a plus (supporting role, not primary focus)
• Knowledge of Manufacturing and Supply Chain data domains is a plus.
• Experience with Oracle E-Business Suite (EBS) modules (Inventory, Purchasing, Order Management) is a plus
• Strong problem-solving and debugging skills
• Experience gathering and documenting reporting requirements and converting them into BI solutions is a plus.

Education Requirements

• Bachelor’s degree in information technology, business or equivalent

Special Requirements: 

Communications – Excellent written and oral English communication skills a good listener with a team player attitude, problem solving, negotiation, issue management, and mediation, and have good technical documentation skills are essential for this position.

Overall – Ability to work in fast paced environment being self-motivated, pleasantly aggressive and assertive, realistically ambitious with high personal ethics.  Develop a professional relationship with co-workers and end-users with a positive influence. Have the discipline to follow established methodology while seeking ways to improve the process.

DISCLAIMER

All the above duties and responsibilities are essential job functions subject to reasonable accommodation.  All job requirements listed indicate the minimum level of knowledge, skills and/or ability deemed necessary to perform the job proficiently.  Employees may be required to perform any other job-related instructions as requested by their supervisor, subject to reasonable accommodation.  This document does not create an employment contract, implied or otherwise, other than an “at will” employment relationship.