Technology Lead – Data Stage

Saxon Global; Peoria (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

A growing IT consulting firm in Peoria, Illinois seeks experienced candidates for a Data Warehousing role. The position requires at least 4 years of expertise, especially with DataStage ETL Tools, and includes responsibilities such as developing ETL code and troubleshooting issues. Applicants must have a Bachelor's degree or an equivalent experience. Join a dynamic team within a globally focused environment offering technology solutions across various industries.

Qualifications

• 4+ years experience in Data Warehousing concepts.
• Experience with DataStage Designer and Director.
• Ability to develop ETL code aligned with specifications.

Responsibilities

• Design DataStage Parallel Jobs and Job Sequencing.
• Create Parameter Sets and Environment Variables.
• Troubleshoot DataStage jobs and performance issues.

Skills

Data warehousing concepts

DataStage ETL Tool

Shell scripting

SQL

Troubleshooting

Communication skills

Analytical skills

Education

Bachelor's degree or foreign equivalent

Tools

DataStage

Scheduling tools

Job description

Saxon Global is one of the fastest growing Inc 500 Companies in
the US, providing enhanced IT consulting, and engineering solution
services from past 16 years. Saxon global specializes in Business
Intelligence, Mobility, Big Data & Cloud and provides IT tools and
services to help organizations across industry verticals such as
Financial Services, Retail, Telecom, Healthcare, Banking and Media
Entertainment for their continued growth.

Job Description

Preferred :

• At least 4 years’ experience of Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodology.
• At least 4 years of Expertise in Data Warehousing ETL Tool DataStage using Components like DataStage Designer and Datastage Director
• Develop ETL code that meets technical specifications and business requirements according to the established designs and framework
• Expertise in designing DataStage Parallel Jobs, Job Sequencing, Creating Parameter Sets, Environment Variables and Creating Parallel Routines, Data Cleansing and Writing Transformation expressions to derive values and remove unwanted data.
• Expertise in shell scripting and SQL
• Scheduling tool experience
• In depth experience in troubleshooting of DataStage jobs and addressing issues like performance tuning.
• Creates other technical deliverable artifacts such as source-to-target mappings, implementation handbooks etc. needed for project implementation
• Ability to work in team in diverse/ multiple stakeholder environment.
• Experience and desire to work in a Global delivery environment.
• Communication and Analytical skills

Qualifications

Basic

• Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education
• At least 4 years of experience with Information Technology

Additional Information

All your information will be kept confidential according to EEO guidelines.