Data Warehouse Developer

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

Data Warehouse Developer requires:

• 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.
• Hybrid role with 2 days in office.

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.