We provide IT Staff Augmentation Services!

Datastage Developer Resume

San Antonio, TX

SUMMARY:

  • Over6+ yearsof experience in IT industry especially in client/server business systems and Decision support Systems (DSS) analysis, design, development, Testing and implementation.
  • Over5 yearsof ETL/Datastage tool experience usingIBM InfoSphere Information Server Version(Ver8/7),Quality Stage, ,DatastageManager,Datastage DirectorandDataStage AdministratorandDataStageParallel Extender.
  • Experience in implementingNetezza, DB2, DB2/UDB, Oracle 10.2 / 9i / 8i / 8.0, SQL Server, PL/SQL, and SQL*Plusdatabase applications.
  • Developed the Source-TargetMappingfor the Dimensions and Fact Tables.
  • Extensively usedParallel Extenderto load data into data warehouse with different techniques like Pipeline and Partition in MPP environment.
  • Used Datastage Enterprise Edition/Parallel Extender stages likeDatasets, Sort, Lookup, Change Capture, Funnel, Row Generatorstages in accomplishing the ETL Coding.
  • Conducted detailed data analysis / reporting usingIBM WebsphereInformation Analyzerfor the multiple sources from various systems
  • Excellent experience inTERADATAUtilities: BTEQ, Fastload, Multiload, Fastexport
  • Used ETL Tool, to create jobs for extracting the data from different databases, flat files & Mainframe files.
  • Extensively ImplementedError Handling Concepts, Testing, Debuggingskills and Performance tuning of targets, sources, transformation logics.
  • Experience in all Testing Phases:Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
  • Experience inData Modeling, Star Schema/Snowflake Schema modeling, FACT & Dimensionstables, Physical & logical data modeling.
  • Strong skills in analysis Coding usingSQLandPL/SQL, Developing, Writing Unix Shell Scripts and code/script testing.
  • Expertise in Data warehousing and Data migration.
  • Extensive experience inShell Scripting
  • Extensive experience indata modelingusing Erwin tool.
  • Extensive experience in loading high volumes of data.

Certification: "IBM Certified Solution Developer - InfoSphere DataStage v 8.5"

Technical Skills:
  • ETLTools: Data Stage Enterprise Edition 8.1/7.5.2/7.5/7.1 , 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, Netezza 6.0
  • Tools: SQL*Plus, SQL*Loader, Version Control , SQL Squirrel, Control- M
  • Operating Systems: IBM AIX 5.2/4.Linux , Solaris
  • Programming: SQL, PL/SQL, Unix Shell Scripting
  • Languages: SQL, PL/SQL, C, C++ , BASIC
  • CM Tools: Clear Case, Clear Quest.

MAJOR ASSIGNMENTS:

Confidential, San Antonio, TX May 2012 - Till Date
DataStage Developer

Responsibilities:

  • Involved in the migration of the jobs from DB2 to Netezza.
  • Extensively used Aginity for running and test the SQL queries.
  • Good hands on experience with Datastage 8.1.
  • Used DataStage Netezza Enterprise stage to load data, utilizing the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
  • Used Netezza Enterprise stage for doing loads into Netezza Database.
  • Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator.
  • Written SQL and PLSQL procedures to facilitate coding.
  • Worked extensively on UNIX.
  • 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.
  • Scheduled various ETL Batch processes using Control-M

Environment:Datastage 8.1, Netezza 6.0, SQL, Db2, Linux, Control- M

Confidential, Lyndhurst, NJ June 2011 - May2012
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.
  • Worked on programs for scheduling Data loading and transformations using DataStage from legacy system to Oracle 10g using SQL* Loader and PL/SQL.
  • 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.
  • 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, Oracle 10g SQL, IBM AIX4.3, Erwin 4.1, IBM AIX 4.3, AUTOSYS, Clear Case.

Confidential, Denver, CO Jan 2010 - June 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.
  • Extensively used ETL Tool to load data from DB2 to Oracle Database.
  • 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, , Oracle 9i, SQL Server , PL/SQL, Windows 2007, ERwin and UNIX, Cognos, MS Project, MS Visio

Confidential, Denver, CO Feb 2009 - Jan 2010 ETL/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, Hartford, CT April 2008 - Feb 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.
  • 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.
  • 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, PL/SQL, Teradata V2R4, Windows NT, UNIX, DB2 Erwin, Autosys.

Confidential, India July 2006 - April 2008
DataStage developer

Responsibilities:

  • 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.

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

Hire Now