Datastage Developer Resume
Hines, IL
SUMMARY
- Over 11 years of experience in Information technology, with over 8 years of expertise in DataStage and Data warehousing in various domains using IBM Infosphere (Ascential) DataStage 8.5/8.1/7.x (Manager, Designer, Director, Administrator, Version Control), Parallel Extender, ProfileStage, and QualityStage.
- Extensively involved in teh development of DataStage ETL process for extracting data from different data sources, data transformation and Loading teh data into data warehouse for data mart operations
- In depth experience in dealing with Ascential DataStage stages (hash, ftp, merge, sort, aggregator, lookup etc)
- Developed E - Mail Notification Process on Successful Completion or Failure of DataStage Jobs
- Experience in creating Infopackages for SAP-BW and writing data into SAP-BW using PACK for SAP R/3-BAPI, ABAP extract PACK for SAP R/3, IDOC Load PACK for SAP R/3 and IDOC Extract PACK for SAP R/3
- Strong Skills in Coding (Stage Variables, Derivations and Constraints) Business Logics in Transformation Stage
- Developed DataStage jobs in Server and Mainframe environment
- Extensive experience in DataStage Job Sequence
- Created table definitions and custom transforms using DataStage Manager
- Used DataStage Director to validate and run teh DataStage jobs
- Used built in transforms and created custom transforms in DataStage
- Accomplished complex tasks and scheduled multiple jobs using Universe Basic
- Well versed with understanding/grasping complex table hierarchies and business models
- Extensively used Parallel Stages like Sort, Merge, Aggregator, Remove Duplicates, Join, Row Generator, Column Generator, Head and Peek for development and debugging purposes
- Used DataStage Parallel Extender for improving teh performance of jobs
- Knowledge of configuration files for Parallel jobs
- In depth noledge of Dimensional Data Modeling, Star Schema, Snowflake
- Involved in maintaining logical and physical models
- Experience in utilizing Defect Tracking Tool (Rational ClearQuest)
- Exposure to QualityStage and MetaStage
- Very strong in Oracle and Teradata SQL
- Excellent communication and interpersonal skills
- Versatile team player with proven problem solving skills
TECHNICAL SKILLS
Languages: PL/SQL, SQL, COBOL, Java, HTML, XML
Databases: Oracle 11g, DB2, TERADATA, SQL server2000, Sybase, MS - Access
Scripting Languages: SQL Scripts, UNIX shell scripting, JCL
GUI Tools: Developer/2000, Visual Basic 5.0, TOAD, DB Admin, RBMS, TestMan.
ETL Tools: Infosphere 8.1/8.5, DataStage 7.x, QualityStage V 7.5, DataStage PX (Parallel Extender), DataStage Version Control
Data Warehouse Tools: Visio, Erwin
CRM: SAP-BW 3.1, ABAP, BAPI and IDOC
BI Tools: Business Objects V6.1, SAS
Operating Systems: HP-UX, UNIX (SunOS 5.9, Solaris 2.9/2.8/2.6), AIX, MVS, Windows
PROFESSIONAL EXPERIENCE
Confidential, Hines, IL
DataStage Developer
Responsibilities:
- Extensively used DataStage Designer for extracting, cleansing, transforming, integrating and loading data
- Strong skills in coding Stage Variable, Constraints for implementation of business logic in transformer stage
- Analyze conversion requirements, specifications and data
- Involved in design and code reviews
- Extensively used hashed file for lookup and to improve teh performance of jobs
- Worked extensively on different types of stages like Sequential file, Oracle OCI, ORABULK, Hashed File, Complex Flat File, Aggregator, Transformer, Sort, Link Collector for developing jobs
- Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance
- Created validation jobs, test cases for unit testing and integration testing
- Provided teh necessary support for building DataStage projects, jobs and teh migration of code through teh development environments to Production.
- Used DataStage Manager for Export, Import of Projects and Run Multiple Job Compilation
- Run conversions in test and production environments
- Used DataStage Director to run, monitor, validate and check for any errors in jobs after job run was successful
- Maintained a backup of teh DataStage in case of emergency with daily DataStage back up
- Performed performance tuning of teh jobs by monitoring job run statistics
- Analyzed application coding errors, functional specifications and business requirements associated with design enhancements
- Extensively used Defect Tracking Tool (Rational ClearQuest)
- Used Serena Dimensions as software repository for all documentation and code
- Developed reports manually as well as using SQL scripts & UNIX Shell Scripting
- Documented Run Books for all conversions (VETSNET, CH31,VITAL)
Environment: IBM Websphere DataStage 7.5/Infosphere 8.1/8.5, SunOS, Oracle 11g, Tuxedo, Rational ClearQuest, Serena Dimensions, PL/SQL, Unix shell scripting, SQL Scripts, Attachmate Reflection X
Confidential, Milwaukee, WI
DataStage Developer
Responsibilities:
- Analyzed metadata and data
- Mapped multiple source’s Metadata to Single Metadata
- Extensively used DataStage Designer to design & develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse
- Strong skills in coding (stage variables, derivations and constraints) business logics in transformation stage
- Extensively used Hashed files to improve teh performance of Referential Lookups
- Strong skills in coding Error Handling - functionality
- Strong skills in defining user defined SQL in Oracle stages for better job performance
- Designed and developed DataStage job templates and naming standards
- Extensively used Link Partitioner and Link collector in improving teh performance
- Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs
- Used DataStage Manager for creating new job categories, metadata definitions, and data elements, import/export of projects, jobs and datastage components, viewing and editing teh contents of teh repository as well as writing routines
- Developed job sequencer with proper job dependencies, job control stages, triggers.
- Involved in Design and Code review and walkthroughs
- Used DataStage Director and its run-time engine to schedule, validate, run and monitor teh resulting executable versions
- Implemented change request
- Used IBM’s “best practices” to design and code all DataStage jobs
- Worked closely with teh writers of teh Technical Specs
- Proficient in creating CSV files for SAP-BW and Using BW plug-in Stages
- Involved in creating SAP-BW info packages
- Created Test Plans for Unit and Integration Testing for designed jobs
- Analyzed teh performance bottlenecks and fine-tuned teh jobs
Environment: DataStage7.5.1, SAP-BW v3.1, Windows 2000 Server, SunOS 5.9, Oracle9i, Toad, Citrix MetaFrame.
Confidential, Indianapolis, IN
DataStage Developer
Responsibilities:
- Involved in review, design & developing environment (development, testing, version and production) for Datastage migration process on NT platform
- Reviewed and modified existing COBOL version of ETL process specifications to Datastage process
- Developed logical job flows for Datastage jobs basing on existing COBOL programs
- Designed jobs in PX as per given specs
- Used Parallel Extender to extract data from source systems such as Oracle, Flat files to target system on Oracle
- Performed ETL Optimization and tuned some key DataStage jobs for better performance
- Used stages like Sort, Merge, Aggregator, Remove Duplicates, Join, Transformer, Dataset, Peak, Funnel, Row Generator, Row Merger and other stages
- Created naming and system standards for lookup, transformation and target tables
- Strong skills in coding (stage variables, derivations and constraints) business logics in transformation stage
- Experience in using built-in & custom defined transform functions & routines
- Coded user defined SQL’s in ODBC stages for better job performance
- Involved in developing job automation process, to run Datastage jobs using global parameter file
- Involved Document Review’s with business analysts and involved in training business analysts & existing COBOL programmers to understand DataStage ETL Process
- Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence
- Created UNIX shell script
- Created Test Plans for teh designed jobs for unit testing
Environment: DataStage PX (Parallel Extender), Oracle 9i, UNIX, MS-SQL Server2000, DB2, MVS, JCL, COBOL, Business Objects V5.1, OS/390, Windows NT, IBM AIX 5.2, Erwin 3.5
Confidential, Indianapolis
ETL Developer
Responsibilities:
- Created DataStage server jobs using Designer and extracted data from various sources, transformed data according to teh requirement and loaded into data warehouse
- Involved in identifying source systems and analyzing metadata and data
- Used DataStage Manager to define Table definitions, Custom Routines and Custom Transformations
- Worked with various stages like Hashed File, Aggregator, ODBC, Transformer, Pivot, UDB DB2 and OCI Stages
- Extensively wrote Custom Routines and Transformations as per teh business requirements
- Used Hashed files, IPC stages to improve teh performance of jobs
- Involved in development phase meetings for Business Analysis and Requirements document reviews
- Developed Jobs Sequencer and Created shared containers
- Created test cases for unit testing and integration testing
- Moved jobs across multiple environments
Environment: Ascential DataStage V7.5/7.x, Oracle 9i/8i, TOAD, UNIX, SQL*plus, Windows NT
Confidential, Hartford, CT
DataStage Developer
Responsibilities:
- Extensively worked with DataStage Active and Passive Stages
- Extensively involved in creating database procedures, functions and triggers
- Used DataStage for extracting, cleansing, transforming, integrating, and loading data into data warehouse
- Used DataStage Manager to export/import jobs
- Extensively used Hashed files to improve teh performance of Referential Lookups
- Used shared containers, Link Partitioner, Link Collector, Sequential File, OracleOCI and ODBC stages in jobs
- Created Master Job Sequencer
- Analyzed teh performance bottlenecks and fine-tuned teh jobs
Environment: DataStage 6.x/7.0, Windows NT, Oracle 9i/8i, SQL, PL/SQL, SQL*Loader, RAFT, Mainframe systems
Confidential, NY
Oracle Developer
Responsibilities:
- Designed and developed forms and reports covering both new reports and customization of existing report layout to include additional columns, additional parameters, changes in layout
- Tested individual modules for conformance to teh client's specification
- Conducted Integration testing for checking teh effective and efficient working of teh application
- Involved in writing shell scripts, PL/SQL, stored procedures, functions and teh database triggers
Environment: Oracle 7.3/8x, SUN Solaris and Windows NT Client Server, PL/SQL 8.0.5, SQL*PLUS 8.0, SQL Navigator, TOAD, Developer 2000 (Forms4.5/5.0 & Reports 2.5/3.0)
Confidential
Oracle Developer
Responsibilities:
- Identified system requirement, create schema objects like indexes views, stored procedures and synonyms
- Involved in writing teh triggers which internally calls procedures and functions
- Designed user interface to enter teh employee personal details, qualifications, awards, punishments and loans
- Prepared test cases and generated reports
- Involved in documenting teh entire technical process and testing teh UAT to satisfy teh end user
Environment: VB 6.0, Oracle 8i, Windows 98