Oracle Data Integrator; ODI Consultant
Listed on 2026-02-28
-
IT/Tech
Data Engineer, Database Administrator
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.
Job DescriptionMcBride 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.
Key Responsibilities ODI Upgrade & Migration- 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
Data Integration & WarehousingPerform 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
Database DevelopmentDevelop and optimize SQL and PL/SQL for high-volume data processing
Perform query tuning and performance enhancement
Support database objects required for ODI processing
Requirements7+ 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.
#J-18808-Ljbffr(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).