DataStage ETL Engineer – Data Warehouse & SQL Expert

SmartRecruiters, Inc.; Peoria (IL); On-site; USD 90,000 - 130,000; Full time

Job summary

Sonsoft, Inc. seeks a seasoned ETL/DataStage engineer with 4+ years of experience in data warehousing to design and build ETL processes across a global delivery environment.

You will work with DataStage, SQL, shell scripting, and scheduling tools, troubleshooting performance issues and producing mapping documents and handbooks. US citizens or eligible workers are encouraged to apply; sponsorship is not available.

Qualifications

• Bachelor’s degree or foreign equivalent required.
• Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of experience within the Information Technologies.
• US citizens or those authorized to work in the United States are encouraged to apply; sponsorship not available.
• This is a Full-Time / Permanent job opportunity.
• Only US Citizens or Green Card holders can apply.

Responsibilities

• Develop ETL code that meets technical specifications and business requirements.
• Design DataStage Parallel Jobs, Job Sequencing, and Parameter Sets.
• Create and manage Environment Variables and Parallel Routines.
• Implement data cleansing and write transformation expressions.
• Troubleshoot DataStage jobs and address performance tuning issues.
• Create source-to-target mappings and implementation handbooks.
• Collaborate with global delivery teams across multiple stakeholders.
• Communicate clearly and analyze requirements to deliver solutions.

Skills

Data warehousing concepts

Star Schema

Snowflake Schema

ETL Development

Shell scripting

SQL

Performance tuning

Source-to-target mappings

Implementation handbooks

Team collaboration

Global delivery

Communication

Analytical skills

Education

Bachelor's degree or foreign equivalent

Tools

DataStage Designer

Datastage Director

Job description

Sonsoft, Inc. seeks a seasoned ETL/DataStage engineer with 4+ years of experience in data warehousing to design and build ETL processes across a global delivery environment.

You will work with DataStage, SQL, shell scripting, and scheduling tools, troubleshooting performance issues and producing mapping documents and handbooks. US citizens or eligible workers are encouraged to apply; sponsorship is not available.