Develop ETL code that meets technical specifications and business requirements.
Design DataStage jobs, sequences, parameter sets, environment variables, and routines; cleanse and transform data.
Troubleshoot DataStage jobs and tune performance.
Create implementation deliverables, including source-to-target mappings and implementation handbooks.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
At least 4 years of experience with Information Technology
At least 4 years of experience with data warehousing concepts and dimensional Star Schema and Snowflake Schema methodology (preferred)
At least 4 years of expertise with the DataStage ETL tool, including DataStage Designer and DataStage Director (preferred)
Scheduling tool experience (preferred)
In-depth experience troubleshooting DataStage jobs and addressing performance tuning issues (preferred)
Experience creating technical deliverables such as source-to-target mappings and implementation handbooks (preferred)
Experience and desire to work in a global delivery environment (preferred)
Education
Bachelor's degree or foreign equivalent from an accredited institution, or three years of progressive specialty experience in lieu of each year of education
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
Preferred
Show full descriptionShow less
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
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
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.