We provide IT Staff Augmentation Services!

Sr. Datastage Resume

3.00/5 (Submit Your Rating)

Richfield, MN

SUMMARY:

  • Over 7 years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) analysis, design, development, Testing and implementation.
  • Over 6 years of ETL/Datastage tool experience using IBM Websphere/Ascential DataStage (Ver8/7/6/5.1), Quality Stage, Orchestrate/PX designing and developing jobs using Profile Stage 7.x/6.x, Designer,DataStageManager,DataStage DirectorandDataStage Administrator and DataStageParallel Extender.
  • Experience in Data Modeling, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling.
  • Developed the Source-Target Mapping for the Dimensions and Fact Tables.
  • Extensively used Parallel Extender to load data into data warehouse with different techniques like Pipeline and Partition in MPP environment.
  • Used Datastage Enterprise Edition/Parallel Extender stages like Datasets, Sort, Lookup, Change Capture, Funnel, Row Generator stages in accomplishing the ETL Coding.
  • Conducted detailed data analysis / reporting using IBM Websphere Information Analyzer for the multiple sources from various systems
  • Experience in implementing DB2, DB2/UDB, Oracle 10.2 / 9i / 8i / 8.0, SQL Server, PL/SQL, SQL*Plus and Teradata V2R5 V2R6 database applications.
  • Excellent experience in TERADATA Utilities: BTEQ, Fastload, Multiload, Fastexport
  • Used ETL Tool, to create jobs for extracting the data from different databases, flat files & Mainframe files.
  • Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
  • Experience in all Testing Phases: Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
  • Strong skills in analysis Coding using SQL and PL/SQL, Developing, Writing Unix Shell Scripts and code/script testing.
  • Expertise in Data warehousing and Data migration.
  • Extensive experience in Shell Scripting
  • Extensive experience in data modeling using Erwin tool.
  • Extensive experience in loading high volumes of data.
  • Ability to adjust to people, circumstances & responsibility, with a Drive for results through self-motivation & self-candor.
Technical Skills:

ETLTools

Data Stage Enterprise Edition 8.1/7.5.2/7.5/7.1/7.0/6.3/5.1 (Parallel Extender),Quality Stage 8.1, 7.1, Information Analyzer

Data Modeling Tools

Erwin 3.5.2/4.0, Visio 2003

Databases

Oracle 10g/9i/8i, MS SQL Server 7.0/6.5, SQL Server 2005, Sybase12/11.9/10, DB2 UDB V9, Teradata V2R3/V2R4.1,MS Access 2000/97

Tools

SQL*Plus, SQL*Loader, Version Control

Operating Systems

IBM AIX 5.2/4.x, HP-UX, Linux

Programming

SQL, PL/SQL, Unix Shell Scripting, Java 2.0, HTML, DHTML

Languages

SQL, PL/SQL, C, C++ , BASIC

CM Tools

Clear Case, Clear Quest.

Education:

Master’s in Information System.

Work Experience

Confidential,Richfield, MNJune 2011 – Till Date Sr. DataStage Developer
Responsibilities:

  • Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data.
  • Good hands on exp with Datastage 8.0.
  • Used DataStage Parallel Extender to load data, utilizing the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
  • Used DB2 EE stage for doing loads into DB2 UDB Database and to load large volumes of data into Teradata V2R4 using Teradata Fast Export, Multi Load, and T-Pump.
  • Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator from various database DB2 Enterprise, Oracle Enterprise.
  • Written SQL and PLSQL procedures to facilitate coding.
  • Worked extensively on UNIX.
  • Experience in IBM info server and SAP integrations.
  • Built several Custom operators, Wrapper Operators to meet complex business transformation requirements.
  • Participated in source to target mapping design document, prepared system requirement documents based on data model and source target mapping documents.
  • Identify business rules for data migration and perform data administration through data models and metadata.
  • Optimized Query Performance, Session Performance and Reliability.
  • Scheduled various ETL Batch processes using AUTOSYS 4.5
  • Used various stages of Quality stage like standardize stage, survive stage, format convert, transfer and unjoin stages.

Environment: Ascential DataStage 7.5.1, 8.1, SQL, Db2 v9/8.2,Metastage, Quality Stage 7.5,Java J2EE, Teradata V2R4, IBM AIX4.3, Erwin 4.1, IBM AIX 4.3, AUTOSYS, Clear Case.

Confidential,Miami, FL July 2010 – April 2011

Sr. Data Stage Developer
Responsibilities:

  • Involved in performance tuning of the ETL process and performed the data warehouse testing
  • Designed the complete Decision Support System by creating different types of reports for trend analysis using filters, conditions and calculations
  • Applying normalization concepts and understand the trade-offs between different schema designs
  • Extensively used IPC, Link Pratitioner and Link Collector in improving the performance.
  • Worked on programs for scheduling Data loading and transformations using DataStage from legacy system to Teradata database using Teradata MultiLoad scripts
  • Developed PL/SQL procedures that will take all the files sent by Source system as input and will insert data into target tables in the required format, data transfer is done on monthly basis.
  • Worked with DataStage Manager for importing metadata from repository, new job Categories & creating new data elements
  • Involved in analyzing scope of application, defining relationship within & between groups of data, star schema, etc
  • Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
  • Identifying required dimensions and facts for the schema from the source systems
  • Create new projects in DataStage through Administrator, assigning proper and permissions to DataStage users, setting up the Environment variables to help with performance tuning.
  • Reporting was done using Cognos Reporting tools

Environment:Ascential DataStage 8.1 (Designer, Director, Administrator), Ascential Parallel Extender, QualityStage, Teradata, Windows 2007, ERwin and UNIX, Cognos, MS Project, MS Visio

