Overview
Role: Oracle Data Integrator (ODI) Specialist
Location: Milton Keynes, UK
Contract (6months +)
Inside IR35
Responsibilities
* Design, develop, and implement ODI mappings, interfaces, packages, procedures, and load plans.
* Perform end-to-end data integration activities including extraction from source systems, transformation logic, and loading into target systems (Data Warehouse, Data Lake, Cloud).
* Optimize ODI processes for performance, scalability, and reusability.
* Collaborate with business analysts, data architects, and application teams to understand requirements and translate them into technical designs.
* Develop and enforce ODI standards, frameworks, and best practices.
* Perform root cause analysis and resolve issues related to data integration jobs, schedules, and performance bottlenecks.
* Support ODI administration activities including security, topology configuration, agent setup, and patch upgrades.
* Provide production support for ODI jobs, monitoring, troubleshooting, and ensuring high availability.
* Document technical designs, integration flows, and support guides.
* Contribute to continuous improvement initiatives in data integration and analytics delivery.
Desirable Qualifications
Prior experience in Banking, Financial Services, or large-scale ERP/EPM/Cloud data integration projects.
Key Skills/Knowledge
* Strong hands-on expertise in Oracle Data Integrator (ODI) 11g/12c (mandatory).
* Proficiency in ETL/ELT concepts, data warehousing, and relational database design.
* Strong SQL and PL/SQL skills; performance tuning of queries and ODI mappings.
* Experience with ODI administration, topology setup, security, and agents.
* Knowledge of Oracle database, GoldenGate, and WebLogic environments.
* Experience integrating ODI with cloud applications (Oracle Cloud ERP/EPM, SaaS, REST/SOAP APIs).
* Strong problem-solving, debugging, and analytical skills.
* Excellent communication and documentation skills to liaise with business and technical stakeholders.
* Experience working in Agile and Waterfall methodologies.
#J-18808-Ljbffr