We provide IT Staff Augmentation Services!

Etl Datastage Developer Resume

Phoenix, AZ

SUMMARY:

  • Solution - oriented IT professional with 15 years of extensive experience in diversified of Software Development Life Cycle (SDLC) in Quality Assurance Process and Methodologies.
  • Over 6 plus years of Proficiency in IBM Infosphere Information Server 11.5, 11.3.1, 8.7, 8.1, (DataStage, QualityStage, Master Data Management, Operations Console) and leadership roles in delivering quality solutions to meet business needs, utilizing a blend of onshore & offshore delivery models.
  • Systematic and detail-oriented with a clear focus on reducing redundancies and increasing efficiencies.
  • Articulate and positive communicator with ability to forge solid relationships with teams and business partners.
  • Excellent experience in testing Client/Server and Web applications in Banking, Financial, Telecom, Insurance, Airlines, Wireless and Manufacturing domains with expertise in Technical Writing procedures.

TECHNICAL SKILLS:

PROGRAMING LANGUAGES: Java, Python, Java Scrip, C++, C#ETL: Data Stage, Informatica

DATABASES: SQL Server, Oracle, DB2

QA TOOLS: Work Soft, Selenium, QTP, UFT, Load Runner, Silk Test, Rational Test Suite, SOAPUI, Quality Center, ALM, Rational Clear Quest, TFS, Jira, Rally

DEVOPS: GitHub, Jenkins, Urban Code Deploy

PROJECT MANAGEMENT: MS Project, Rational Clear Case, Rally, TFS

O/S: UNIX, LINUX, WINDOWS, IOS

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

ETL Datastage Developer

Responsibilities:

  • Develop various parallel jobs utilizing different source files and transform the data using datastage stages (Ex...Aggregator, Copy, Filter, Funnel, Join, Lookup, Marge, Modify, Pivot stage, Remove Duplicate, Sort, Surrogate Key Generator, Switch, Transformer)
  • Creating sequence jobs with complex transformation Logic as per the requirements
  • Creating complex XML structure related to SAP Postings for Expense reimbursement
  • Use Sequencer triggers and stages to control the conditions
  • Schedule Data stage jobs using a third party scheduling tool (Tivoli)
  • Utilizing UNIX scripts for encryption/decryption/archive/cleanup environments using by invoking UNIX shell scripts using Routines stages
  • Modified UNIX shell script to run Job sequencer from the mainframe job
  • Debug the jobs by analyzing the job score in the Director log
  • Develop python scripts to read and write from csv files to database
  • Work with various source databases & files(Teradata, Oracle, Sequential files and Complex Flat files) to read data and transform into target tables using various transformation/business rules
  • Extensively working on Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses
  • Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding
  • Implement multi-node declaration using configuration files (APT Config file) for performance enhancement
  • Experience in scheduling Sequence and parallel jobs using Datastage Director, UNIX scripts and Tivoli scheduling tools
  • Extensively used Ascential DataStage Designer for creating DataStage Jobs and created Shared Containers for reusability
  • Utilize different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost
  • Debug, test and fix the transformation logic applied in the parallel jobs
  • 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
  • Create test data for the testing team and provide guidance & mentor team

Environment: IBM Data Stage 11.5, Python, Tivoli, GitHub, UCD (Urban Code Deploy), DevOps, Rally, Jira, DB2, Oracle 12c, Mainframe, Java, JavaScript, Selenium Web driver/IDE, Eclipse, JMeter, Jira, Data Studio, SQL Developer, Rally, TFS.

Confidential, Hartford, CT

Datastage Developer

Responsibilities:

  • Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software (Quality Stage v8.1, Web Service, Information Analyzer, Profile Stage, WISD of IIS 8.0.1)
  • Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables
  • Prepared Data Mapping Documents and Design the ETL jobs based on the DMD with required Tables in the Dev Environment
  • Designed XML stages for integrating API's to reading XML log files for capturing data stage jobs audit data
  • Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc
  • Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance
  • Created power shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool
  • Extensively followed the concepts of Naming Conventions, Parameterzing the variables from Global Environment to stage level
  • Detailed knowledge in Data Warehousing concepts like Dimensional Modeling, Star Schema, Snowflake Schema and ETL
  • Created process flow diagrams using Microsoft VISIO
  • 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
  • Used extensively Aggregator/Sort/Merge/FTP/transformer stages for data processing
  • Analyze performance and monitor work with capacity planning
  • Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed
  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis
  • Participated in weekly status meetings
  • Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually
  • Supported global network delivery model working with distributed teams across geographical locations
  • Created Knowledge management documents and maintain in SharePoint

