We provide IT Staff Augmentation Services!

Etl Tester Resume

FL

EXPERIENCE SUMMARY:

  • 8+ years of diversified experience as a Senior QA Analyst/ETL Tester/ DWH Tester in testing Web Based and GUI based client/server applications using Manual and Automated testing procedures.
  • Experience in designing and developing Test Scenarios & Test cases by analyzing User Requirements, System, Functional and Design specification & Use case documents.
  • Experience in developing Test plans, defining Test Cases, designing Test Strategies, developing and maintaining automated test scripts, analyzing errors and applications.
  • Involved in Complete Software Development Lifecycle (SDLC) from Business Analysis to Design, Development, Testing, Deployment and Documentation.
  • Experience in different verification processes like walkthrough's, check lists, meetings and different validation techniques and SQA processes.
  • Expertise in Agile methodology with Scrum Process for the product development.
  • Expertise in design, implementation, maintenance and execution and result analysis for Functional automation test scripts in HP Quick Test Pro (QTP) and extensive usage of HP Quality Center for test management and defect management.
  • Expertise and experience in performing different kinds of testing like Functional Testing, GUI Testing, Backend Testing, Regression Testing, User Acceptance Testing and Compatibility testing.
  • Well versed with Backend Testing for Database integrity by executing complex SQL queries for validating the data in the backend database tables.
  • Extensively worked on SQL Joins, SQL queries and SQL sub queries in Test Data preparation and validating the Data Integrity.
  • Good experience in ETL Testing. Extensively worked on data extraction, transformation and loading of the data.
  • Worked on validating the ETL mapping rules and verified the SSIS packages and SSRS reports.
  • Experience in testing Web Services using SOAP UI tool.
  • Extensively worked on batch process jobs monitoring and scheduling the jobs using Control - M.
  • Experience in performing the User acceptance testing with end users. Setting up the UAT sessions and preparing the data for the business users and executing the business scenarios and validating the generated results and getting the signoff's from the business
  • Expertise in Defect Tracking, Report generation and requirement tracking through out the test life cycle using HP Quality Center.
  • Experience in reviewing the Requirements for testability, conducting walkthroughs with developers and environment teams and helping them resolving the code issues and batch process issues.
  • Good Communication, Interpersonal skills and strong Team player with proficiency at time management, multitasking, able to meet deadlines and handle changing priorities.

TECHNICAL SKILLS:

Testing Tools: HP QTP, HP Quality Center, Test Director, Rational Clear quest, Load Runner and SOAP UI

ECM/BPM Technologies: IBM FileNet P8 Suite, FileNet- Share Point Integration

Programming Languages: C, C++, Java, XML, Shell Scripts, SQL, PL/SQL.

Web Technologies: JDBC, Servlets, JSP, Flex, VB Script, Java Script, .Net, ASP

Databases and Tools: Oracle, MS SQL Server, TOAD, SQL Navigator and SQL-Developer.

Application Servers: IBM Web Sphere, BEA Web Logic, Apache Tomcat

Operating Systems: UNIX, HP Solaris, Citrix and WINDOWS

Configuration Mgmt tools: VSS and Rational Clear Case

PROFESSIONAL SUMMARY:

Confidential, FL

ETL Tester

