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
- 2+ years ETL design and development using IBM DataStage components (DataStage Designer, Director, Administrator) and IBM Information Server.
- Experience implementing performance enhancements in DataStage jobs (runtime/CPU/memory optimization).
- Hands-on experience integrating data from mainframes, relational databases, Netezza, Teradata, flat files, HDFS.
- Strong Unix shell scripting and 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 experience in software development life cycle (SDLC) and translating functional/non-functional requirements to system requirements.
- Experience in production support and performance engineering.
- Bachelor's degree or foreign equivalent (or equivalent progressive experience).
- Authorized to work in the U.S. (US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD).
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.
.png)





