We provide IT Staff Augmentation Services!

Datastage Consultant Resume

Dallas, TexaS

SUMMARY:

  • 9+ Years of overall IT experience in Data warehousing Applications design, Development, Testing and Project Management, With 7+ years of Experience in ETL Development and Design using IBM Websphere Datastage8.1 Enterprise and other previous Ascential Datastage versions and 2+ years in Oracle ETL development.
  • Expertise in Ascential Datastage 7.5.2 Server Edition as well.
  • Expertise in Datastage issue resolution, debugging and application performance tuning.
  • Expertise in Performance tuning of Datastage jobs
  • Expertise in extracting data from various versions of Oracle and Teradata Database using Datastage.
  • Expertise in Oracle SQL, PLSQL coding.
  • Proficient in UNIX korn Shell Scripting.
  • Familiar with PERL scripts.
  • Familiar with BASIC Batch jobs development in Datastage.
  • Familiar with Pentaho ETL Tool (haven’t implemented any projects)
  • Familiar with BTEQ, Fast load, Fast export concepts in Teradata.
  • Expertise in performance tuning by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing table spaces, partitioning schemes in oracle.
  • Experience in creating project design documents High Level Design Document, Software Requirement Specification, Mid Level Platform Application design Document(MLPD), Detailed Platform Application Design Document (DPAD).
  • Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
  • Resolving data issues, complete unit testing and complete system documentation for ETL processes
  • Involved in development of Test cases, executing the Unit/UAT Test cases.
  • Involved extensively in Unit Testing, System Testing and Regression Testing.
  • Experience on Defect tracking tools like HP Quality Center.
  • Involved in daily interactions with the Business to understand their requirements and act in a Business Liaison role.
  • Setting up Defect calls for tracking and closing the defects.
  • Experience in producing project estimation, timeline scheduling, resource forecasting, communicating key milestones to IT management and clients, Task scheduling and status tracking.
  • Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.
  • Experience in leading and mentoring team members on both functional and technical aspects.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
  • Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS:

Operating System: Windows All Versions, IBM AIX Unix

Programming Languages: SQL,PL/SQL, UNIX Shell Scripting

Databases: Oracle9i, 10g,11g, Teradata 13.10

ETL Tools: Datastage 8.1 / 7.5.2, Pentaho 4.4.0

Tools: PL/SQL Developer, Toad

Testing Tools: HP Quality Centre 11.0

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Datastage Consultant

Technology & Tools Used: IBM Websphere Datastage 8.1 Designer, Director, Administrator, Ascential Datastage 7.5.2 Server, Oracle 9i/ 10g/11g, Teradata 13.10, Solaris UNIX, TOAD, PLSQL Developer

Responsibilities:

  • Design and Development of ETL jobs using Datastage 8.1 Enterprise Edition and Server Edition as well.
  • Preparing Software Requirement Specification (SRS), Code review document, Test Case Specification and Deployment plan Documents
  • Done, Full project design for FedEx Tax Services system, which includes preparing Software Requirement Specification document, interacting with source teams and preparing mapping documents, Datastage Coding, Unit Testing, support during system testing, preparing deployment plan, supporting business objects reporting team for their testing and supporting business during their UAT.
  • Done Development enhancements for the work request received for FedEx ECOM, Mobile print, Online Signs and Graphics, packaging and shipping projects which included extracting data using Datastage from Oracle Database and Enterprise Data Warehouse Teradata Database, transforming them and loading into Oracle database which was used by the Business objects team for their reporting, The work involved in these projects include, Preparing SRS, Identifying source systems and preparing Mapping documents, documenting and presenting reject handling techniques to business, preparing code review document and deployment plan.
  • Created Reject handling shared container for FedEx ECOM project which was used for reporting issues in various source system files received from the upstream systems.
  • Created common jobs in Datastage Server Edition using CRC for Change Data Capture and producing Insert, update (load ready files) and delete files for loading in the target tables.
  • Created SFTP Unix script Datastage jobs to support the HR source system which was upgraded to PeopleSoft 9.1
  • Produced Impact analysis documents, followed by SRS, Code review, Datastage Coding changes and other project documents to support decommissioning of the Central Repository(CR) DB and replacing with Enterprise Database (EDB)
  • Supported business enhancements for Business objects requirements which required code changes in Datastage for work requests like Coupon code applied, Customer Base foundation (CBF), etc
  • Done BASIC code development and job changes for implementing batch jobs for Order analysis project and an ETL Modernization decommissioning work request.
  • Created documentation for a large ETL application which was having no documentation at all previously and facing various issues in production and kept receiving various change request, the documentation has been widely appreciated for its usefulness and the precise information helped both the business and other downstream systems.
  • Other responsibilities include Fixing Production defects, doing system testing and system integration testing for Datastage coding done by other developers
  • Provided various inputs for creating Data warehouse standard Document

Confidential

Datastage Designer / Lead Developer.

Technology & Tools Used: IBM Websphere Datastage 8.1 Designer, Director, Administrator, Oracle 10g, Teradata 13.10, IBM AIX UNIX 5.1, TOAD, PLSQL Developer, Connect Direct File Transfer Tool, IBM Mainframe

