Improve existing DataStage jobs to reduce runtime, CPU time, and memory use.
Integrate data from mainframes, relational databases, appliances, flat files, HDFS, and other sources.
Translate functional and non-functional requirements into system requirements.
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 using IBM DataStage components
Experience implementing performance enhancements in existing DataStage jobs
Hands-on experience integrating data from heterogeneous data sources
At least 2 years of experience in the software development life cycle
At least 2 years of experience translating functional and non-functional requirements to 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 three years of progressive experience in the specialty in lieu of each year of education
Skills
Strong Unix shell scripting and SQL knowledge
Exposure to scheduling tools such as Zeke, Autosys, or Control-M
Thorough understanding of data warehousing principles, dimensional data modeling, star and snowflake schemas, OLTP, and OLAP
Knowledge of other ETL technologies such as Ab Initio or SSIS (preferred)
Other requirements
Eligible to work in the U.S. in one of the listed statuses: U.S. citizen, Green Card holder, GC-EAD, H4-EAD, or L2-EAD; sponsorship is not available
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
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.
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
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
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, TN Visa & H1B Consultants please.
Please mention your Visa Status in your email or resume.