- Featured in:
-
More Datastage Developer Resumes
Use these Datastage Developer samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Datastage Developer Resume Samples
No results found
0-5 years of experience
Project involves integration of different services provided by the telephone industry into one data store to perform cross-sell analysis
- Involved in the creation of dimensional schema design including dimension tables, fact tables and aggregate tables
- Involved in the high-level and detailed design of the project
- Created ETL IBM-Datastage parallel jobs to extract and reformat the source data so it can be loaded into the new data warehouse schema
- Conducted unit tests using various test cases as well as conducted QC testing
0-5 years of experience
Provided technical expertise to clients on implementing PeopleSoft EPM 9.1 Data Warehouse with Websphere DataStage 8.5 ETL tool.
- Setup and configured EPM 9.1 Foundation (Business Units, SetIds, Calendars, and Currency Codes) for Campus Solutions Warehouse and Analytic Reporting.
- Loaded data into EPM 9.1 MDW using InfoSphere DataStage 8.5.
- Performed troubleshooting and performance tuning for DataStage 8.5 ETL jobs. Analyzed error table entries and resolved related issues.
- Applied bundles and developed maintenance documentation for future bundle releases.
- Developed EPM and DataStage configuration documentation for Campus Solutions Warehouse.
- Provided training and direction to Client Resources.
0-5 years of experience
Proactively sought out new tasks to make best use of available time.
- Earned reputation for impeccable work and attention to detail.
- Maintained good working relationship with managers and colleagues.
- Executed unit tests to ensure proper GUI and coding standards.
- Given training to the client when updated was done.
- After every Intensive Revision of Electoral roll we can consolidate it with the Supplements roll using the S/W.
0-5 years of experience
Involved in upgrading the existing program from DataStage XE/ 390 Edition version 6.0 to DataStage Enterprise MVS Edition version 7.0.
- Optimized the existing jobs for better performance and implemented new business logic in the production environment.
- Implemented end user requirements by creating Stage Variables and coding the business rule logic for transformations and rejections with a Business Rule Stage.
- Performed load operations using a Relational Stage for updating and deleting data in a DB2 table in the Mainframe.
0-5 years of experience
- Designed, Compiled, Tested, Scheduled, and Run DataStage jobs
- Designed DataStage jobs to extract, transform and load data from various sources and archive systems like Oracle, Text files, XML, CSV, IBM DB2, MS SQL Server and Teradata into Data Warehouses and Data Marts
- Used SQL for data querying and database administration with Oracle database
0-5 years of experience
Involved in creating and maintaining Sequencer and Batch jobs.
- Used DataStage EE 7.5.2 to load data into the Oracle warehouse.
- Involved in development of Job Sequencing using the DataStage Sequencer.
- Used DataStage Designer and Director to schedule and monitor resulting executable versions.
- Created local and shared containers to facilitate ease and reuse of jobs.
- Managed Repository Metadata from DataStage Manager.
- Performing Unit Testing and integration.
- Environment: Ascential DataStage, Oracle Citrix, Mercury Test Director
0-5 years of experience
BOA – Involved in Migration project from BOA to ML, EDW projects are getting the transactional data and events data from BOA sources to ML.
- I was involved in Designing the Target Schema definition and Extraction, Transformation (ETL) using Data stage both server and parallel editions and worked with XML files and XSD’s.
- Worked with objects in IBM Information Server Repository like jobs, sequences, parameter sets, routines, shared containers and table definitions.
- Extensively Used Datastage (ETL Tool) , Oracle PL/SQL, UNIX, MS Products to Extract, Cleanse, Transform and load data to target systems with right format and level of detail.
- Used the Datastage Designer to develop the ETL processes for extracting, cleansing, transforming and integrating the EDW data into datamarts.
- Used Star Schema and Dimensional modeling for creating data mappings between various BOA data sources to the EDW Data marts.
0-5 years of experience
Senior ETL/DataStage Developer/Lead responsible for development, maintenance, and support of ETL jobs to load source system data into Oracle warehouse for initial, daily, and monthly loads, provide DataStage expertise, and mentor other developers, following Best Practices and Standards.
- Utilize DataStage/PX 7.5.1 to design, build, and support jobs used to populate Oracle warehouse.
- Manage all data warehouse operations for this project, including but not limited to testing, migrations (both DataStage and Oracle), job scheduling, trouble shooting, and production support.
- Utilize SQL Programmer and SQL Plus to create, modify, and query Oracle tables for loading, debugging, and data mining.
- Utilize DB2 Connect and IBM Mainframe to query DB2 source tables for data verification, profiling, and data mining.
- Mentor developers on proper usage of DataStage and best practices and standards.
- Work in conjunction with Data Modelers and Architects to implement/modify data models for Stage, Hub, Hub Prime, and Data Mart environments as required to support Data Warehouse reporting and modeling needs.
- Utilize Exceed to access Unix components.
0-5 years of experience
Training advanced level Developer on Datastage 8.5 PX
- Development Project on Datastage 8.7
- Migration Project Datastage Server and Px 7.5 To Px 8.5
- Retro documentation Project
- List of jobs contained in a dsx file
- List of types of a dsx file
- List and attributes of all inputs and outputs (DB connector and files)
- Training beginner level Developer on Informatica 9.X
0-5 years of experience
- Created new enterprise database for the three existing clubs of the company
- Created new SAS programs to QC the Ascential DataStage jobs created
- Worked in concert with the Business Requirements Analyst to identify and validate data required from various source systems
- Developed data extractions and tested all data extractions
0-5 years of experience
- Lead Datastage developer on the Oracle Claim Data Warehouse. At our development peak I oversaw 6 contractors and employees.
- Responsible for monitoring Datastage job development (included code reviews, concept discussions, error handling issues, etc ), analyzing datastage source conversion/bottleneck issues, and creating overall data flow process. Made several improvements to old standards and helped resolve many performance issues within both Datastage and the Databases used to extract and load data.
- Over 150 Datastage jobs created in Phase 1 and another 150 were created in Phase 2.
- Jobs used all major components within datastage including transformer stages, lookup stages, join stages, modify stages, sequential files, datasets, CDC stages (change data capture) etc
- Warehouse was built on a star schema and involved heavy relationship processing.
- Appworx V6.1 was used as the ETL scheduling tool for the project. Responsible for creating and testing the modules/chains involved in order to call the datastage jobs.
0-5 years of experience
This project includes integrating data from ServiceLink into UDW+ to help monitor and performance from units within the University. There is a limitation in seeing the underlying data in these metrics and what the root cause is for service issues. Once the data is available in UDW+, a prototype dashboard will be created for SPA to help them manage their service operations.
- Architect, Design and Develop all ETL components including using IBM Information Server, Web Services components, InfoSphere Datastage and QualityStage.
- Create all the extract jobs to pull the data from the webservices by understanding the limitations of the service links.
- Architect and design the whole ETL process from end to end.
- Create process and data lineage diagrams.
- Performed Unit testing, Integration testing and User Acceptance testing for every code change and enhancements in development, QA, Preproduction and Production.
- Create Reconciliation views required for the fact tables and gave the prototype to the end user before moving onto build phase of the star schema.
- Reused some of the components to have validations in place so that we don’t miss any data from webservices source.
- Built some routines to have a controlled data processing from the web services.
- Designed the ETL framework for the entire process for production support teams.
- Designed the ETL to take care of the stub records.
Data Systems Administration Cover Letter Examples
Rate This Article
[Datastage Developer]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