Responsibilities:

  • Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.
  • Conducted and involved in meetings and walkthroughs with users, developers and Business Analysts to gather information about business process.
  • Prepared Test Strategy Document, detailed Test Plans and Test Cases which specify testing overview and testing approach depending on the Business and Technical requirements.
  • Created and executed the Test plan, Test Cases, Automation Test Scripts, and Test Steps for all the modules and stored in HP Quality Center.
  • Analyzed the ETL design documents to understand the logic.
  • Worked on the SQL Statements for Data patches to resolve the data inconsistencies and to maintain Data integrity.
  • Involved in testing Control-M/Batch Jobs. Extensively worked on executing the batch Jobs, Validating the generated files and modifying the schedules of the jobs etc.
  • Extensively worked on ETL Testing. Performed the Data Migration Testing by validating the SSIS packages after data Importing, Data Cleansing, and Data Parsing. Executed the SSIS packages Control M jobs and validated the generated Target data files.
  • Verified the SSRS reports to check the data integrity and validate the data flow from source tables to the destination database.
  • Implemented mappings using SSIS for Extracting, Transforming and Loading (ETL) data into various layers of the data warehouse.
  • Tuned data warehouse load process and report run times using various performance tuning tools and techniques
  • Involved in the test enhancements, issues tracking and issues resolution fixes in the production environment.
  • Took part in the creation of QA metrics and Graphs to help the top management to keep update with the QA Team progress.
  • Mainframe: Access CICS screens to validate the internal system (CIP) using IBM 3270 terminals.
  • Proficient in performing of Functional Testing, Regression Testing, System Testing, Sanity Testing, Database Testing/Back-end testing, UI Testing and User Acceptance Testing.
  • Performed Database testing by executing SQL queries/Procedures using SQL Navigator interface.
  • Prepared the SQL Queries to retrieve the data to perform data transformation and to verify data flow.
  • Extensively worked on SQL Joins, SQL queries and sub queries for data validation and data setup. Worked on preparing and maintaining the reusable SQL Statements and executed them.
  • Design and development of automation test scripts by VB Scripts to the identified Regression Test Cases in HP Quick Test Pro (QTP) tool and executed the scripts in Regression phase.
  • Extensively involved in testing internal and external service communication modules (CMS, RRDonnelley, ACS, OPD, CIP and AUT).
  • As part of User acceptance testing I was involved in setting up the UAT sessions and preparing the data for the business users and executing the business scenarios and validating the generated results and getting the signoff's from the business
  • Actively participated in daily defect calls to resolve the code, batch jobs issues and perform the root cause analysis in efficient and timely manner.
  • Worked on generating the daily status report, providing the testing updates, issues, concerns to the management and the development team.

Environment: HP Quality Center 11, HP Quick Test Professional 11, HP ScreenRecorder, Oracle 10g, SQL Navigator 6.1, Java, J2EE, SharePoint, Microsoft Visio, Rational Requisite Professional, Rational Clearcase, Serena Version Manager, Mainframes, Visual SourceSafe 6.0, Windows XP, Windows 2000 Server.

Confidential, Abingdon, VA

ETL Tester

Responsibilities:

  • Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.
  • Prepared Test Strategy Document, detailed Test Plans and Test Cases which specify testing overview and testing approach depending on the Business and Technical requirements.
  • Prepared and provided test status reports to the management on system status, system changes, problems and potential impacts.
  • Involved in the test enhancements, issues tracking and issues resolution fixes in the production environment.
  • Preparing and reviewing the Test cases for all functional Requirements in HP Quality Center.
  • Conducted meetings and walkthroughs with users, developers and Business Analysts to gather information about business process.
  • Have used File net to store and maintain business documents, use cases and project related documents.
  • Utilized process-based test management system Quality Center for organizing test requirement's documents, test plans and test lab.
  • Performed Functional testing on various Flex components including Form containers with validation, File Upload. Data grid, Panel max, minimizes functionality.
  • Performed Database testing by executing SQL queries using SQL Navigator tool.
  • Extensively used SQL, PL/SQL to do Database testing, Migration Testing and validating the front-end values with back end of application.
  • Involved in Web Services testing during a part of Interface / E2E Testing to verify data flow from one Application to another Application.
  • Prepared Functional, scope and ETL mapping documents for COT Data mart.
  • Performed database testing, Suggested performance tuning techniques for ETL.
  • Performed automation testing on the application using QTP 9.5 (Quick Test Pro). Created test scripts for the functional interface of modules using VB Script on QTP
  • Assign to ETL Developers using PVCS Defect Tracking tool
  • Tested the reports execution, which are generated from UNIX Shell scripts and verified the Daily and Monthly Billing feeds during Cron jobs execution in UNIX boxes.
  • Worked with developers by updating the defects and resolving them and tracking the status.
  • Expertise in Defect Tracking, Report generation and requirement tracking throughout the test life cycle using HP Quality Center.
  • Involved in Production Planning and Implementation check list meetings / reviews.

Environment: Quick Test Pro 9.5, HP Quality Center, SSIS, SSRS, JAVA, J2EE, XML, Oracle10g, Flex 3.4 Sdk, Flash Player 10, UNIX, Web Logic Server, Kofax, SQL Developer, Apache Tomcat Server and Windows XP Professional.

