Oracle ODI/BIAPPS Analyst

The Overhead Door • Lewisville, TX

1d

About The Position

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.

Requirements

• 8+ years of experience in ETL development / Business Intelligence Analyst in IT or BI environments
• Strong hands-on experience with Oracle Data Integrator (ODI)
• Strong expertise in SQL and Oracle Database concepts
• Experience working with ETL performance tuning and optimization
• Strong problem-solving and debugging skills

Nice To Haves

• Experience with Oracle BI Applications (BIAPPS) / OBIA is highly preferred
• 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
• Experience gathering and documenting reporting requirements and converting them into BI solutions is a plus.

Responsibilities

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level