Senior Oracle Data Integrator ODI Developer

Texas, Irving

07/10/2025

Contract

Active

Job Summary

We are seeking a highly experienced Senior Oracle Data Integrator (ODI) Developer to lead the design, development, and support of complex data integration solutions.

This role requires deep expertise in Oracle ODI, PL/SQL, Unix scripting, and data transformation techniques.

The ideal candidate will be skilled in handling structured and unstructured data, customizing BI Apps load plans, and ensuring data quality and performance across enterprise systems.

Key Responsibilities

• Design, develop, and maintain ODI interfaces, packages, and load plans for large-scale data integration.
• Build and manage complex file topologies to support multi-format data integrations.
• Customize and support Oracle BI Applications (OBIA) load plans, mappings, and workflows.
• Translate business requirements into scalable ETL/ELT logic using ODI.
• Develop PL/SQL scripts and use Oracle SQL for data transformation and enrichment.
• Create reusable mappings and scenarios aligned with performance and best practices.
• Automate batch jobs using Unix shell scripting and integrate ODI processes with scheduling tools like Autosys.
• Collaborate with technical and functional teams to resolve data quality issues.
• Monitor job executions, perform root cause analysis, and implement corrective actions.
• Document solution designs, technical specifications, and support procedures.
• Ensure compliance with data governance and integration standards.
• Mentor junior developers and conduct peer code reviews.

• Minimum 6+ years of hands-on experience with Oracle Data Integrator (ODI) 12c.
• Experience customizing Oracle BI Applications (OBIA) load plans and mappings.
• Proficiency in Oracle SQL and PL/SQL for data operations.
• Hands-on experience with Unix/Linux shell scripting.
• Deep understanding of ELT/ETL best practices and data warehousing concepts.
• Experience with job scheduling tools and ODI batch job integration.
• Strong analytical and problem-solving skills.
• Ability to manage multiple priorities independently.
• Excellent verbal and written communication skills.

• Exposure to OBIEE, Oracle Cloud, or other analytics/reporting platforms.
• Familiarity with version control systems such as Git.

Cell phone
* This field is required Please enter valid cell phone.

First Name
* This field is required Please enter valid first name.

Last Name
* This field is required Please enter valid last name.