We provide IT Staff Augmentation Services!

Sr. Etl Test Engineer Resume

Windsor Mill, MD

SUMMARY:

  • Over 10 Years of Software testing experience working in agile environment and good understanding of software development life cycle (SDLC, STLC) and agile model.
  • Experience with different types of testing techniques and strategies i.e. black box testing, functional, system, regression, integration testing.
  • Extensive experience in ETL (Ab Initio), Informatica, Initiate and web testing (.Net technology, HTML, C++ and Drupal).
  • Experience being part of Center of Excellence for Data Validation testing with HP.
  • Expertise with back - end testing and data validation.
  • Experience working in Onsite offshore model.
  • Experience working on databases: SQL, Teradata, DB2 and Oracle.
  • Experience in requirement gathering/ analysis and creating system requirement specifications documents (SRS).
  • Experience in designing test plan, creating test cases, executing test sets, and development in ASP.NET.
  • Microsoft certified application developer
  • Experience working on .Net technology, HTML, C++ and Drupal.
  • Tested web application in waterfall and agile development processes.
  • Estimated testing efforts with business analysts and offshore QA Testers.
  • Good in team interaction and team management.
  • Strong interpersonal and excellent communication skills.

TECHNICAL SKILLS:

Languages: C++, C#, .NET, ASP.NET, JavaScript

User Interface: HTML, CSS

Technologies: Microsoft Technologies .NET 1.1/2.0, Drupal

Test Automation Tool: HP ALM, Web EME,SOAP UI, Apache JMeter

ETL Tool: Ab: Initio, Informatica

Bug Tracking Tools: Bugzilla, JIRA

Software: Visual Studio, Rational Rose, Microsoft Office, Eclipse

Environment: Windows (XP, Vista, Windows 7), Unix

Databases: SQL Server 2005, Oracle 10g,Teradata,DB2

FTP: WinSCP, PUTTY

Version Control: SVN

Web/ Application Server: Apache Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, Windsor Mill, MD

Sr. ETL Test Engineer

Responsibilities:

  • Planning and execution of test integration activities across multiple platforms/application.
  • Providing /mentoring technical guidance to team members.
  • Creating and implementing process, procedures, tools and templates related to software quality assurance.
  • Performing ETL execution using tools such as Informatica and system testing the functionality.
  • Developing ETL logic using Informatica 9.6 /10 mapping and workflows and monitored jobs using Informatica monitor
  • Created ETL processes using Expression, Aggregator, Lookup, and Joiner Transformations.
  • Perform Performance tuning of ETL processes.
  • Provide LOE estimations to meet project deadlines.
  • Creating quality assurance strategy, test plans and test beds to address end to end systems integration needs.
  • Test data preparation based on ETL mapping logic as per system requirement document.
  • Executing ETL workflow to load data into MDM
  • Debug Informatica mappings to do root cause analysis
  • Developing and performance tuning of complex SQL scripts/Stored Procedures to verify and validate data from source to target in DB2 environment.
  • Create complex shell scripts to validate data and automate test scenarios.
  • Preparing Requirement Trace-ability Matrix (RTM).
  • Working on HP Application life cycle management database to Customize ALM reports.
  • Executing test cases based on system requirements and business requirements.
  • Proposing solutions to address software quality assurance standards and best practices.
  • Execute validation scenarios to verify the ETL transformations.
  • Reporting and tracking defects using JIRA.
  • Reviewing the defects, test case and test plan documents with the clients.
  • Closely work with developer to prioritize the issues to resolve and test.
  • Performing Data services testing using SOAP UI.
  • Performing XML Schema validation against XSD, and data validation.
  • Validate extract files using Mainframes.
  • Developed SQL, VB, shell scripts to automate data validation using JMeter tool for Web Services and database.
  • Parameterized SQL scripts using JMeter for data validation.
  • Automate performance testing via JMeter for web services.
  • Perform restful web services testing.
  • Submit JCL jobs to perform reorg and run stats on Mainframes.
  • Identifying gaps within MDM in all areas (development, testing, data Analytics etc.) and proposing to the client to implement the changes needed.
  • Performing system testing, smoke testing, regression testing and performance testing for the given requirements.
  • Worked in Agile methodology and participated in spring planning and backlog grooming sessions to provide story points and prioritize the tasks.
  • Conducting Scrum meeting and updating status on JIRA Board.

Environment: Windows XP/ UNIX/LINUX JIRA, HP- Application life cycle management (ALM), Informatica 9.6/10, IBM Initiate, Apache JMeter, SOAP UI,IBM DB2 v4.1.1, tortoise SVN

Confidential - McLean, VA

ETL Tester