Confidential, PA

QA Analyst/ ETL Tester

Responsibilities:

  • Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis
  • Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data and Traceability Matrix according to business requirements
  • Used MS SharePoint to Store Application Documentation available for cross functional Teams
  • Used Quality Center to Log and report Bugs to the Developers, and Coordinate with Developer to Resolve the Bugs. Maintained the Traceability Matrix for Manual Testing
  • Performed manual testing as per requirement including negative & positive testing
  • Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing, negative testing, system testing and Smoke testing of the Application.
  • Participate in Production Checkout for all Releases
  • Created different release in Release module Mapped Requirement with test case using Quality Center
  • Executed SQL queries to validate the Data tables, which hold the customer information using TOAD Tool.
  • Performed Regression testing after bugs have been fixed to validate product fixes
  • Documented the bug report and categorized them based on severity
  • Web service: Validated Web service modules using Soap UI tool (Preparing web service request XML and added authentication information in Soap Header).
  • Participated in weekly meetings, where test status and defects were discussed, wrote enhancement and modification requests
  • Played a lead role by assisting the manager in assigning work load, creating test schedules and assisting testers.

Environment: Quality Center 9.2, SQL Assistance, MS SharePoint, MS office, JIRA

Confidential, NJ

QA Analyst/ DWH Tester

Responsibilites:

  • Responsible for gathering requirements from business users regarding the data and business processes and made proper documentation.
  • Participated in all phases of Software development and Software testing life cycle.
  • Involved in designing and developing test plans, test cases, test scenarios and test matrices corresponding to business rules and execution of Test Strategy and Test cases.
  • Extensively worked on Test Cases execution, debugging, enhancements and maintenance of the software application.
  • Involved in Integration Testing, Functional Testing, System Testing application Testing, Regression testing as part of the testing effort.
  • Extensively worked on automating the Web Application using Quick Test Professional.
  • Involved in Back End testing for SQL Server as a part of Parallel Test and written SQL queries and PL/SQL procedures, functions and Triggers for data extraction and data validation.
  • Used SQL Server Query analyzer to execute the SQL queries, stored procedures to validate the data in the database.
  • Extensively performed Manual Testing process to ensure the quality of the software and maintain the standards. Responsible for creating varied test data to extensively test functionality.
  • Integrating the Test cases and Test Scripts with QC and executing the same from Test Lab from Quality Center.
  • Worked on preparing the XML for the SoapUI and processed them through Web services to validate the web application.
  • Extensively worked in UNIX environment in executing the Batch Jobs and Shell Scripts.
  • Responsible for test result documentation and defect management Using Quality Center (defect logging, defect tracking, defect triaging, status updating and defect reports and metrics) and assigning the defects to the development team.
  • Developed Modular Diagrams and Flowcharts and use cases using Microsoft Visio that were helpful for new members of the team.
  • Scheduling and allocating work amongst the team members, ensuring deliverables in time.
  • Other duties included, mentoring new QA members, assisting documentation team to understand functionality of the system, coordinating efforts with the development team and reporting status to QA Project managers.

Environment: Quality Center 9.2, C++, C#, Java, HP Quick Test Professional, Serena Team Track, Serena Version Manager, Webservices, XML, SQL Server 2005 Microsoft Visio, MS Visual SourceSafe 6.0, Windows XP, Windows 2000 Server.

Confidential, Toronto

QA Analyst/ ETL Tester

Responsibilities:

  • Analyzed the requirements and developed detailed Test Plans, Test Cases for System Testing.
  • Prepared detailed Test Plans, test cases, test input data, test procedures, etc.
  • Logged the defects with proper severities in QC.
  • Performed manual testing for the functional, security and navigational testing.
  • Execute SQL queries to ensure data integrity and to verify accurate transaction information from the database.
  • Performed Functional Testing, Data Base testing, security testing, GUI Testing, Regression Testing and Integration Testing.
  • Performed Business functionality testing which involved the testing of all core functions of the application
  • Documented and reported the progress to the management on an ongoing basis and updated the requirement and defect status as per the current status of the testing project.

Environment: QC, SQL Server Windows XP, MS Excel.

Hire Now