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

- Location: Peoria, IL
- Posted: Aug 3, 2017
- Status: open (checked Nov 21, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/sonsoftinc/743999657124645
- Employer record: https://visajobs.io/company/sonsoft.md

## Sponsorship history
- Tier: Employer history only
- With this exact title: 0
- Staffing / consulting firm: 100% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
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
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
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 .

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
