We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

SUMMARY:

  • Around 8 years of IT experience in the area of Extraction Transformation and loading(ETL) /Data warehouse/Functional testing in different domains like Telecom, Banking and Finance Solutions, Retail and Media Research
  • Performed Back End Testing by executing SQL queries and performed data validation
  • Great experience in managing projects in Agile/Scrum and waterfall models
  • Experience in Data - driven testing, Cross browser testing, Parallel and Sequential testing, Database testing, Web Application testing using Selenium Webdriver
  • Areas of expertise are Effort estimation, Requirement Analysis, Test Planning, Requirement Traceability Matrix (RTM), Test Execution, Defect Tracking, Status Reporting,, Documentation, Creating User Manual for ETL and web based applications.
  • Extensive experience in GUI, Regression, Functional, Integration, System, End-to-End UAT, Sanity Testing
  • Extensive knowledge of SDLC (Software Development Life Cycle) and STLC methodologies.
  • Preparation of Defect Metrics and Productivity Metrics for the team, worked as back end tester worked in creating manual test cases in Quality Center/ALM
  • Well versed with Exploratory Testing, Mobile testing, Database Testing SQL, Localization Testing
  • Extensively used SoapUI and Postman for API testing and have good Understanding of Web Services (REST and SOAP)
  • Performed User Acceptance Testing (UAT) manually
  • Expertise in Test Management using the HPALM(Quality Center) and JIRA for requirements, Test Cases and Defect tracking
  • Participated in design walkthroughs and verified QC Test Scripts and results.
  • Excellent analytical, problem solving, presentation, and interpersonal skills.
  • Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment

TECHNICAL SKILLS:

Testing: ETL, Selenium Web Driver, Client Server, Data Warehouse, Mobile, Functional, System, HP ALM, Jira, Bugzilla

Operating Systems: Windows XP/7, UNIX

Languages: Java, SQL, C, C++

Markup Languages: XML, UML, HTML, CSS

Databases: Oracle 9i/ Oracle 10g, DB2(Tools used TOAD, SQL Developer),Netezza

Tools: HP Quality Center 10.0,Rally, JIRA, ALM, Fitnesse(Semi-Automated Tool), Mastercraft 5.0 / Mastercraft 7

Reporting Tools: Jasper Ireports 3.2

Designing Tools: Rational Rose 3.0

Middle ware Languages: CICS

PROFESSIONAL EXPERIENCE:

Confidential

ETL QA Tester

Responsibilities:

  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Application lifecycle management(ALM)
  • Used Oracle Data Integrator as an ETL Tool for extraction, transformation and loading(ETL) of data into the Enterprise Data Ware House (EDW).
  • Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables
  • Performed testing of Micro strategy Reports by running the SQL Queries on the database by reviewing the report requirement documentation.
  • Performed various types of testing including Sanity Testing, Smoke Testing, Functionality Testing System Testing, Positive and Negative Testing, Security Testing, Cross-Browser Testing, Integration, Regression and End-To-End Testing (E2E) using Selenium WebDriver, TestNG and Java and monitored the behavior of the applications during different phases of testing using testing methodologies
  • Used Selenium WebDriver API with TestNG to automate tests in parallel and priorities of the testcases are set using the TestNG framework
  • Logged the defects using HP Application Lifecycle Management(ALM) and assigned them to corresponding developers.
  • Performed CRUD operation and verification ACID Properties with SQL.

Confidential

Senior QA Tester

Responsibilities:

  • Analyzed requirement documentation, functional specification, design documentation and translated the functional requirements into Test cases.
  • Developed Test Plan, Test cases, test scripts, Complete the Peer review process, executes test cases execution records(TERs) record test results and attached test artifacts with applicable screen shorts in the RQM.
  • Extensively used IBM Rational Quality Manager ( RQM )
  • Followed Agile Methodology to emphasize on real time communication over written documentation and to minimize risk by implementing software test effort in short time sprints or iterations.
  • Logged into the defects using KISAM and linked the defect with RQM assigned them to corresponding developers.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Reported outstanding bugs, followed up bug fixes, conducted review of existing test scenarios and assessed the need for their enhancement.

Confidential

Senior QA Tester

Responsibilities:

  • Developed detailed Test strategy, Test plan, Test cases and Test procedures using ALM for Functional and Regression Testing.
  • Worked with Business users and Assisted UAT & Development teams to mock up data to meet test scenarios.
  • Performed Semi-automated data warehouse testing using fitnesse tool & SQL to ensure data integrity and accuracy with respect to evolving requirements raising defects for any discrepancies in functionality.
  • Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
  • Writing shell scripts in UNIX to check the data integrity during the data transfer.
  • Performed database validation using SQL queries which included complex joints in the UDB tables
  • Generated reports from Microstrategy to view the required data for testing.
  • Logged the errors, reported defects, determined repair priorities and tracked the defects using HP Quality Center.

Confidential

ETL QA Tester

Responsibilities:

  • Created Test Scripts, Test Cases and Test Data in accordance with Software requirement specifications.
  • Performed Database testing by writing and executing SQL queries by using SQL & TOAD to validate that data is being populated in an appropriate table and manually comparing the results with front-end values.
  • Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from other technical teams.
  • Developed test scripts based on business requirements and processes, in line with defined workflows and use cases.
  • Responsible for DATA validation on data marts by using SQL queries.
  • Responsible for creating manual test scripts to include Functional Test, Regression Test, Compression test, UAT, Data Migration Test and Study Configuration Test.
  • Involved with ETL test data creation/Identified for all the ETL mapping rules.
  • Validated the count and data Scenarios through Data Validation Tool.
  • Logged the errors, reported defects, determined repair priorities and tracked the defects using HP ALM.
  • Worked on uploading all the Test cases to the HP ALM for the current and prior releases.

Confidential

ETL QA Tester

Responsibilities:

  • Responsible for SDLC which includes design, document, planning, development, deployment & End to End testing.
  • Developed Test Plans based on Test Strategy. Created and executed Test Cases based on Test Strategy and Test Plans using ETL Mapping document.
  • Walk through of the Test Plan and Test Cases with Business users and Project Team to finalize the Testing approach.
  • Scheduled Control-M jobs for Data Migration across various environments.
  • Used complex SQL Queries in extracting data from Data Warehouse and Data Marts.
  • Maintained test cases and results in HP ALM. Tracked defects in IBM Rational Clear Quest(CQ). Performed Root Cause & GAP analysis to fix the defects found during testing.
  • Extracted Data from MDH, flat files, DB2 and other platforms using Oracle Data Integrator(ODI) to the target database.
  • Identified various Business and Data Test Scenarios based on Source to Target Mapping and assisted in the preparation of extensive set of validation test case to verify the data.
  • Worked with Business users and Assisted UAT & Development teams to mock up data to meet test scenarios.

Confidential

Application Developer /Tester

Responsibilities:

  • Involved in Business requirements, IT Design documents and prepared Test Plans for all assigned project releases.
  • Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
  • Understanding requirement and design documents
  • Documented test cases and performed peer reviews on the team mate’s work
  • Involved in Test data identification and gathering
  • Execution of manual test cases
  • Prepared Automation Test Design documents
  • Design and develop test automation scripts. Execute the automation test scripts and consolidate the test results
  • Automated the process of preparation of Input XML with valid test data and validation of response XML for various order types
  • Identified, analyzed, documented defects and closing of defects after retest
  • Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.
  • Defects were tracked, reviewed, analyzed using Test Director.
  • Ensure that all the test cases are updated in the Test Director along with Master test plan.

Hire Now