Oracle Data Integrator (ODI) Consultant

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. 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, per...