Oracle Data Integrator; ODI Consultant

Arlington, United States | Posted on 02/18/2026

McBride is a Service-Disabled Veteran-Owned Small Business (SDVOSB), and Disadvantaged Business Enterprise (DBE) management and IT consulting firm with significant professional services experience that includes IT transformation, project management, digital transformation, strategic planning, business process improvement, change management, human capital management, disaster recovery, and operations.

McBride Consulting is seeking an experienced Oracle Data Integrator (ODI) to lead and support the upgrade of ODI 11g repositories to ODI 12c using the Oracle Upgrade Assistant (OUA). This role will be responsible for repository schema upgrades, migration of ETL/ELT workflows, and ensuring the stability, performance, and integrity of the enterprise data integration platform.

The ideal candidate brings 7+ years of hands-on ODI experience, deep expertise in ELT architecture, and strong Oracle Database (SQL/PLSQL) skills, along with a solid foundation in data warehousing and dimensional modeling.

• Perform end-to-end ODI 11g to ODI 12c upgrades, including Master and Work Repository schema upgrades using Oracle Upgrade Assistant (OUA)
• Analyze and remediate pre-upgrade issues, compatibility challenges, and deprecated components
• Migrate and validate mappings, packages, procedures, load plans, variables, and scenarios
• Conduct post-upgrade testing, performance tuning, and production cutover support
• Ensure repository integrity, security migration, and topology reconfiguration

Design, develop, and implement ETL/ELT workflows using ODI 11g/12c or later

Build and maintain:

• ODI mappings and interfaces
• Packages and procedures
• Load plans and scenarios

Develop and customize Knowledge Modules (KM) and reusable components

Configure and manage ODI Topology, Security, and Work Repositories

Implement best practices for code versioning, deployment, and release management

Perform data extraction, transformation, and loading from multiple source systems

• Relational databases
• Flat files
• XML
• APIs / web services

Apply data warehousing concepts including:

• Fact and dimension tables
• Star and snowflake schemas

Support data validation, reconciliation, and performance optimization

Develop and optimize SQL and PL/SQL for high-volume data processing

Perform query tuning and performance enhancement

Support database objects required for ODI processing

7+ years of hands-on experience with Oracle Data Integrator (ODI 11g and 12c or later)

Strong understanding of ETL vs ELT architecture and best practices

Advanced proficiency in Oracle Database, SQL, and PL/SQL

Solid experience with data warehousing and dimensional data modeling

Hands-on experience configuring ODI Topology, Security, and Repositories

Experience integrating data from multiple heterogeneous sources

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Referral program

McBride is an Equal Opportunity Employer. McBride Consulting does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.