ODI Developer

Role ODI Developer

Location Chicago, IL 60637 (2 days onsite)

Duration 12 months

Qualifications:

Requirements:

At least 7 years of experience in data warehousing development, implementation, and support.

Strong SQL analysis skills and experience in database tuning and optimization.

Experience in data modeling using Kimball methodology is preferred.

At least 3 years of experience in Oracle Data Integrator (ODI) 12c version.

Excellent team player with strong communication skills.

Ability to work in a fast-paced environment with minimal supervision.

This is a Hybrid role with 2 days in office.

Responsibilities:

Job Responsibilities :

Design, develop, and maintain the data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL.

Work with stakeholders to gather and analyze requirements for data warehousing solutions.

Develop ETL jobs using ODI to extract, transform, and load data from various sources into the data warehouse.

Perform performance tuning of the data warehouse, ETL jobs, and SQL queries to ensure optimal performance and scalability.

Develop and maintain data models using Kimball methodology for data warehousing design.

Support data operations by monitoring, troubleshooting, and resolving data issues.

Collaborate with the development team to integrate data warehouse solutions with other enterprise systems.

Job Type: Contract

Salary: $65.00 - $70.00 per hour

Schedule:

• 8 hour shift

Experience:

• data warehousing development: 8 years (Preferred)
• Oracle Data Integrator (ODI) 12c version: 5 years (Preferred)

Work Location: On the road