- Featured in:
-
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Datastage Developer Resume Samples
No results found
Candidate Info
years in workforce
months at this job
Electrical Engineering
Management Information Systems
Datastage Developer
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
Candidate Info
years in workforce
months at this job
Computer Science
Management Information Systems
Peoplesoft Epm/datastage Developer
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.
Candidate Info
years in workforce
months at this job
Master of Arts
Datastage Developer
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.
Candidate Info
months in workforce
months at this job
Electrical Engineering
Telecommunication Management
Electrical Engineering
Datastage Developer Thru Symbiosis International
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.
Candidate Info
years in workforce
months at this job
Bachelor of Arts
Finance
Datastage Developer
- 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
Candidate Info
months in workforce
months at this job
Bachelor of Arts
Datastage Developer
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
Candidate Info
years in workforce
months at this job
Software Training
Engineering
Sr.datastage Developer
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.
Candidate Info
years in workforce
months at this job
Associate of Science
Mathematics
Senior Etl/datastage Developer/lead Responsible for Development, Maintenance, and Support
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.
Candidate Info
years in workforce
year at this job
Computer Science
High School Diploma
Datastage Developer
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
Candidate Info
years in workforce
years at this job
Office Administration / Medical Coding
Datastage Developer/analyst
- 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
Candidate Info
years in workforce
years at this job
Finance & Accounting
Senior BI Lead Datastage Developer
- 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.
Candidate Info
years in workforce
year at this job
Bachelor of Arts
Senior ETL Datastage Developer
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.
More Datastage Developer
Resumes
Datastage Developer Resume Success Stories
