Automatically apply for jobs with Zippi
Upload your resume to get started.
Datastage developer skills for your resume and career
15 datastage developer skills for your resume and career
1. SQL Server
- Used SSIS for Transformation the data for Sort, Aggregation, Data integration, and Automate Maintenance of SQL Server Database.
- Phase 3: The Phase3 of this project focuses at bringing Incoming T/C Life testing data into the SQL server database.
2. Database
A database is a collection of data and information which makes it easy to view, access, and manage. Databases save a lot of time and can store huge amounts of data. Databases make sorting data easier and stores it in certain fields which narrows the searching criteria. A database usually contains tables, graphs, and columns to display data.
- Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
- Analyzed, conceptualized/designed the database that serves the purpose of providing critical business metrics.
3. Unix
UNIX is a computer operating system that was first created in the 1960s and has been constantly updated since then. The operating system refers to the set of programs that enable a machine to function. It is a multi-user, multi-tasking device that works on computers, laptops, and servers. UNIX systems also have a graphical user interface (GUI), similar to Microsoft Windows, that makes it simple to use.
- Performed Unit testing of DataStage Jobs using Unix Shell Scripting and with web application to ensure that it meets the requirements.
- Used UNIX and PERL scripts to execute jobs and also used the DataStage Director for scheduling, executing and monitoring jobs.
4. Data Warehouse
Data warehouse, often abbreviated as either DW or DWH is a system used in computing for data analysis as well reporting. The DW is also considered to be an integral component of business intelligence as they also provide storage facilities for both real-time and historical data. ETL and ELT are the two driving forces behind a data warehouse system.
- Provided day-to-day and month-end production support for various applications like Business Intelligence Center, and Management Data Warehouse by monitoring servers.
- Translated business requirements into physical Data Warehouse and Data Marts and developed DataStage jobs to populate data into them.
5. Datastage ETL
- Collaborated analysts, data modelers and developers to capture business logic and translated into DataStage ETL jobs.
- Reviewed, fine-tuned DataStage ETL jobs for high volume data processing with high velocity for batch processing.
6. Aggregator
- Developed DataStage jobs extensively using Aggregator, Sort, Merge, Data Set in Parallel Extender to achieve better job performance.
- Developed various jobs using stages OCI, Hashed file, Sequential file, XML, Aggregator, Pivot and Sort.
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.7. IBM DB2
- Worked on databases like Oracle 10g/11g, IBM DB2 by using ODBC, DB2 connectors.
- Used stages like Oracle Connector, Odbc Connector and DRS stage to extract data from Oracle and IBM DB2 databases.
8. Metadata
Metadata is a combination of two words, meta and data. Meta is a prefix defined as more comprehensive, and data means collection of data. Metadata is defined as the data that describes other data. It is used to summarize data about data to make the data easier to analyze.
- Use DataStage Manager utilities in designer for importing metadata from repository, creating new sequential file definitions and importing/exporting jobs.
- Worked with business teams and technical teams to capture all metadata related information is captured and maintained in business glossary.
9. Teradata
- Developed and used various SQL queries, Joins, Procedures for TeraData using TeraData utilities like BTEQ and SQL Assistant.
- Created stored procedures in TERADATA SQL Assistant.
10. PL/SQL
- Worked on programs for scheduling Data loading and transformations using Data Stage from UDB/DB2 to Oracle 8i using PL/SQL.
- Developed SQL, PL/SQL stored procedures, triggers, cursors for implementing business rules and transformations.
11. Extraction
- Worked on design and developing data extraction programs using DataStage client component Designer.
- Involved in preparing technical design/specifications for data Extraction, Transformation and Loading.
12. Toad
Toad is software that manages non-relational and relational databases that database analysts, developers, and database administrators use. Toad helps in minimizing the cuts in delivery timelines of projects. It also helps in maximizing the investment made by users in the field of data technology by automating all the processes.
- Used TOAD to interact with Oracle and used SQL Trace and Explain plan to improve the performance of the Jobs.
- Experience using SQL Plus and Toad for Oracle database.
13. Java
Java is a widely-known programming language that was invented in 1995 and is owned by Oracle. It is a server-side language that was created to let app developers "write once, run anywhere". It is easy and simple to learn and use and is powerful, fast, and secure. This object-oriented programming language lets the code be reused that automatically lowers the development cost. Java is specially used for android apps, web and application servers, games, database connections, etc. This programming language is closely related to C++ making it easier for the users to switch between the two.
- Created collaborations in Java CAPS (EAI) so that end systems will not face any issues with respect to integration.
- Automated whole process for encrypting members PII information using shell scripts that triggered Java script (SHA-256 algorithm).
14. XML
XML is a medium for storing and transporting data that is independent of software and hardware. XML stands for eXtensible Markup Language. XML, like HTML, is a markup language that was created to store and transport data. It was created with the intention of being self-descriptive. There are no predefined tags in the XML language. Another feature is that XML is extensible.
- Worked on XML stages for extracting data from XML input stage and loading it to XML format using XML output stage.
- Design, build, and manage complex data integration process using various Flat Files and EDI(XML files).
15. Windows XP
- Experience in usage of Operating Systems such as UNIX, WINDOWS XP/NT/2000/98/95.
- Prepared a production monitoring and support handbook Environment: Informatica power center 6.1/7.1, Oracle, windows XP, MS office Suite
5 Datastage Developer resume examples
Build a professional datastage developer resume in minutes. Browse through our resume examples to identify the best way to word your resume. Then choose from 5+ resume templates to create your datastage developer resume.
What skills help Datastage Developers find jobs?
Tell us what job you are looking for, we’ll show you what skills employers want.
List of datastage developer skills to add to your resume
The most important skills for a datastage developer resume and required skills for a datastage developer to have include:
- SQL Server
- Database
- Unix
- Data Warehouse
- Datastage ETL
- Aggregator
- IBM DB2
- Metadata
- Teradata
- PL/SQL
- Extraction
- Toad
- Java
- XML
- Windows XP
- Test Cases
- Source Systems
- Debugging
- Data Warehousing
- Oracle 10G
- Extract Data
- Data Capture
- Autosys
- QA
- Mainframe
- Data Marts
- Source Data
- Business Rules
- Data Models
- Linux
- Remove Duplicates
- UAT
- Oracle 11G
- Control-M
- Load Data
- IBM Infosphere Datastage
- ODBC
- FTP
- Oracle Sql
- Version Control
- Business Analysts
- EDW
- Production Environment
- Lookup
- Test Data
- Shell Script
- Performance Statistics
- DEV
Updated January 8, 2025
