Data Stage Consultant (GC--USC) Milwaukee, WI/

Sonsoft Inc

Apply to this job
Peoria, IL, us on site Until 8/22/2026 H-1B sponsor history First posted February 23, 2026 Last posted February 23, 2026
Job description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

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

Note:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
No OPT-EAD, H1B & TN candidates please.
Please mention your Visa Status in your email or resume.

About this role

Summary

Develop and troubleshoot DataStage ETL jobs, design data warehouse schemas, and work in a global team.

Job title

Data Stage Consultant

Experience level

4+ years

Industry

software

Location requirements

Must be in Peoria, IL; remote not specified

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

DataStageETLSQLshell scriptingperformance tuning

Preferred skills

data warehousingstar schemasnowflake schemascheduling toolstroubleshooting

Specializations

data warehousingETLDataStageSQLshell scripting
Locations

Structured locations inferred from the posting.

Peoria, IL, USA

On-site City