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 2+ years of experience in ETL design and development using IBM DataStage components - DataStage Designer, DataStage Director, DataStage Administrator and IBM information server.
- Experience in implementing performance enhancements in existing DataStage jobs for reduced runtime/CPU time/memory management etc.
- Hands-on experience in integrating data from heterogeneous data sources spanning across mainframes, relational databases, appliances like Netezza, Teradata, flat files, HDFS etc. Strong Unix shell scripting and SQL knowledge.
- Exposure to scheduling tools like Zeke, Autosys, Control-M.
- Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema, OLTP, OLAP and Data Warehousing concepts).
- Knowledge of other ETL technologies (Abinitio, SSIS) will be a plus.
- At least 2 years of experience in software development life cycle.
- At least 2 years of experience in translating functional/non-functional requirements to system requirements.
- Experience and understanding of in Production support and performance engineering.
- Technical Skills.
- Ability to work in team environment and client interfacing skills.
- Excellent Communication and Analytical skills
Qualifications
Basic 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 2 years of experience within the Information Technologies.
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
- At least 2+ years of experience in ETL design and development using IBM DataStage components (Designer, Director, Administrator) and IBM Information Server
- Experience implementing performance enhancements in DataStage jobs to reduce runtime, CPU, and manage memory
- Hands-on experience integrating data from mainframes, relational databases, Netezza, Teradata, flat files and HDFS
- Strong Unix shell scripting skills
- Strong SQL knowledge
- Exposure to scheduling tools such as Zeke, Autosys, Control-M
- Thorough understanding of data warehousing principles (fact/dimension tables, star/snowflake schemas, OLTP/OLAP)
- Knowledge of other ETL technologies (Abinitio, SSIS)
- At least 2 years of experience in software development lifecycle (SDLC)
- At least 2 years of experience translating functional/non-functional requirements to system requirements
- Experience with production support and performance engineering
- Ability to work in a team environment and client interfacing skills; excellent communication and analytical skills
- Bachelor's degree or equivalent (or three years progressive experience in lieu of each year of education)
- Eligibility: Only US Citizen, Green Card Holder, GC-EAD, H4-EAD or L2-EAD may apply (No OPT-EAD, H1B or TN candidates)
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.