Confidential,Woodland Hills, CA Jan 2009 – July 2010ETL/Datastage Developer

Responsibilities:

  • Involved in design and development of Parallel and Server Jobs.
  • Actively participated in business meetings with the business users in order to gather the business requirements.
  • Developed the Technical Design and Unit Test Plans for Projects
  • Created process flow diagrams using Microsoft VISIO.
  • Developed the audit component to ensure the ftp source file has properly landed in the landing zone.
  • Involved in the development of Common Error Management to capture and handle the error records
  • Developed job sequence and implemented restart ability using various checkpoints.
  • Extensively worked on DataStage Director, DataStage Manager and knowledge of DataStage Administrator.
  • Developed various DataStage jobs in Enterprise Edition (parallel Extender) using DataStage Designer.
  • Used various stages like transformer, funnel, lookup, join, merge, remove duplicates, change capture, filter, aggregator etc.
  • Written Unix Shell Script for scheduling DataStage jobs, to handle Error Management and Audit Management.

Environment: Ascential DataStage 7.5.1, Oracle 9i, SQL Server2000, TOAD, SQL, PL/SQL, Erwin 4.x, AIX-UNIX 5.2, Autosys, Microsoft Visio and Windows 2000.

Confidential, Richmond, VA. Mar 2008 – Jan 2009
DataStage Developer
Responsibilities:

  • Attended development phase meetings for Business Analysis and Requirements Gathering.
  • Created DataStage jobs, batches and job sequences.
  • Developed Architecture for building a Data warehouse by using data modeling tool ERwin.
  • Worked on programs for scheduling Data loading and transformations using DataStage from legacy system to Oracle 10g using SQL* Loader and PL/SQL.
  • Designed and Developed PL/SQL Procedures, functions, and packages.
  • Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
  • Wrote shell scripts for Data Acquisition as a part of ETL process.
  • Created jobs and analyzed scope of application, defining relationship within & between groups of data, star schema and more.
  • Identified suitable dimensions and facts table for schema.
  • Created and loaded data warehouse tables like dimensional, fact and aggregate tables using Ascential DataStage.
  • Used Job Control routines and Transform functions in the process of designing the job.
  • Scheduled the jobs via the Autosys.
  • Wrote Extensive UNIX scripts for running the DataStage jobs.
  • Tuned DataStage jobs to enhance their performance.

Environment:Ascential DataStage 7.5.1, Oracle 10g SQL, PL/SQL, Windows NT, UNIX, DB2 Erwin, Autosys,

Confidential, San Francisco, CA Mar 2007- Feb 2008
ETL Designer/Developer
Responsibilities:

  • Involved in the design and development of Data Warehouse.
  • Worked closely with data modeler and database administrator to understand the business process of the data warehouse model.
  • Upgraded and Installed DataStage Clients from 6.5 to 7.5 on Windows 2000 user machines.
  • Extensively worked withParallel Extender.UsingParallelProcessing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
  • Worked closely with data modeler and database architect during the design and development of ETL technical specification document.
  • UsedDataStage Designerto develop processes forextracting, cleansing,transforming, integrating and loadingdata into Data Warehouse database.
  • PerformedImport and Exportof DataStage components and table definitions using DataStage Manager.
  • Extensively usedFlat File Stage, Hashed File Stage, DB2 UDB Stage, FTP Plug-inStage andAggregator Stage during ETL development.
  • Converted Oracle, DB2, Mainframes data intoSAPdata warehouse by usingSAP R/3Packs likeABAPextract, load,BAPI, IDOCpacks.
  • Extracted, cleansed, data fromMainframeslegacy systems by using COBOL programming and transformed loaded into oracle data warehouse.
  • Used DataStageDirector to Run and Monitor the Jobsperformed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
  • UsedMetastagefor metadata loading and as storage for Repository.
  • Scheduled the job run process by usingUnix Shell Scriptingto run as per the requirement.
  • Loaded the raw data to Oracle usingSQL Loader.
  • Worked on Oracle Warehouse Builder for converting data and also integrating the data.
  • CreatedShared Containerstages to use in other jobs and scheduled to use the containers inParallel extender.
  • Used AscentialProfile stagefor cleansing and mining of the data while loading into data warehouse.
  • StrongUNIX administrationskills for increasing the performance of the multiple nodes.
  • UsedWMQ filesfor message transportation across different application and database servers.
  • Documented the Data Warehouse development process and performed knowledge transfer to Business Intelligence developer.

Environment: Ascential Datastage 7.5, Parallel Extender and Mainframes, MetaStage, ProfileStage, Windows NT 4.0/2000, IBM AIX, DB2 UDB, Oracle 9i, SAP R/3 Packs, Erwin, WMQ files.

Confidential,India Jan 2005 – Feb 2007
DataStage developer

Responsibilities:

  • Developed healthcare system making using Data Marts.
  • Extracted the data stored in different databases and loaded into Oracle system.
  • Involved in the creation of jobs using DataStage designer and used Director to validate, schedule, run and monitor the DataStage jobs.
  • Involved in designing the procedures for getting the data from all system to Data Warehousing system.
  • Information stored in table definition and is entered using DataStage manager.
  • Extensively used ETL Tool to load data from DB2 to Oracle Database.
  • Exporting the universe to the repository to make resources available to the users.
  • Created the reports using the universes as the main Data providers and writing the complex queries including sub queries, unions, joins, intersects and aliases.
  • Extensive use of slice and dice for generating master/detail and tabular reports.

Environment:Ascential DataStage 7.5.1, Oracle 8i/9i, SQL, PL/SQL, Windows NT, Unix,

We'd love your feedback!