Environment: IBM Web Sphere DataStage, Snowflake, Web Services, Quality Stage, (Designer, Director, Manager), SnapLogic, Microsoft Visio, IBM AIX 4.2/4.1 IBM DB2 Database, SQL Server, Teradata, ORACLE 11G, Query man, Unix, Windows.

Confidential, Houston, TX

Sr Quality Professional

Responsibilities:

  • Created Verification and Validation check list
  • Utilized agile development process
  • Created test scenarios & test case that ensure requirement coverage
  • Organize and manage the testing process
  • Validate store procedures

Environment: TFS, QC, MS SQL Server2008, .Net

Confidential, Denver, CO

Sr Quality Professional

Responsibilities:

  • Created release versions and requirement traceability metrics in QC/ALM
  • Found root cause of the application errors in error logs and provided logs to dev team for DR fixes
  • Worked with Middleware team to install builds in Stand Alone environments
  • Updated application properties in UNIX App Servers & extracted data from UNIX Data Loader Servers
  • Provided additional mentoring on testing approaches and writing test cases on IVR
  • Implemented various processes and procedures to bring together various teams to integrate the efforts
  • Supported UAT & production roll-outs

Environment: Siebel 8, Gensys, IVR/CTI, Clear Quest, Cognos, UNIX, QC/ALM, Jira, Web Services, WebSphere, DB2, Oracle, MS SQL Server 2008.

Confidential, Los Angeles, CA

QA Lead

Responsibilities:

  • Exclusively followed Agile Methodology & Initiated daily touch point
  • Created integration checklist for individual project
  • Created test cases and executed for Siebel (Call Center Application)
  • Coordinated multiple projects simultaneously & assigned work to offshore team
  • Ensured review of QA documentation for accuracy, consistency, and completeness

Environment: Web Services, Siebel 7, SOA Test, SOAPUI, Java, J2EE, QTP, Load Runner, QC 9.2

Confidential, Los Angeles, CA

Sr. System Test Engineer

Responsibilities:

  • Executed the test cases using SOAPUI and web services hosted on a Web Logic server
  • Updated the results in Toro and assigned test cases to testers for execution
  • Installed multiple products using VMware and validated
  • Updated VB.net automation script according to requirement changes

Environment: QTP, Load Runner, Oracle 9i, Toad, Bugzilla, Web Services, SOAPUI, Toro, VMware, Java, J2EE, QC

Confidential, Fairfield, CT

QA Lead

Responsibilities:

  • Developed procedures and standards to create product bulletins and installation/maintenance manuals
  • Created Test Beds & deployed the build and configured the Operating System accordingly
  • Set appropriate load scenarios based on the discussions with developers & customer needs
  • Identified bottleneck of the application based on the test results & suggested the users with possible scenarios/solutions
  • Performed saturation Point Test or Stress Test of the application to identify the breakage point
  • Executed Silk Test scripts and updated according to requirement changes
  • Managed verifications and validations for all production modifications for projects, releases and changes

Environment: VMware, Solaris, UNIX, Java, J2EE, Clear Quest, Load runner 8.0, Silk Test, Clear Case.

Confidential, Burbank, CA

QA Lead

Responsibilities:

  • Identified resource expertise and allocated work accordingly
  • Maintained Quality Center as Site Administrator
  • Involved in ETL Data Warehousing, database testing using Informatica for Workflow process & generated Crystal Reports

Environment: SQL Server, DB2, Web Sphere, QC, ETL/Informatica, Crystal Reports, Load runner 7.8.

Confidential, Lynchburg, VA

Senior Test Engineer

Responsibilities:

  • Performed manual testing and Data integrity/Backend testing by executing SQL statements
  • ETL Data ware house testing & generated reports
  • Responsible for weekly status reports update showing the progress of the testing effort and remaining open issues to be resolved

Environment: Oracle 9i, Solaris, Rational Clear Quest, ETL / Informatica.

Confidential, Fairfield, CT

System Test Engineer

Responsibilities:

  • Deployed Patches and Builds
  • Created requirements and generated traceability matrices to ensure that all the requirements are covered
  • Wrote Test Plans according to Business Specifications, designing and maintaining
  • Written System Test Scripts by referring Use Cases, FD documents and discussing with Business Analysts
  • Built Test scripts for different modules of application to check the performance by using Load runner

Environment: VMware, Solaris, UNIX, Java, Java script, VXML, J2EE, Rational Clear Quest, Load runner

Hire Now