We provide IT Staff Augmentation Services!

Datastage Developer Resume

Raleigh, NC

SUMMARY:

  • Over 7 years of progressively responsible experience in development, testing, documentation, production support & Integration applications using IBM Infosphere DataStage 11.3,9.1,8.x / 7.x, IBM DB2, Oracle 10g, 9i Technologies in Data Warehousing.
  • Expertise in Software Development Life Cycle (SDLC) and Production Support Life Cycle
  • Experience in Data Architecture (involving physical and logical design) of Data Warehouse applications.
  • Good hands on experience in RDBMS like Oracle, Netezza, SQL Server, Teradata, and DB2.
  • Working experience in data modeling and implementing stored procedures using PL/SQL.
  • Extensive knowledge of writing complex queries using SQL.
  • Sound knowledge with Netezza SQL with IBM Quality Stage 8.1 and info analyzer 8.1.
  • Experience in Data Integration, EDW and Data Mart projects.
  • Strong knowledge in OLAP and OLTP Systems, Dimensional modeling using Star Schema and Snowflake Schema.
  • Demonstrated work experience in Oracle to Infosphere DataStage Migration projects.
  • Working experience in DB2 Cursors, PL/SQL Triggers and Stored Procedures.
  • Expert in working with Infosphere DataStage Designer and Director.
  • Experienced with TOAD and PL/SQL Developer.
  • Used Operations Console to monitor the jobs performance and memory / CPU usage.
  • Proficient in developing ETL procedures using IBM Infosphere DataStage 7.5, IBM DataStage 8.x, 9.1, 11.3, 11.5 and UNIX Scripts.
  • Worked and extracted data from various database sources like Oracle 9i/10g, Flat files, DB2, UDB, XML.
  • Experience in writing, testing and implementation of the Stored Procedures, Packages and functions at the Database Level in Oracle 10g.
  • Experience in performance tuning both at Application Code Level and Databases Level.
  • Experience in designing optimum data marts and data warehouse tables with limited redundancy and for effective and performance efficient reports.
  • Have been a team player involved in many enhancements/developments and ensured successful completion of all the projects as per SLA (Service Level Agreements).
  • Extensive experience in using Built - in, Plug-in and Custom Stages for Extraction, Transformation and loading of the data.
  • Experience in design and implementation of Server and Parallel Jobs including Batches and Job Sequencers.
  • Strong communication and analytical skills and a demonstrated ability to handle multiple tasks as well as work independently or in a team towards resolution.
  • Extensively Written SQL/PL SQL Queries to extract data from various source systems and populate in SAP reports.

PROFESSIONAL EXPERIENCE:

DataStage Developer

Confidential, Raleigh, NC

Responsibilities:

  • Performing all phases of the Software Development Life Cycle (SDLC) including requirements analysis, application design, code development, testing and deployment
  • Designing and code in IBM DataStage to implement product features in collaboration with business and IT stakeholders
  • Implement business rules via IBM DataStage, stored procedures, middleware, and other technologies
  • Performed ETL Datastage coding using Datasets, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign DataStage jobs for performing the required integration
  • Worked on shell scripts that will invoke the Data Stage jobs passing all variables for job to execute with parameterized databases connection information
  • Extensively worked with IBM Infosphere DataStage 11.3 V - Designer and Director to load data from source extract files to the warehouse
  • Used Tivoli (TWS) to schedule the DataStage ETL batch jobs
  • Used DataStage Job Sequences to execute the jobs in a sequence order
  • Created DataStage Jobs to build business rules to load data
  • Used DataStage Director and Schedular monitor status of the jobs
  • Tuned DataStage jobs for better performance by creating DataStage Hash files for Staging the data and Lookups
  • Tuning ETL jobs and SQL queries for optimization
  • Participating in an Agile / Scrum methodology to deliver high - quality software releases on a periodic basis through Sprints
  • Troubleshooting production support issues post - deployment
  • Participating in an Agile / Scrum methodology to deliver high - quality software releases on a periodic basis through Sprints
  • Analyzed data with discrepancies through Error files and Log files for further data processing and cleansing
  • Working with upstream and downstream applications to define dependencies, interfaces, data formats etc.,
  • Documented the purpose of mapping to facilitate the personnel to understand the process and in corporate the changes when necessary

DataStage Developer

Confidential, Plano, TX

