Description

You will design, develop, and maintain a data warehouse using Oracle Database and Oracle Data Integrator (ODI) for ETL processes.

Responsibilities

• Develop ETL jobs using ODI 12c to extract, transform, and load data from various sources.
• Design and maintain data models using Kimball methodology.
• Perform performance tuning on the data warehouse, ETL jobs, and SQL queries to ensure scalability.
• Collaborate with stakeholders to gather and analyze requirements for data warehousing solutions.
• Monitor, troubleshoot, and resolve data issues to support ongoing operations.

Required Skills

• 9+ years of experience in data warehousing development, implementation, and support.
• 3+ years of hands-on experience with Oracle Data Integrator (ODI) 12c.
• Advanced SQL analysis, database tuning, and optimization skills.
• Proficiency with Oracle Database.
• Experience building and managing ETL pipelines and data models.
• Background working with Campus Solutions or Student Information Analytics.
• Ability to work with minimal supervision.

Preferred Skills

• Experience in data modeling using Kimball methodology.

Key Skills

Education

Any Graduate