Job Overview
We are seeking a highly skilled Data Warehouse Developer with a robust background in data warehousing development, implementation, and support. The ideal candidate will possess a minimum of 7 years of relevant experience, along with a strong proficiency in SQL analysis and database optimization. This is a hybrid position, requiring in-office presence for 2 days each week.
Key Responsibilities
- Design, develop, and maintain the data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL processes.
- Collaborate with stakeholders to gather and analyze requirements, ensuring the delivery of effective data warehousing solutions.
- Create and manage ETL jobs through ODI to extract, transform, and load data from various sources into the data warehouse.
- Conduct performance tuning of the data warehouse, ETL jobs, and SQL queries to achieve optimal performance and scalability.
- Develop and uphold data models utilizing Kimball methodology for effective data warehousing design.
- Support data operations through monitoring, troubleshooting, and resolving data-related issues.
- Work alongside the development team to integrate data warehouse solutions with other enterprise systems.
Required Skills
- Strong SQL analysis abilities and experience in database tuning and optimization.
- Proficiency with Oracle Data Integrator (ODI) 12c version.
- Familiarity with data modeling techniques, specifically using Kimball methodology.
- Excellent communication and teamwork skills.
- Capacity to work independently in a dynamic, fast-paced environment.
Qualifications
- A minimum of 7 years' experience in data warehousing development.
- Demonstrated expertise in SQL and data optimization techniques.
- Proven experience with Oracle Data Integrator (ODI) 12c.
- A bachelor's degree in Computer Science, Information Technology, or a related field is preferred.
Career Growth Opportunities
This role offers valuable opportunities for professional development, allowing you to expand your expertise in data warehousing, ETL processes, and Oracle technologies, paving the way for career advancement within our esteemed organization.
Company Culture And Values
We pride ourselves on fostering a collaborative and communicative work environment where team players thrive. Our culture encourages autonomy and responsibility, allowing individuals to grow and excel in their roles.
Employment Type: Full-Time