SonSoft Inc.→

Data Stage Consultant (GC--USC) Milwaukee,… at SonSoft Inc. · Peoria

Mid LevelOn-sitePeoria, IL

Skills

datastagedatastage designerdatastage directoretlsqlshell scriptingdata warehousingstar schemasnowflake schemaparallel jobsjob sequencingparameter setsenvironment variablesparallel routinesdata cleansingtransformation expressionsscheduling toolsperformance tuningcommunicationanalytical skillsteamwork

Job Description

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

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.