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.
Skills Required
- Bachelor's degree or equivalent (or three years progressive experience in lieu)
- At least 4 years of experience with Information Technology
- Work authorization restricted to US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD (no OPT-EAD, H1B, TN)
- At least 4 years experience of data warehousing concepts and dimensional (Star/Snowflake) schema methodology
- At least 4 years of expertise in DataStage (using DataStage Designer and DataStage Director)
- Develop ETL code per technical specifications and business requirements
- Expertise in designing DataStage parallel jobs, job sequencing, parameter sets, environment variables, and parallel routines
- Experience with data cleansing and writing transformation expressions
- Expertise in shell scripting and SQL
- Scheduling tool experience
- Experience troubleshooting DataStage jobs and performance tuning
- Ability to create technical deliverables (source-to-target mappings, implementation handbooks)
- Ability to work in diverse/multi-stakeholder teams and global delivery environments
- Strong communication and analytical skills
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.
