Data Warehouse Developer

Job Overview

Job Description

Data Warehouse Developer needs 7 years of experience in data warehousing development, implementation, and support

Data Warehouse Developer requires:

Hybrid

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.

Data Warehouse Developer duties:

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.