What does a datastage developer do?
Datastage developers supervise technology design and building. These developers implement various tools and solutions. They provide estimations, make an analysis of requirements, and set up Datastage projects according to requirements. Datastage developers' responsibility is to understand business requirements, ensure consistent unit tests, and design applications according to requirements. Once there is an update, these developers support the technology infrastructure team implementation and train clients. To be successful as Datastage developers, they must know application design and development, analytical skills, and a self-starter.
Datastage developer responsibilities
Here are examples of responsibilities from real datastage developer resumes:
- Create and manage multiple development and test database environments, often work as a backup DBA.
- Experience using peek stage by the means of outsourcing data to the job log which leads to debugging of jobs.
- Manage continuous integration, configure the servers using Jenkins.
- Involve in SQL & PL/SQL programming for procedures, functions, packages to extract data from various source systems.
- Identify business rules for data migration and perform data administration through data models and metadata.
- Involve in implementation of UNIX shell scripts to copy files among different servers and to invoke PL/SQL scripts, DataStage jobs.
- Migrate the jobs from DataStage 8.1 to 8.5 and the environment from AIX to LINUX.
- Involve in deployment and/or migration process to move code from DEV to QA and then to PRD.
- Resolve issues relate to the compatibility of the code with DataStage 8.7 and Redhat Linux server 6 ..
- Work closely with the mainframe developers in getting the source files, and discuss the data relate issues.
- Work on different types of transformations like, filter, aggregator, store procedure, row generator and join.
- Used Aggregator stages to sum the key performance indicators in decision support systems and for granularity require in DW.
- Automate whole process for encrypting members PII information using shell scripts that trigger Java script (SHA-256 algorithm).
- Develop the logic to load the dimensional tables to Db2 through external table methodology using Java for report generation.
- Transform the data using AbInitio v2.13 on AIX and load the data into DB2 tables on AIX and MVS.
Datastage developer skills and personality traits
We calculated that 8% of Datastage Developers are proficient in SQL Server, Database, and Unix. They’re also known for soft skills such as Interpersonal skills, Creativity, and Detail oriented.
We break down the percentage of Datastage Developers that have these skills listed on their resume here:
- SQL Server, 8%
Used SSIS for Transformation the data for Sort, Aggregation, Data integration, and Automate Maintenance of SQL Server Database.
- Database, 8%
Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
- Unix, 7%
Performed Unit testing of DataStage Jobs using Unix Shell Scripting and with web application to ensure that it meets the requirements.
- Data Warehouse, 5%
Provided day-to-day and month-end production support for various applications like Business Intelligence Center, and Management Data Warehouse by monitoring servers.
- Datastage ETL, 5%
Collaborated analysts, data modelers and developers to capture business logic and translated into DataStage ETL jobs.
- Aggregator, 3%
Developed DataStage jobs extensively using Aggregator, Sort, Merge, Data Set in Parallel Extender to achieve better job performance.
"sql server," "database," and "unix" are among the most common skills that datastage developers use at work. You can find even more datastage developer responsibilities below, including:
Interpersonal skills. The most essential soft skill for a datastage developer to carry out their responsibilities is interpersonal skills. This skill is important for the role because "software developers must be able to work well with others who contribute to designing, developing, and programming successful software." Additionally, a datastage developer resume shows how their duties depend on interpersonal skills: "developed strong interpersonal and communication skills woking with a team of back end and front end website developers. "
Creativity. Another soft skill that's essential for fulfilling datastage developer duties is creativity. The role rewards competence in this skill because "developers are the creative minds behind new computer software." According to a datastage developer resume, here's how datastage developers can utilize creativity in their job responsibilities: "connected to oracle using ole db and odbc data sources connector and tables of sd, inventory, etc. "
Detail oriented. datastage developers are also known for detail oriented, which are critical to their duties. You can see how this skill relates to datastage developer responsibilities, because "developers often work on many parts of an application or system at the same time and must therefore be able to concentrate and pay attention to detail." A datastage developer resume example shows how detail oriented is used in the workplace: "worked with business analysts and end clients to analyze and detail requirements and explain those to offshore team. "
Problem-solving skills. A big part of what datastage developers do relies on "problem-solving skills." You can see how essential it is to datastage developer responsibilities because "because developers are in charge of software from beginning to end, they must be able to solve problems that arise throughout the design process." Here's an example of how this skill is used from a resume that represents typical datastage developer tasks: "worked closely with business analysts to determine how the customer wanted data issues resolved. "
Analytical skills. Another common skill required for datastage developer responsibilities is "analytical skills." This skill comes up in the duties of datastage developers all the time, as "developers must analyze users’ needs and then design software to meet those needs." An excerpt from a real datastage developer resume shows how this skill is central to what a datastage developer does: "converted owb etl processes to datastage 9.1 with oracle 11g database. "
Communication skills. Another skill commonly found on datastage developer job descriptions is "communication skills." It can come up quite often in datastage developer duties, since "developers must be able to give clear instructions to others working on a project." Here's an example from a resume of how this skill fits into day-to-day datastage developer responsibilities: "designed autosys based solutions for communication of issues to technical teams. "
The three companies that hire the most datastage developers are:
- Accenture33 datastage developers jobs
- Randstad North America, Inc.8 datastage developers jobs
- Cognizant5 datastage developers jobs
Choose from 10+ customizable datastage developer resume templates
Build a professional datastage developer resume in minutes. Our AI resume writing assistant will guide you through every step of the process, and you can choose from 10+ resume templates to create your datastage developer resume.
Compare different datastage developers
Datastage developer vs. Software developer internship
A software developer intern is responsible for assisting the software engineers with the design implementation and shadowing their duties to understand the processes more efficiently. Software developer interns use their classroom knowledge on practical applications, suggesting recommendations on how to make the project successful. They also respond to clients' inquiries and concerns, attend meetings, and help with maintaining complex systems and networks. A software developer intern must have excellent communication skills, as well as having strong attention to detail and the ability to learn fast.
These skill sets are where the common ground ends though. The responsibilities of a datastage developer are more likely to require skills like "sql server," "database," "data warehouse," and "datastage etl." On the other hand, a job as a software developer internship requires skills like "python," "software development," "javascript," and "object oriented programming." As you can see, what employees do in each career varies considerably.
Software developer interns tend to make the most money working in the finance industry, where they earn an average salary of $41,281. In contrast, datastage developers make the biggest average salary, $107,514, in the health care industry.On average, software developer interns reach similar levels of education than datastage developers. Software developer interns are 0.8% more likely to earn a Master's Degree and 0.6% more likely to graduate with a Doctoral Degree.Datastage developer vs. Business objects developer
An ETL (extract transform load) developer is an IT specialist who designs and fills advanced data storage systems intended for the clientele. ETL developers are responsible for loading business data into a data warehouse. Their role is significant in the establishment and growth of large data warehouses. It is their responsibility to implement the ETL processes. Their skillset includes expertise in data analysis, a background in software engineering, experience with database architecture, and knowledge in using ETL tools.
Each career also uses different skills, according to real datastage developer resumes. While datastage developer responsibilities can utilize skills like "database," "datastage etl," "aggregator," and "ibm db2," business objects developers use skills like "business objects," "web intelligence," "dashboards," and "objects universes."
On average, business objects developers earn a higher salary than datastage developers. Some industries support higher salaries in each profession. Interestingly enough, business objects developers earn the most pay in the health care industry with an average salary of $98,303. Whereas datastage developers have higher pay in the health care industry, with an average salary of $107,514.Average education levels between the two professions vary. Business objects developers tend to reach higher levels of education than datastage developers. In fact, they're 6.2% more likely to graduate with a Master's Degree and 0.6% less likely to earn a Doctoral Degree.Datastage developer vs. Senior etl developer
A PL/SQL developer is responsible for managing and designing the network interface of PL/SQL packages according to business requirements and core specifications. PL/SQL developers must have excellent knowledge of technical solutions to create efficient databases and applications with optimal infrastructure and excellent navigation. They conduct multiple quality assessments to ensure the stability of systems before releasing the final outputs, including the development of instructional manuals and troubleshooting guides. A PL/SQL developer also enhance the features of existing packages and resolve possible downtimes and delays.
There are many key differences between these two careers, including some of the skills required to perform responsibilities within each role. For example, a datastage developer is likely to be skilled in "database," "datastage etl," "ibm db2," and "metadata," while a typical senior etl developer is skilled in "informatica powercenter," "informatica workflow," "schema," and "data analysis."
Senior etl developers earn the highest salary when working in the hospitality industry, where they receive an average salary of $115,824. Comparatively, datastage developers have the highest earning potential in the health care industry, with an average salary of $107,514.Most senior etl developers achieve a similar degree level compared to datastage developers. For example, they're 3.4% more likely to graduate with a Master's Degree, and 0.1% more likely to earn a Doctoral Degree.Datastage developer vs. Pl/sql developer
Types of datastage developer
Updated January 8, 2025
