ODI Designer Developer

Vallum Associates; Milton Keynes; On-site; GBP 75,000 - 110,000; Full time

Job summary

Vallum Associates in Milton Keynes is seeking an experienced ODI professional to independently develop, test and deploy ETL processes using Oracle Data Integrator. You will collaborate with data architects and stakeholders to translate data needs into robust ODI solutions and ensure high data integrity.

The role requires 7-10+ years of ODI experience, strong PL/SQL and Unix shell scripting skills, and a solid understanding of data warehousing concepts.

Qualifications

• 7-10+ years of ODI experience required.
• Strong knowledge of Oracle ODI with at least 2 recent project experiences.
• Proficient in ODI / PL/SQL / UNIX Shell Scripting / Data warehouse concepts.
• Ability to work independently on complex tasks.

Responsibilities

• Develop, test, and deploy ETL processes using ODI.
• Collaborate with data architects to design data integration solutions.
• Analyze and translate data requirements into technical specifications.
• Monitor and troubleshoot data integration workflows for issues.
• Optimize ETL processes for performance and data integrity.
• Document ETL processes and data transformations.
• Work with stakeholders to understand data requirements and deliver solutions.
• Participate in code reviews and provide constructive feedback to peers. Unix Script , Strong PL/SQL

Skills

ETL design

Data integration

Troubleshooting

Tools

ODI

PL/SQL

UNIX Shell Scripting

Data Warehousing Concepts

Job description

Client is undergoing major Finance transformation using Oracle ERP. This role requires experienced ODI professionals who can independently work on complex tasks related to ODI.

Your responsibilities:

• Develop, test, and deploy ETL processes using Oracle Data Integrator (ODI).
• Collaborate with data architects to design data integration solutions.
• Analyze and translate data requirements into technical specifications.
• Monitor and troubleshoot data integration workflows for issues.
• Optimize ETL processes to ensure high performance and data integrity.
• Document ETL processes and maintain accurate records of data transformations.
• Work with stakeholders to understand data requirements and deliver solutions.
• Participate in code reviews and provide constructive feedback to peers. Unix Script , Strong PL/SQL

Essential skills/knowledge/experience:

• At least 7-10 years of experience working In ODI
• Strong knowledge of Oracle ODI with at least 2 recent project experiences
• ODI / PLSQL/ UNIX Shell Scripting/Data warehouse concept