Responsibilities:

  • Gathering requirements from clients.
  • Provide LOE estimations to meet project deadlines.
  • Create and Review test cases with Tech lead and clients.
  • Developing and reviewing test scripts in DB2 including CLP scripting for multiple database validation.
  • Mock test data based on ETL mapping logics as per system requirement document.
  • Developing and performance tuning of complex SQL scripts/Stored Procedures to verify and validate data from source to target in DB2 environment.
  • Automated data validation using SQL script via QTP.
  • Executing data stage sequences to load data into MDM.
  • Debug parallel jobs to do root cause analysis.
  • Create complex shell scripts to validate data and automate test scenarios.
  • Preparing Requirement Traceability Matrix (RTM).
  • Create and execute test cases based on system requirements and business requirements.
  • Perform manual testing on web-based application.
  • Performing system testing, smoke testing, regression testing and performance testing for the given requirements.
  • Execute validation scenarios to verify the ETL transformations.
  • Reporting and tracking defects using QC tool.
  • Maintaining test repository using Quality Center tool.
  • Reviewing the defects, test case and test plan documents with the clients.
  • Closely work with developer to prioritize the issues to resolve and test.
  • Worked as QC Admin and developed SQL and VB scripts to fetch defect report, Test Case summary and Test result reports from HP ALM.

Environment: DB2, Windows XP/ UNIX, Doors, Quality Center 10.0, WINSCP

Confidential - Richmond. VA

Associate Data Warehouse Test Analyst

Responsibilities:

  • Create and Review Business Assurance Strategy and test cases with Tech lead and clients.
  • Managing onsite offshore delivery.
  • Mock test data based on ETL mapping logics as per source to target mapping document
  • Preparing the SQL scripts to verify and validating data from source to target in Teradata environment.
  • Create Test plan with respect to the requirements
  • Preparing Requirement traceability matrix (RTM)
  • Create and execute test cases for staging, distribution and load ready jobs based on the requirements on QC.
  • Testing Ab Initio graphs in UNIX environment.
  • Performing system testing, smoke testing for the given requirements in Ab Initio.
  • Execute validation scenarios to verify the ETL transformations.
  • Reporting and tracking defects using QC tool
  • Maintaining test repository using Quality Center tool.
  • Providing training to offshore testing team
  • Involved in sprint planning and backlog grooming sessions.

Environment: Teradata 13.0, Windows XP/ UNIX/ Linux and SSH Secure Shell, Ab Initio, Web EME, Quality Center 10.0

Confidential - Charlotte, NC

Software tester

Responsibilities:

  • Performed system and integration testing for Model View Controller pattern.
  • Test presentation layer (UI) developed using, Java Script & HTML
  • Performing system testing and integration testing
  • Performing QA checks biased on requirements
  • Create Test plan based on requirements
  • Create and execute test cases for JAVA based web application
  • Defect tracking and reporting
  • Creating requirement traceability matrix (RTM)

Environment: JAVA, SQL Server 2005, Eclipse, Java, Windows XP, SSRS, Eclipse, Quality Center 9.2

Confidential - Charlotte, NC

Developer/Tester

Responsibilities:

  • Requirement gathering and analysis
  • Develop websites in Drupal technology
  • Analyzed the requirements and created test plan and test cases
  • Create and execute test cases for web-based application
  • Performing system testing and integration testing
  • Performing QA checks biased on university standards by executing scripts
  • Review test cases and scripts for consistency to ensure all aspects of the application
  • Used Bugzilla for bug tracking

Environment: Drupal, SQL, Windows XP.

Confidential

Software tester/ developer

Responsibilities:

  • Worked as Test lead and involved in requirement gathering
  • Assisted project lead to create test plan.
  • Assisted team in setting up the test environment
  • Prepared Risk Assurance strategy document
  • Designed test cases and use case scenarios for the testing phase
  • Performed quality analysis based on various company standards and practices.
  • Performed System testing on web-based application Developed in .NET
  • Used various testing techniques to provide accurate results
  • Performing data validation check in target tables (SQL)
  • Perform regression and negative testing methodologies
  • Created logical design and table structures in SQL Server
  • Designed 3-tier architecture using ASP.Net, C#.Net
  • Developed presentation layer using HTML and CSS
  • Reporting and tracking defects using QC tool
  • Maintaining test repository using Quality Center tool.

Environment: C#.Net, MS SQL, Windows XP Professional, SQL Server 2005, Quality Center 9.0

Confidential

Software Developer & Tester

Responsibilities:

  • Requirement gathering and analysis.
  • Setting up QA environment.
  • QA checks based on requirements.
  • Create Test plan based on requirements
  • Create and execute test cases for .Net based web and windows-based application on QC
  • Performing system testing and integration testing.
  • Defect tracking and reporting using QC tool
  • Closely worked with developers and business analyst for bug reviews
  • Providing Production support in QA environment
  • Performing data validation check in target tables (SQL)
  • Providing technical support for bug fixing and maintenance in SMS module
  • Enhancements Analysis of the specifications provided by the clients for SMS Module

Environment: C#, Database: SQL server 2005, Rational Rose, Quality Center 8.0, Windows XP.

Hire Now