We provide IT Staff Augmentation Services!

Test Lead Resume

SUMMARY:

  • (9+) Years of IT experience in QA (Requirement Analysis, Design, ETL Testing, Hadoop, Quality Center (QC), Functional Testing and Web Services Testing using SOAP UI) for different sectors like Telecommunication and Financial.
  • (2) Years of experience in testing big data applications and working in Hadoop hdfs, hbase, hive and pig.
  • Worked on ETL Testing, Functional and Report Testing for Telecom and banking domains.
  • Strong experience using Defect Management Tools like Quality Center (ALM), Clear Quest for Requirement Management, Test Planning, Test Case development, Test Case execution and Defect Tracking.
  • Strong knowledge of Data Warehouse concepts such as star schema, snow flake schema, dimensions, facts and slowly changing dimensions types (SCD).
  • Experienced in Preparing Defect RCA (Root Cause Analysis) and Defect Prevention Reports
  • (8+) Years of strong Data warehouse ETL testing experience using Datastage,Tidal scheduler, Control - M and Informatica Power center
  • Wide range of database experience, using Oracle, MS SQL Server and Teradata.
  • Proficient in writing and debugging SQL queries using DML commands for Back-end testing
  • Proficient in working with UNIX shell scripts using PUTTY Environment
  • Well versed with different phases of testing like Unit Testing, Integration Testing, System
  • Strong experience in all the phases of Software Development Life Cycle (SDLC) methodologies such as waterfall and Agile (Scrum)
  • Experience in providing user training and help the business users to understand QA/UAT process.
  • Proficient in creation and execution of Test Plans, Test Scripts and Test Cases using both Manual and Automated testing techniques
  • Ability to understand and translate Business Requirements and to operate independently or in a team environment. Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking and System Integration.
  • Worked very closely with Customers and End users in gathering requirements and assisting with any training needs and help clarify process related questions

TECHNICAL SKILLS

Software Testing: Manual, ETL Testing

Big data Technologies: Horton works HDP 2.3, Cloud era CDH4, Amazon EC2, Hadoop HDFSMap Reduce, PIG, hive, Hbase, Oozie, Sqoop, Solr and Tez.

Tools: SQL Developer, SOAP UI, Quality Center (ALM), Clear

Quest, Tidal Scheduler, PRISM:

ETL Tools: Informatica 8.1, Data stage Defect Tracking Tools HP QC, JIRA, Bugzilla.

Operating Systems: Windows- 2000, XP and 7, UNIX

Microsoft Office: Word, PPT, Excel and Visio

Web services: SOAPUI

Databases: Oracle 11g, MS SQL Server, Teradata

PROFESSIONAL EXPERIENCE

Confidential

Test Lead

Responsibilities:

  • Onsite Test Lead coordinating the offshore team for ETL Testing
  • Involved in handling the project from PI planning till the client demos in Kanban and Agile systems.
  • Created test plan and scripts based on the Functional specification and technical assessment documents.
  • Validation of ETL mappings/builds as per the business requirement against data in the tables.
  • Validate, Transform & Load (ETL) Specifications (Source to target and Business rules)
  • Verify Functional Data Warehouse (DW) analysis & design documents.
  • Developed Test Plans, Test Cases.
  • Managed and conducted System testing, Integration testing, Regression, and Database testing.
  • Raise the defect in-case of the business rule violation with the data and assign to the concerned stakeholders.
  • Tracked the defects using the Quality Center
  • Prepared test exit reports with details of executed, passed and failed test cases to the senior management and participated in demos to clients.
  • Participated in regular project status meetings related to testing and process improvement.

Test Lead

Confidential, Washington,USA

Responsibilities:

  • Onsite Test Lead coordinating the offshore team for ETL Testing
  • Involved in handling the project from creating a test id for a project till submission of exit report.
  • Created test scripts based on the Functional specification
  • Validation of ETL mappings/builds as per the business requirement against data in the tables.
  • Validate, Transform & Load (ETL) Specifications (Source to target and Business rules)
  • Verify Functional Data Warehouse (DW) analysis & design documents.
  • Developed Test Plans, Test Cases.
  • Managed and conducted System testing, Integration testing, Regression, and Database testing.
  • Raise the defect in-case of the business rule violation with the data and assign to the concerned stakeholders.
  • Tracked the defects using the Quality Center
  • Prepared test exit reports with details of executed, passed and failed test cases to the senior management.
  • Participated in regular project status meetings related to testing and process improvement.
  • Compare the flat file with the database content as per the Business requirement.
  • Tested the reports built on top of the tables in Teradata using the reporting tool Business Objects.

Confidential

ETL Tester

Responsibilities:

  • Worked as a ETL tester and business analyst for the Confidential products team.
  • Worked Throughout the project in various iterations/Sprints - conducted.
  • Developed Test Plans, test scripts and executed test scripts for FCDR DW Project.
  • Participated in regular project status meetings and QA status meetings.
  • Involved in identifying the product requirements from the Cobol/assembler/pli programs
  • Prepared the BRD with Confidential product requirements and presented it to the client in two phases: FIOS and Copper
  • Extensively used and developed SQL scripts/queries in backend testing of Databases.
  • Responsible for performing the smoke test before code deployment.
  • Responsible for doing Regression testing
  • Creating test cases for ETL mappings and design documents for production support.
  • Prepared daily status reports with details of executed, passed/ failed test cases and defect status.

Confidential

ETL Tester

Responsibilities:

  • Onsite lead in Sweden onsite managing the offshore team.
  • Involved in the requirement gathering sessions.
  • Created Test Plan, Test cases for new features, Created progression and Regression Plans for each release.
  • Maintained detail test plan and test cases by analyzing business logic and user requirements for manual testing including browser/Platform combination.
  • Executed Test cases and raised defects using Quality Center.
  • Participated and coordinated the manual testing activities.
  • Ensure quality deliverable On-site and Offshore coordination.

Confidential

ETL Tester

Responsibilities:

  • Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
  • Worked Throughout the project in various iterations/Sprints - conducted system testing, integration testing and functional testing.
  • Extensively interacted with developers, business& management teams to understand the Intelligent Home and Care Mart projects business requirements and ETL design document specifications.
  • Participated in regular project status meetings and QA status meetings.
  • Extensively used and developed SQL scripts/queries in backend testing of Databases.
  • Defects identified in testing environment were communicated to the developers using Quality Center.
  • Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
  • Created test cases for ETL mappings and design documents for production support
  • Effectively communicated testing activities and findings in oral and written formats
  • Worked with ETL groups and Acquisition team and business analyst for understanding mappings for dimensions and facts
  • Prepared daily status reports with details of executed, passed/failed test cases and defect status.

Confidential

Senior QA ETL/WebService Tester

Responsibilities:

  • Participating in Requirement Reviews
  • Analyzing Project Requirements with SE
  • Suggesting Requirement changes if it’s ambiguous with System characteristics
  • Identifying the key scenarios for testing
  • Designing positive and negative test cases based on the identified scenarios
  • Uploading all the Test deliverables in the repository PRISM
  • Preparing Test Data and Dependency Management Agreements
  • Executing test cases using Unix, SQL and Shell script
  • Supporting different phases of testing IST, JST, and UAT as system tester
  • Updating Run Rate Tool with testing progress
  • Logging the no. of test cases passed/failed/in progress in RR tool
  • Logging the defects identified during testing in Rational Clear Quest and Quality Centre.
  • Updating the Defect status and working towards the closure of defects with developer

Hire Now