ODI Developer

Job Summary:

We are seeking an experienced Oracle Data Integrator for our client. This role involves designing and implementing data integration solutions, with a strong focus on data warehousing and reporting. The ideal candidate will have proficiency in Python for automation and data workflows, ensuring efficient data management to support critical business functions.

Key Responsibilities:

Develop, implement, and optimize ETL processes using Oracle Data Integrator (ODI).

Design and maintain data warehouses, ensuring data integrity, performance, and scalability.

Create automated data pipelines with Python for ETL tasks, data cleansing, and data validation.

Collaborate with cross-functional teams to define requirements for data integration and reporting.

Build and maintain interactive reports and dashboards to support data-driven decision-making.

Ensure data accuracy and perform regular testing, troubleshooting, and optimization of existing workflows.

Document data processes, technical specifications, and best practices for data management.

Qualifications:

5+ years of experience with Oracle Data Integrator, with a focus on data integration and ETL processes.

Solid experience in data warehouse design, data modeling, and ETL development.

Proficiency in Python for data automation, manipulation, and integration tasks.

Strong SQL skills, with the ability to write complex queries and optimize database performance.

Experience with reporting tools like Oracle BI, Power BI, or Tableau.

Familiarity with cloud environments like Oracle Cloud, Azure, or AWS is a plus.

Strong analytical skills, problem-solving abilities, and attention to detail.

Excellent communication skills, with the ability to work effectively in a collaborative environment.

Preferred Skills:

Understanding of Agile development processes.

Experience with API integration for third-party data sources.

Knowledge of data governance and best practices for data management.

Certification in Oracle Data Integrator or relevant technologies