Description

You will design, develop, and maintain a data warehouse using Oracle Database and Oracle Data Integrator (ODI) for ETL processes. You will own the full lifecycle of data integration, from requirement gathering to performance tuning and operational support.

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