Data Warehouse: Data Warehouse Developer (12M FTC)

Developer is needed in Chicago, United States.

This job has been crawled from the web.

Client: Data Warehouse

Location: Chicago, IL

Contract: 12 Months Contract

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.

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.

Salary: $70.00 - $75.00 per hour

Experience:

• Data warehouse: 10 years (Preferred)
• ODI: 10 years (Preferred)
• ETL: 10 years (Preferred)