Description

You will manage data structures and ETL processes to support data warehouse and data mart end users.

Responsibilities

• Design and implement ETL architecture using Oracle Data Integrator, Talon-D, or IBI Data Integrator.
• Develop and manage complex stored procedures utilizing triggers.
• Stage data based on specific business requirements.
• Maintain and query data within Cúram Social Program Management databases (version 4.5 or higher).
• Support end users within data warehouse and data mart environments.

Required Skills

• 5+ years of experience with relational database management systems.
• 4+ years of experience with Oracle 10g or higher.
• 4+ years of experience writing complex stored procedures and triggers.
• 4+ years of experience querying Cúram Social Program Management databases (v4.5+).
• 4+ years of experience designing ETL architecture via Oracle Data Integrator, Talon-D, or IBI Data Integrator.
• 4+ years of experience staging data for business requirements.
• 4+ years of experience providing data warehouse or data mart end user support.
• 2+ years of experience developing and managing data structures.
• Bachelor’s degree in an Information Technology related field.

Preferred Skills

• 1+ year of experience designing, coding, deploying, or managing case management or insurance claiming applications.

Key Skills

Education

bachelor’s degree in an Information Technology