Sr. ODI Developer

Description

Remote Long-term contract for University client

Qualifications

 

• Experience with Campus Solutions or Student Information Analytics
• At least 9 years of experience in data warehousing development, implementation, and support.
• 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.
  
   

Responsibilities

 

• 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.