Responsibilities:

  • Designed and tested the Infosphere DataStage jobs for extract, transform and load.
  • Extensively involved in the data migration team to build the Re-usable IBM Infosphere DataStage job templates, common parameter sets, common IBM Infosphere DataStage job containers, analyzing with info analyzer 11.3, SQL extract procedures and common re-usable Shell Scripts.
  • Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
  • Data analysis, Data modelling concepts, Database design and Data migration using Quality stage.
  • Expert in using stages, Standardization, Scrubbing, Matching and Survivorship rules using Quality Stage.
  • Provide the Staging Solutions for Data Validation and Cleansing with PL/SQL and Data Stage ETL jobs.
  • Implemented Aggregate, Filter, Join, Lookup, Rank and Update Strategy Transformations.
  • Conducted ETL development in the Netezza environment using standard design methodologies.
  • Assessed the Netezza environment for implementation of the ETL solutions.
  • Used Star Schema and Normalization data modeling techniques for warehousing of data.
  • Extensively worked with IBM Infosphere DataStage 11.5, 11.3 V - Designer and Director to load data from source extract files to the warehouse.
  • Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
  • Created DataStage jobs to load data from sequential files, CSV, Flat files and DB2.
  • Cleansed, standardize data using Quality Stage and info analyzer.
  • Developed various jobs using Aggregator, Sequential File stages.
  • Standardize data to make it easier to find and create one unique view of the business entity with Quality Stage.
  • Used FastLoad, MultiLoad Scripts to load data into DB2 from Flat files.
  • Worked towards optimal performance when using Stages like LOOKUP, JOIN and MERGE.
  • Designed and developed Infosphere DataStage jobs for Loading Staging Data from different sources like Oracle, DB2 DB into Data Warehouse applying business rules which consists data loads, data cleansing and data massaging.
  • Used the IBM Infosphere DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions
  • Worked with Metadata Definitions, Import and Export of DataStage jobs using DataStage Tools Functionality.
  • Created Parameters and Parameter Sets where necessary.
  • Scheduled the server jobs using DataStage Director, which are controlled by DataStage engine and also for monitoring and performance statistics of each stage using IBM Quality Stage 11.3.
  • Used Netezza SQL to maintain ETL frameworks and methodologies in use by the company.
  • Collaborated with software architects to ensure alignment of the Netezza environment.
  • Participated actively in the Team meetings with the developers for bug reviews.
  • Developed Shell Scripts to automate file manipulation and data loading procedures.

Environment: Ascential IBM Infosphere DataStage 11.5, 11.3, 9.1/8.5/8.1 - Data Stage Designer, Netezza, Data Stage Director, Data Stage Manager, Quality Stage 11.3, Info Analyzer 11.3, AutoSys, Oracle, UNIX Shell Programming, DB2.

DataStage Developer

Confidential, TEXAS

Responsibilities:

  • Extensively used DataStage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
  • Collaborated with EDW Team in, High Level design documents for extract, transform, validate and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
  • Collaborated with EDW Team in, Low Level design document for mapping the files from source to target and implementing business logic.
  • Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
  • Tuned Transformations and jobs for Performance Enhancement.
  • Extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like Sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change Capture Data, Sort, Column generators, Funnel and Oracle Enterprise.
  • Created Batches (DS job controls) and Sequences to control set of jobs.
  • Extensively used DataStage Change Data Capture for DB2 and Oracle files and employed Change Capture Stage in parallel jobs.
  • Executed Pre and Post Session commands on Source and Target database using Shell Scripting.
  • Collaborated in design testing using HP Quality Center.
  • Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
  • Extensively used SAP R/3 and SAP BW packs
  • Collaborated with BI and BO teams to find how reports are affected by a change to the Corporate Data Model.
  • Collaborated with BO teams in designing dashboards and scorecards for Analysis and Tracking of key business metrics and goals.
  • Utilized Parallelism through different partition methods to optimize performance in a large database environment.
  • Developed DS jobs to populate the data into staging and Data Mart.
  • Executed jobs through sequencer for better performance and easy maintenance.
  • Performed the Unit Testing for jobs developed to ensure that it meets the requirements.
  • Developed UNIX Shell Scripts to automate file manipulation and data loading procedures.
  • Scheduled the jobs using AutoSys, Tivoli and Corntab.
  • Responsible for daily verification that all scripts, downloads and file copies were executed as planned, troubleshooting any steps that failed and providing both immediate and long-term problem resolution.
  • Provided Technical assistance and support to IT analysts and business community.

Environment: IBM InfoSphere DataStage and QualityStage 11.5, 11.3, 9.1, 8.5 (Administrator, Designer, Director), IBM Information Analyzer 8.0.1a, Microsoft SQL 2005/2008, IBM DB2 9.1, AIX 6.0, Microsoft SQL 2008, Oracle 11g, MS Access, SAP BW, SAP MDM, AS/400, Shell Scripts, WinSCP, ERwin 4.0, HP Quality Center, Tivoli, Corntab, AutoSys.

DataStage Developer

Confidential

Responsibilities:

  • Analyze the existing complex data loading procedure of the Application and identify the jobs need to be modified.
  • Develop new jobs.
  • Prepare Technical Specification Documents.
  • Populate data from a different source.
  • Coding for jobs and create reports for the end user.
  • Transform the field as user requirement.
  • Creating and Maintaining Traceability Matrix for the Test Plan/Test Specification (vs) Requirements.
  • Implement project in production.
  • After going live did also some change request and ISJR for some of the Intermediate Requirements to fulfil some more requirements and preparing technical and test document.
  • Investigate Testing environment and fix bugs if any.
  • Built DataStage jobs to read files from multiple tables using Oracle Connector Stage Created Sequencers with Exception Handling and Restarting Logics.

Tools: iWay Software, DataStage, IBM Quality stage 8.1, IBM Information Analyzer 8.1, Web FOCUS, VB6

Database: Oracle

TECHNICAL SKILLS

DataStage (6 years), DB2 (2 years), ETL (5 years), EXTRACT, TRANSFORM, AND LOAD (5 years), ORACLE (6 years), Netezza (2 years).

Hire Now