Data Stage

Posted 10 Days Ago
Be an Early Applicant
Peoria, IL, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, and troubleshoot ETL solutions using IBM DataStage (parallel jobs, sequencing, routines). Implement Star/Snowflake dimensional models, write SQL and shell scripts, perform data cleansing and performance tuning, produce source-to-target mappings, and collaborate with global stakeholders.
Summary Generated by Built In
Company 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.

Job Description

  • 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

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 within the Information Technologies.

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.

This is a Full-Time / Permanent job opportunity.

• ••

Only US Citizen, Green Card Holder can apply.

.

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

Skills Required

  • At least 4 years experience with data warehousing concepts and dimensional Star/Snowflake schemas
  • At least 4 years expertise in IBM DataStage including Designer and Director
  • Experience designing DataStage parallel jobs, job sequencing, parameter sets, environment variables, and parallel routines
  • Expertise in shell scripting
  • Expertise in SQL
  • Experience with scheduling tools
  • Experience troubleshooting DataStage jobs and performance tuning
  • Bachelor's degree or foreign equivalent (or progressive experience in lieu)
  • At least 4 years of experience in Information Technologies
  • Ability to work in teams across diverse/multiple stakeholders and global delivery environments
  • Strong communication and analytical skills
  • U.S. Citizen or Green Card holder (no visa sponsorship available)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
Peoria, IL, USA
87 Employees

USM Business Systems Logo USM Business Systems

Fulltime : DATA STAGE DEVELOPER - Only US Citizens and GC Card holders

Artificial Intelligence • Information Technology • Internet of Things • Software • Automation
In-Office
Oak Brook, IL, USA
580 Employees

Saxon AI Logo Saxon AI

Technology Lead – Data Stage

Artificial Intelligence • Big Data • Cloud • Information Technology • Machine Learning • Analytics • Generative AI
In-Office
Peoria, IL, USA
500 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account