Description

You will design, build, and maintain ETL workflows and dimensional data models for data marts.

This role is on-site.

Responsibilities

• Capture and load source system data into data marts via ETL processes.
• Develop, test, and implement program logic and technical specifications for ETL development.
• Optimize data load jobs to improve performance, automation, and system availability.
• Design and maintain logical and physical dimensional data models for Data Marts.
• Mentor developers and maintain clear technical documentation.

Required Skills

• 7+ years developing and testing query solutions using Oracle PL/SQL.
• 7 years experience with UNIX Shell Scripting.
• 7 years ETL design for Data Warehouse/Data Mart using SQL, PL/SQL, and IBM DataStage.
• 6 years performance tuning of sessions, mappings, sources, and targets.
• 6 years using ER Studio for dimensional data modeling in Cognos or OBIEE 10/11g.
• 5 years working with PPI, SSA, or HIPAA data security requirements.
• Experience providing production support and troubleshooting migration or data load issues.
• Bachelor's degree in Computer Science, Information Science, Engineering, or Mathematics.

Key Skills

Education

Bachelor's Degree