DataStage ETL Consultant - Data Warehousing Expert

Sonsoft Inc; Peoria (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

A growing software consultancy is seeking a Data Stage Consultant for a full-time role. The ideal candidate will have over 4 years of experience in data warehousing concepts, with expertise in DataStage ETL tools. Responsibilities include developing ETL codes, troubleshooting DataStage jobs, and creating technical documentation. This position is available only to US Citizens, Green Card Holders, and specific visa holders, with work taking place in a global delivery environment.

Qualifications

• 4+ years experience of Data warehousing concepts including dimensional Star Schema and Snowflakes Schema methodology.
• 4+ years expertise in DataStage ETL Tool with components like DataStage Designer and Director.
• In-depth experience troubleshooting DataStage jobs including performance tuning.

Responsibilities

• Develop ETL code meeting specifications according to designs and framework.
• Create technical deliverables like source-to-target mappings and implementation handbooks.
• Work in a diverse, global delivery environment.

Skills

Data warehousing concepts

DataStage ETL Tool

Shell scripting

SQL

Troubleshooting DataStage jobs

Communication skills

Analytical skills

Education

Bachelor's degree or foreign equivalent

Job description

A growing software consultancy is seeking a Data Stage Consultant for a full-time role. The ideal candidate will have over 4 years of experience in data warehousing concepts, with expertise in DataStage ETL tools. Responsibilities include developing ETL codes, troubleshooting DataStage jobs, and creating technical documentation. This position is available only to US Citizens, Green Card Holders, and specific visa holders, with work taking place in a global delivery environment.