DataStage Developer Job Description Template
The role of a DataStage Developer is to work with clients and business analysts to design, develop, test and deploy DataStage ETL jobs. The DataStage Developer will be responsible for the full development life cycle of DataStage jobs from requirement gathering to job deployment. In addition, the DataStage Developer will be responsible for performance tuning of jobs and providing support to end users.
DataStage Developer Job Responsibilities
- Design, develop, test and deploy DataStage ETL jobs to extract, transform and load data from a variety of sources.
- Write SQL queries to retrieve data from databases for use in DataStage jobs.
- Develop shell scripts to automate the running of DataStage jobs.
- monitor job execution and troubleshoot issues as necessary.
- Work with business users to understand their data requirements and design ETL processes to meet those needs.
- Keep up to date with new features in DataStage and other ETL tools
Objectives
- Design and develop ETL jobs in DataStage to extract data from various sources, including databases, flat files, and XML files
- Cleanse and transform data using DataStage builtin functions and custom scripts
- Load transformed data into target databases or systems
- Perform unit testing of ETL jobs prior to deployment
- Assist in the design and development of DataStage job flows or pipelines
- Monitor ETL jobs during production runs and troubleshoot issues as needed
DataStage Developer Job Skills & Qualifications Needed
- The skills and qualifications needed for the role of DataStage Developer are as follows:
- Strong experience with IBM DataStage ETL tool.
- Experience developing data warehouses and data marts.
- Strong SQL skills.
- Experience with dimensional data modeling techniques.