We provide IT Staff Augmentation Services!

Datastage Developer Resume

3.00/5 (Submit Your Rating)

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

We'd love your feedback!