Responsibilities:

  • During my tenure in Lloyds as Datastage Designer and Lead developer I have predominantly worked in Datastage modules of the projects related to Financial Data processing, Business Performance Management, Sales Marketing Analysis and Reporting, e - Statements which has extensive usage of Datastage 8.1.
  • Participated in all phases of project cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, Production support and Documentation.
  • Involved in gathering business requirements and providing development and testing estimation, timelines and resource forecasting.
  • Responsible for preparing Mid Level Platform Application Design (MLPD) and Detailed Platform Application Design (DPAD) Documents based on Business Requirement specification document, giving walkthrough to Document review panel members, clients and obtaining sign offs from the CIO and other Subject Matter Experts from the Client Organization before proceeding with the build activity.
  • Involved in preparing the coding standards documentation for Datastage Development.
  • Involved in designing complex Parallel Datastage jobs, sequencers.
  • Involved in working with SAP Ledger downstream systems by sending SAP files and loading processed data to the SAP tables.
  • Extensively used Job Stages like Datasets, Sequential file, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, SCD, Change capture, Copy, External filter, External Source, Pivot, Complex Flat File Stages, etc
  • Used Datastage XML input stage for processing banks hierarchical files
  • Coordinated with UNIX admin and service delivery team in procuring the UNIX environment and to create Datastage UNIX environment file system and directories.
  • Involved in extracting the data from various sources like Flat files, Oracle and Teradata databases.
  • Familiar with BTEQ, Fast load, Fast export concepts in Teradata.
  • Involved in developing Key Data validation and splitting modules using Datastage in Financial Data processing project for various sources files coming from different source systems.
  • Used multiple invocation techniques for running jobs in various instances so as to reduce the time and expediting the processes.
  • Used Datastage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Utilized slowly changing Dimensions for tracking changes to dimensions over time
  • Used Data stage Administrator for defining environment variables and project level settings.
  • Utilized the stages of Job Sequence such as User Variable Activity, Notification Activity, Routine Activity, Terminator Activity, etc.
  • Involved in developing error logging shared containers and extensively used in various Datastage jobs to gather the error logs in a business defined format, which facilitated the business in analyzing the erroneous files and fixing them quickly.
  • Responsible for validating the Datastage jobs, sequencers against the pre-defined ETL design standards.
  • Involved in developing Connect direct jobs for transferring files to the downstream systems and for pulling files from the source systems as well.
  • Involved in Datastage jobs bug fixing and supporting testing team during various stages of testing.
  • Involved in tuning Source extract SQL scripts used in ETL jobs to meet the business SLAs.
  • Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
  • Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment.
  • Developed Ksh shell scripts for automating Datastage jobs and Housekeeping activities.
  • Created Shell Scripts to automatically notify Business Exceptions and Rejects during the Loads and file processing stages.
  • Created Unix Shell Scripts to read the Parameter Files and passing these values to the job during runtime.
  • Experience in preparing and reviewing Functional Test Plans and Master Test Plans for various stages of the testing activities
  • Responsible for preparing various test scenarios and validating the data as per the business rules.
  • Involved in preparing and executing System Testing and System Integration test cases
  • Provided support during User Acceptance Testing by running jobs and providing fixes.
  • Co-ordinate the offshore development, testing and implementations using implementation plans.
  • Responsible for doing the peer reviews, Planning and estimating the project requirements and to report the status to business managers.

Confidential

Datastage Developer/Designer

Technology & Tools Used: IBM Websphere Datastage 8.1 Designer, Director, Administrator, Datastage 7.5.2, Oracle 10g, Teradata V2R6, IBM AIX UNIX 5.1, TOAD, PLSQL Developer.

Responsibilities:

  • Involved in Gathering Business Requirement and producing inputs to MLPD and DPAD.
  • Involved in all phases of project cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, support and Documentation.
  • Responsible for preparing ETL Documentation for the developed processes.
  • Investigation of possible Terrorist/Money laundering transactions happening in the system for the tickets raised by the business
  • Responsible for handling Production Support tickets.
  • Automated SQL queries using UNIX scripts for loading large volume of data during data migration activities in AML Project
  • Involved in tuning many Oracle scripts and other ETL processes used in this project.
  • Responsible for doing the peer reviews, Planning and estimating the project requirements and to report the status to business managers.
  • Created Documentation for the developed jobs where appropriate documents were not available.
  • Provided production support and bug fixing during various stages of the testing
  • Involved in Designing and Developing of Datastage Parallel Jobs, Sequencers and Shared Containers
  • Performance Tuning of Datastage jobs and Oracle SQL queries.
  • Extensively used Job Stages like Datasets, Sequential file, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, SCD, Change capture, Copy, External filter, External Source, Pivot, etc.
  • Used multiple invocation technique for running jobs in multiple instances to speed up the process.
  • Involved in writing oracle PLSQL Stored Procedures, SQL scripts
  • Developed Ksh shell scripts for automating Datastage jobs and Housekeeping activities.
  • Created Shell Scripts to automatically notify Business Exceptions and Rejects during the Loads and file processing stages.
  • Created Unix Shell Scripts to read the Parameter Files and passing these values to the job during runtime.
  • Responsible for preparing Unit test cases and validating the data as per the business rules.
  • Provided support to the testing team during System Testing, System Integration Testing and User Acceptance testing

Confidential

ETL Oracle Developer

Technology & Tools Used: Datastage 7.5.2, Oracle 10g, Teradata, IBM AIX UNIX 5.1, TOAD, PLSQL Developer.

Responsibilities:

  • Understanding Business Requirements
  • Developing Datastage jobs using the MLPD, DPAD and Business Requirement Specification document.
  • Extensively used Job Stages like Datasets, Sequential file, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, Change capture, Copy, External filter, External Source, Pivot, etc.
  • Developing Oracle SQL, PL/SQL queries and DDL’s for the Database creation.
  • Performance tuning of SQL Queries.
  • Developing UNIX scripts for automating Datastage jobs.
  • Extensively used Datastage Designer & Director.
  • Writing and executing test case for unit testing
  • Providing support to QA team during System Testing and System Integration Testing.
  • Coordinating with UNIX Admin and DBA’s for Datastage UNIX environment creation and Database creation
  • Engaged in Production Support tasks.
  • Documenting the changes for future .

Hire Now