ETL DataStage Developer (Midlevel)
Role:
This role is Extensive clientfacing consulting and 100 handson programming / development.
- As Senior DataStage developer responsible for developing and managing ETL processes.
- Troubleshoot and resolve issues with existing jobs.
- Maintain Data Integrity & Data Quality
- Coordinate with Business users in Requirements gathering and develop necessary ETL jobs and/or enhance existing ETL jobs
In this role
- you should have a background in data analysis and be able to work independently with little supervision.
- you will also have experience with database SQL PL/SQL programming and job scheduling tools Autosys.
Responsibilities:
- Design develop and maintain DataStage ETL jobs according to specifications.
- Optimize existing DataStage jobs for performance.
- Reviewing job designs and code created by other DataStage developers.
- Troubleshoot DataStage job failures and provide root cause analysis.
- Work with the development team to ensure that all DataStage jobs adhere to company standards and best practices.
- Provide support for production DataStage jobs as needed.
- Develop new DataStage jobs to load data into the data warehouse.
- Test DataStage jobs for accuracy and performance.
- Deploy DataStage jobs to production environments.
- Monitor DataStage job and troubleshoot issues as needed.
- Maintain documentation for all developed jobs.
- Provide support for ongoing data loads and issue resolution.
- Helping project leaders with project timeframes and objectives.
Experience:
- Bachelors degree in information system Computer Science or a related field.
- 5 years of experience in DataStage development and administration.
- Experience with ETL tools such as DataStage Informatica Ab Initio or Oracle ETL.
- Strong SQL skills and other relevant coding languages.
- Experience with Snowflake is a plus.
- Excellent communication and interpersonal skills.
- Expert in DataStage solution conception design and deployment.
- Outstanding analytical & problemsolving abilities.
- The capacity to work as a member of a multidisciplinary team.
Additional Information :
All your information will be kept confidential according to EEO guidelines.
EEOC and Veteran Documentation
During employment employees are treated without regard to race color religion sex national origin age marital or veteran status medical condition or handicap or any other legally protected status.
At times government agencies require periodic reports from employers on the sex ethnicity handicap veteran and other protected status of employees. The purpose of this Administrative EEO Record is for statistical analysis only and is used to comply with government record keeping reporting and other legal requirements. Periodic reports are made to the government on the following information. The completion of the Administrative EEO record is optional. If you choose to volunteer the requested information please note that all
Administrative EEO Records are kept in a Confidential File and are not part of your Application for Employment or Personnel file.
Please note: YOUR COOPERATION IS VOLUNTARY. INCLUSION OR EXCLUSION OF ANY DATA WILL NOT AFFECT ANY EMPLOYMENT DECISION.
Remote Work :
No
Employment Type :
Fulltime