Company DescriptionSonsoft , 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 DescriptionPreferred• 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 skillsQualificationsQualifications 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 TechnologyAdditional InformationNote:-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.