Job description

Experienced in creating Data Stage jobs to Extract, Transform and Load data from diverse source systems to both Normalized (3NF) structures and Star Schemas in a Data Warehouse environment. Very strong ORACLE SLQ is mandatory as is experience with history data using Slowly Changing Dimensions. Minimum of 5-7 years experience SKILLS REQUIRED EXPERIENCE Data Stage 8.5 5 years Parallel Processing 2 years Quality Stage 2 years Slowly Changing Dimensions 5 years Unix Shell Scripts 2 years ORACLE SQL 5 years Change Data Capture 5 years Source to Target Mapping 2 years Creating and executing Test Cases 2 years • Good comm skills are a big priority • Duration: 6 months • In person interview required • Interviews to begin next week

Requirements

Must-haves

Experienced in creating Data Stage jobs to Extract, Transform and Load data from diverse source systems to both Normalized (3NF) structures and Star Schemas in a Data Warehouse environment.
Very strong ORACLE SLQ is mandatory as is experience with history data using Slowly Changing Dimensions.
Minimum of 5-7 years experience
SKILLS REQUIRED EXPERIENCE
Data Stage 8.5 5 years
Parallel Processing 2 years
Quality Stage 2 years
Slowly Changing Dimensions 5 years
Unix Shell Scripts 2 years
ORACLE SQL 5 years
Change Data Capture 5 years
Source to Target Mapping 2 years
Creating and executing Test Cases 2 years
Good comm skills are a big priority
Duration: 6 months
In person interview required
Interviews to begin next week

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium