We provide IT Staff Augmentation Services!

Etl/qa/data Testing (automation Testing) Resume

Bloomfield, NJ

SUMMARY:

  • Detail - oriented technology professional with a background in Software ETL/Data/Quality Assurance with Working knowledge of a wide range of development technologies; quick to learn, adjust, and adapt to new environments, processes and techniques; exceptional organizational and planning skills; enjoy new challenges and working in a team environment; exceptional communication, interpersonal and client service skills.
  • 8+ years of experience in QA/ETL Data software testing involved in various roles as QA Analyst. Has attained expertise in working with projects in various domains.
  • Ability of understanding organization/business objectives, driving QA efforts in meeting them.
  • Experienced in developing Automation Scripts, Execution and Analysis of Test Results using Data Driven, Keyword Driven and Hybrid Frameworks in Selenium WebDriver.
  • Expertise in all kinds of testing with focus on ETL testing.
  • Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
  • Experienced in creating Traceability Matrix, Test Coverage Matrix and Defect Density Matrix.
  • Expertise in implementing cross browser and cross platform web testing with SeleniumWebDriver.
  • Experienced in developing Page Object Model Framework using Page Factory in SeleniumWebDriver.
  • Extensive knowledge of developing Data driven and Hybrid framework with SeleniumWebDriver.
  • Experienced in developing Mobile Automation Framework and writing test scripts for Mobile Testing.
  • Good knowledge on Cross browser testing with browsers like Mozilla Firefox, Google Chrome using WebDriver.
  • Experience operating within teams using the Agile SCRUM process.
  • Extensively used SQL Queries to verify the data from the database.
  • Hands on experience on different databases like Oracle, Postgres, SQL Server and MS Access.
  • Experience in Test Cases, Test Scripts, Test Data, Defect Matrices and Bug Reports using Management tools such as Confidential ALM, JIRA and TFS.
  • Expert in Data Testing & System Testing, Functional Testing and involved in User Acceptance testing (UAT), Load Testing, Performance Testing, Regression Testing & Stress Testing.
  • Experienced in data analysis and data testing and worked closely with the development teams to replicate end user issues.
  • Experienced with ETL tools like Informatica, SSIS, Ab Initio
  • Experience in SQL database SQL scripting for good understanding of Data and validate the Database in the server.
  • Worked heavily on testing various ETL process as well as many reports developed used various BI tools.
  • Experience with creating and maintaining testing standards, procedures, test models and metrics.
  • Well acquainted with SDLC, STLC.
  • Proficient in test execution and management of testing defects
  • Good at bug-reporting and bug-tracking using Test Management tools like Quality Center, Bugzilla, VersionOne and JIRA
  • Experience working on different major projects with different roles like functional testing, ETL testing, database testing, automation scripting, environment testing.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Experience in writing test cases/ test scripts for Inbound and Outbound ETL processes and interfaces with other systems and streams.
  • Expertise in preparing Test Strategy, Test plan, Test summary Reports, Test cases and Test scripts for Manual Testing based on user requirement documents and system requirement documents.
  • Working Knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), requirements gathering, Analysis, Design, Development, Implementation, Testing and Deployment.
  • Expertise in Black Box testing including Smoke, Functional, Integration, Regression, System, User acceptance (UAT), Positive and Negative, Security, GUI, Backend, cross-browser and ad-hoc testing.
  • Experience in analyzing, reviewing and understanding of Business/Functional & Testing requirements and writing Test Plan, Test Strategy, Test Scripting, creating Test Scenarios, analyzing results and preparing result summary report.
  • Experienced in working with Defect Management tools like Confidential ALM/Quality Center, Rally & JIRA.
  • Experience in Parallel Execution of Multiple Tests at a time in different environments. Expertise in Grouping of Test Cases, Test Methods and Test Suites for regression and functional testing using the TestNG annotations like Groups, Parameter, Data Provider.
  • Proficiency in testing complex software applications including manual testing.
  • Experienced in using Maven, ANT build tools to manage framework dependency jar files.
  • Experienced in Web Services testing using SOAPUI tool. Validated request and response XML, SOAP and RESTFUL Web service calls.
  • Experience in integrating Selenium WebDriver automation scripts on Continuous Integration tools like Jenkins.
  • Good at defect-reporting and defect-tracking tools like JIRA, Rally, Bugzilla and Quality center.
  • Effective oral and written communication skills with more concentration on details of the project guidelines.
  • Expert in developing test Scripts to implement the Test Cases, Scenarios, Steps, Step Definitions and Features for BDD (Behavior Driven Development), TDD (Test Driven development) and ATDD (Acceptance Test Driven Development) using Cucumber and Selenium
  • Experience with ETL and data migration testing. Writing different SQL queries.
  • Master in developing Test Scenarios, Test Cases, Test Data, Test Reports and documenting in both Manual and Automation Testing.
  • Extensively Experience to Categorizes, documents and manages resolution of software (and/or related data) defects or bugs.
  • Ability to coordinate effectively with development team, business partners, end users and management.

TECHNICAL SKILLS:

Collaboration tools: Microsoft test manager, TFS

Languages: ASP .Net, C# .Net, SQL, PL/SQL, UNIX Scripting

Scripting Languages: JavaScript, XML and Shell Programming

Databases: Oracle 10g/9i/8i/7i, SQL Server

Bug Tracking Tools: Confidential ALM, JIRA, Bugzilla, TFS

Configuration Management: SVN, GitHub

Operating Systems Windows: 2000/NT/XP/Vista, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield, NJ

ETL/QA/Data Testing (Automation Testing)

Responsibilities:

  • Experience working on Agile (Scrum Framework) Methodologies to meet timelines with quality deliverables.
  • Maintained TFS Build Server, source code repository including Microsoft Test Manager server
  • Developed test plans, test scenarios, test cases and test data for each upcoming testing activity.
  • Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
  • Parameterize the test for multiple sets of data testing
  • Configured Selenium WebDriver, Test NG, Maven tool and created selenium automation scripts in java using Test NG prior to agile release.
  • Executing SQL queries for data testing.
  • Expert in writing SQL queries to extract data from database tables to perform Database Testing.
  • Worked on developing the automation scripts using Selenium WebDriver with Junit Frame work.
  • Utilized test management tools Confidential (QC), ALM, JIRA, to perform activities like writing.
  • Created Test Scenarios & Acceptance criteria based on the requirements using Excel speed sheet and upload them into ALM.
  • Using SQL server for backend data testing and validation using SQL Test Plans. Test Cases, developing and maintaining Test Scripts, tracking defects and reporting bugs.
  • Selected the Test Cases to be automated and performed functional testing.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
  • Efficient management of Rally for bug tracking and Confluence for design documents.
  • Analyzed the business and functional requirements and developed Test Plans, high level test scenarios, estimates to facilitate the process of testing.
  • Performed Data testing and analysis as a part of Regression testing for the existing functionalities.
  • Worked with Data testing team (TDSS) and generate reports using pivot tables
  • Logged and Tracked Bugs in ALM tool and closely work with Developers to recreate the bugs
  • Logged Bugs in ALM and linked them to the requirement ID to clearly indicate the functionality where the bug is found.
  • Developed SQL Queries for validation and retrieval of data testing, Strong hands on experience in use of SQL scripts
  • Developed Automation scripts for new enhancements using Selenium WebDriver and Test NG.
  • Selected the Test Cases to be automated and performed functional testing
  • Understand the application business logic with Business Requirements Specification Documents and functionality of application with Functional Requirements Specification Documents.
  • Debugged ETL workflows/jobs and monitored error logs. Responsible for testing Initial and daily loads of ETL workflows.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
  • Validated the test results by writing SQL command to retrieve the data from tables and from the database.
  • Interacted with the onshore and offshore team to resolve defects and functional issues of the application.
  • Performed cross browser functional testing using Selenium Web driver.
  • Involved in preparation and execution of Test Scripts using SQL scripting with the help of inner joins and outer joins
  • Interacted with the onshore and offshore team to resolve defects and functional issues of the application.
  • Involved in preparing the high-level Test Strategy & Plan and developed Test Cases in accordance with the functional specifications.
  • Performed Database testing by writing the Complex SQL queries.
  • Involved in writing and testing test scripts using Selenium WebDriver and Java Object Oriented Programming Language.
  • Reviewed and updated Requirements Traceability Matrices (RTM) that satisfy all required project's test conditions.
  • Involved in coordinating to ensure testing of functional areas is complete, tracked and on-schedule.
  • Diligently executed all test cases, with the results captured and corresponding test metrics released to management.
  • Identified quality issues per documented process and escalated when necessary
  • Performed manual and maintain documentation on different types of Testing like Black Box, Regression, Integration, System and User Acceptance testing (UAT).
  • Tested several packages developed using SSIS.
  • Writing Test Cases in Confidential ALM/QC tool based on Business Requirement Document and Technical and Functional Specifications.
  • Extensively Experience to Categorizes, documents and manages resolution of software (and/or related data) defects or bugs.
  • Performed various testing methodologies like Functional testing, Database testing and Regression testing.
  • Conducted Test Scenarios and Test Cases review to communicate all the test objectives with the team.

Environment : Confidential Quality Center, Selenium Web Driver, SSIS, Test NG, XML, Web Services, Maven, Eclipse, Java Script, Data Driven and Key Word Driven Frameworks, HTML, API.

Confidential, Palo Alto, CA

ETL/Data QA Tester

Responsibilities:

  • Involved in Development and Execution of Test Plans, Test Cases & Test Scripts by reviewing the business requirements document.
  • Executed test cases in Confidential ALM bases on requirements.
  • Using SQL server to for data testing
  • Executing Test Cases, finding and logging defects based on their priorities using Confidential ALM.
  • Performed Regression Testing for the new builds using Selenium WebDriver.
  • Analyzed the business and functional requirements and developed Test Plan.
  • Verified backend data validation using SQL.
  • Worked as QA for performing API launches, white box testing, data testing
  • Worked on developing the Data driven framework using Selenium WebDriver to automate the web application.
  • Performed Positive and Negative data testing and Boundary testing.
  • Heavy data testing via creating projects, test suites, test cases on Ready API by directly fetching data from databases and comparing using assertions.
  • Executed Positive and Negative data testing and Boundary testing.
  • Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.
  • Tested ETL Packages, Scripts from development to QA environment.
  • Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
  • Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
  • Tested Informatica mappings for various ETL data conditions and mapping rules.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
  • Tested the ETL process for both before data validation and after data validation process.
  • Checked the web applications on selenium using python.
  • Created and executed the test scripts with Java, Selenium WebDriver, and TesNG.
  • Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies.
  • Performed complex Data Testing and Back End Database testing.
  • Preparation of various test documents for ETL process in Quality Center.
  • Used of test management and automated test tools
  • Written ETL specifications for all the development tasks, to better evolve the ETL design.
  • Involved in Development meetings for the implementation of ETL and OBIEE
  • Created SSIS packages to transfer XML file data into SQL server database
  • Responsible in executing Selenium test scripts on different browsers and checked for compatibility.
  • Test Management tools used: Quality Center 9.2 & 10.2, ALM 11.0, Team Foundation Server, JIRA, SQL Server Management Studio
  • Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
  • Expert in writing SQL queries to extract data from database tables to perform Database Testing.
  • Performed database testing using SQL queries.
  • Involved in designing the framework to integrate Confidential ALM to cucumber using the newly released version of Confidential ALM
  • Interacted with the onshore and offshore team to resolve defects and functional issues of the application.
  • Performed responsibilities of developing and executing functional test plans and test case
  • Handle responsibilities of developing functional testing plans and performing end to end phases of test execution
  • Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirement.

Environment: Confidential ALM, SQL Server, JIRA, Crystal reports, Java, JIRA, Microsoft Test Manager, Agile methodologies, Microsoft Test Manager.

Confidential, Washington, DC

QA Tester

Responsibilities

  • Involved in Script creation, maintenance and enhancements for Sanity and regression suite.
  • Preparation test cases in TFS, test data, as per test procedure specifications.
  • Prepared the test plan, test estimation and identifying the risk areas.
  • Involved in writing of modification reports for errors identified in testing and communicated with development team via defect tracking system Confidential ALM.
  • Involved in preparation of Test Strategy documents/Test plan.
  • Involved in preparing status reports and Bug reports.
  • Performed Functional Testing, Regression Testing and User Acceptance Testing (UAT).
  • Developed detailed Test Plan, Test Cases, Entry and Exit criteria for the application being tested and ensured that standards for documentation were followed.
  • Assessed & analyzed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test reports.
  • Executed Test cases and performed back end testing to test the database integrity by executing SQL queries and verify data in Crystal reports.
  • Validated the test results by writing SQL command to retrieve the data from tables and from the database.
  • Troubleshoot new releases and production issues. Interacted on a regular basis with web developers and Business Analysts on any Change of Requirements.
  • Tracking, Logging Defects, Reporting Bugs using JIRA.
  • Documented Test cases corresponding to business rules and prepared Test Status Reports.
  • Participated in Release/Sprint planning meetings and attended daily Scrum Meetings.
  • Knowledge of using test management tool such as JIRA.
  • Involved in writing SQL queries to validate expected data with actual report data.
  • Participated in test plan and test cases review meetings.
  • Developed Test Plans, Test cases and Test Scripts in Mercury tools. Coordinating with offshore resources for test execution.

Environment: TFS, JIRA, Microsoft Test Manager, Windows, Linux, Restful Web Services.

Confidential, Washington, DC

QA Automation Tester

Responsibilities:

  • Involved in understanding of functionality and design of different applications based on the Requirement Specification Document.
  • Captured Test Cases and Test Results in Quality Center and documented and prepared the release notes as part of the project deliverables.
  • Wrote test plan and test cases for the company's core platform J2EE based application APIs and services.
  • Investigated Software bugs and Interfaced with developers to resolve technical issues and reporting the bugs to all concerned.
  • Investigated requirements and interfaced with developers to resolve issues and reporting the issues to all concerned. Outstanding issues are documented and managed through Quality Center.
  • Create/Edit XML configuration files and properties files for various frameworks and data for testing web services.
  • Participated and assisted in design of Proof of Concept with QA Lead.
  • Identified test cases to automate and automated them using Selenium WebDriver and TestNG.
  • Wrote test cases scripts using Selenium WebDriver for functional testing and regression testing.
  • Performed Data driven testing using Selenium WebDriver, JUnit and JDBC Connections.
  • Used Selenium Grid, Desired Capabilities, and Remote Web Driver for distributing the execution in different machines, platforms and browsers.
  • Configured Selenium WebDriver, TestNG, Ant tool and created selenium automation scripts in java using JUnit prior to agile release.
  • Used Eclipse IDE for Automation scripts development.
  • Applied Load Testing using JMeter and Involved in implementation of Test Automation Framework build using Selenium WebDriver.
  • Develop automated tests using Selenium, Coded UI, C#.
  • Used Automation Test tool Tosca for future UFT code transfer
  • Used SoapUI with extensive support for testing WSDL / SOAP based services.
  • Performed end-to- end testing to evaluate system testing of the application.
  • Coordinate with end-users to schedule and support User Acceptance Testing (UAT).
  • Configured Selenium Grid for parallel execution of scripts on different machines in different browsers.
  • Participated in technical, status review, and release and production meetings.
  • Performed Integration by adding JMeter scripts to Selenium
  • Worked in Agile process for delivering the outputs on time.
  • Occasionally performed manual testing during critical releases of the project.
  • Prepared Test Summary reports after every round of testing.
  • Tracked requirements documentation in Confluence and Project status in JIRA
  • Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (JUnit, Maven).

Environment: SharePoint, SOAP UI, XML, HTML, Quality Center, SQL Server, UNIX, Windows XP.

Confidential, San Mateo, CA

QA Tester

Responsibilities:

  • Analyzed business requirements and functional documents, created to define the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
  • Extensively worked in Regression testing, Parallel Processing using Selenium WebDriver in TestNG.
  • Performed the build and maven dependencies using Maven build tool.
  • Developed test scripts to identify the web Elements through locators using Firebug and Fire Path Firefox plugins.
  • Performed Parallel and Cross Browser testing using TestNG on different browsers like Internet Explorer, Chrome, Safari and Firefox where multiple tests were run at the same time.
  • Compare and validate the Web Interface with XML output received from external vendor.
  • Used XPath and DOM to work with dynamic and static objects in Selenium.
  • Created test approach and test cases for logging module.
  • Reviewed and analyzed the existing test scripts.
  • Maintained user documentation with Selenium output screenshots for User acceptance testing (UAT)
  • Developed synchronization using implicit and explicit wait conditions.
  • Created automation scripts using Selenium Hybrid and Data-driven development framework.
  • Maintained the Java and selenium test source code and resources in the SVN source control repository tool.
  • Analyzed test results, tracked the defects and generated reports using JIRA.
  • Prepared the data to cover various scenarios and wrote SQL scripts to verify the database updates, inserts and deletion of the records.
  • Maintained continuous test integration and automatic build by using Jenkins and mailed the build outputs to the team members.
  • Performed agile testing, reviewed the stories and participated in Daily Scrum, Iteration Planning and Release Planning meeting.
  • Experience testing with Restful/SOAP Web Services using SOAPUI.
  • Created test scripts using Groovy script to automate web services in SOAP UI for different data sample data.
  • Tested applications in different types of browsers (cross-browser testing) and versions, such as Internet Explorer, Firefox, Google Chrome to simulate production environment.
  • Developed features and test scripts using BDD (Behavior driven development) in Cucumber.
  • Participated QA weekly meetings and various other meetings and discusses enhancement and modification request issues and defects in the application.

Environment: Java, Selenium WebDriver, TestNG, Firebug, Fire path, XML, XPATH, DOM, Quality Center, Cucumber, Jira, SVN, Agile, Internet Explorer, Chrome, Firefox, SQL, Jenkins, SoapUI, Groovy, Eclipse, Maven

Hire Now