Design and develop ETL workflows using IBM DataStage.
Improve existing DataStage jobs to reduce runtime, CPU usage, and memory consumption.
Integrate data from mainframes, relational databases, data appliances, flat files, and HDFS.
Support production systems and perform performance engineering.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
At least 2 years of ETL design and development experience using IBM DataStage
Experience implementing performance enhancements in existing DataStage jobs
Hands-on experience integrating data from heterogeneous sources, including mainframes, relational databases, Netezza, Teradata, flat files, and HDFS
Exposure to scheduling tools such as Zeke, AutoSys, or Control-M
At least 2 years of software development lifecycle experience
At least 2 years of experience translating functional and non-functional requirements into system requirements
Experience and understanding of production support and performance engineering
At least 2 years of experience in Information Technologies
Education
Bachelor’s degree or foreign equivalent from an accredited institution, or progressive specialty experience in lieu of education (three years of experience for each year of education)
Skills
Strong Unix shell scripting and SQL knowledge
Thorough understanding of data warehousing principles, dimensional modeling, star and snowflake schemas, OLTP, and OLAP
Knowledge of Ab Initio or SSIS (preferred)
Other requirements
Eligible work authorization: U.S. citizen, Green Card holder, GC-EAD, H4-EAD, or L2-EAD; OPT-EAD, H-1B, and TN candidates are not eligible
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Full job description
From Sonsoft Inc’s careers site
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
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.
Show full descriptionShow less
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.
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.