Sr. Qa Test Engineer / Etl Tester Resume
San Mateo, CA
SUMMARY
- Over 10 years of extensive experience in Analyzing, Designing and Implementation of Selenium QA Engineer for Web based and Client/Server web applications using both manual testing and Automation testing.
- Extensively used Selenium (data - driven, XPath locator) and Web Driver to test the web applications.
- Experience in Teamcity tool to handle daily build installations on Windows servers
- Experienced in designing and enhancing automated test scripts for Selenium using Python.
- Extensive knowledge and experience in analyzing business specification documents, designing and developing Test Cases, Test Scenarios, Test Scripts and Test reports of manual and automated tests.
- Hands on experience in Junit, TestNg, and Page Object Model (POM) automation frameworks.
- Experienced in Black box and Gray box including GUI, Ad-hoc, Smoke, Functional, Regression, System, and Integration.
- Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
- Experience in all phases of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle and Development Methodologies like Waterfall and Agile.
- Expertise in different types of testing like Functional, Regression, System, Usability, Back-End and User Acceptance of web and mobile applications.
- Extensive experience in preparing Test Plans and Test Cases/Test Scripts based on user requirements and system requirements documents.
- Hands on experience in executing test scripts with tools and technologies such as Java, Selenium WebDriver/IDE/Grid, JUnit/TestNG, Jenkins, and REST PRO .
- Skillful in using tools like Firebug and Fire Path for identifying XPath of web elements.
- Proficient in functional testing of mobile and web applications - manual and automation using Selenium WebDriver and Maven with TestNG framework.
- Experience in using Data Driven and Page Object Model (POM) for Selenium WebDriver and TestNG.
- Sound knowledge of Maven for project builds and Jenkins with TestNG Selenium for Continuous Integration. Good experience in writing and executing SQL queries to perform data validation and back-end testing of databases to check the integrity of data.
- Strong experience with Version Control Systems such as SVN and GIT
- 5+ years’ experience as VMware and VCentre Administrator
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 10/9.x/8.x/7.x, SSIS, Data Stage, Ab Initio
QA Tools: Selenium (IDE/ WebDriver/ GRID), Maven with JUnit/TestNG, SOAP UI and JMeter for SOAP and Restful Services, Log4J, POI, Ant, Maven, Jenkins, Bugzilla, JIRA.
DBMS/Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator, snowflake
Programming Languages: Python, java, Scripts Java, SQL, HTML, CSS, Java Script, XML, Shell Script, Groovy Script
Database and Tools: MySQL, Oracle, MS SQL Server Teradata V2R6/V2R5
Version Control Tools: Rational Clear Case, WIN CVS
Version Control: Stash, Sub Version (SVN), GitHub
Operating Systems: Mac OS X, Microsoft Windows Vista, XP, 98, 2000, NT 4.0 UNIX Sun Solaris, HP - UX
Scheduling Tools: Autosys, Control M, Flux
Other Tools: IntelliJ IDEA, Eclipse, Firebug, Fire Path
QA Methodologies: Agile, and Waterfall
PROFESSIONAL EXPERIENCE
Confidential, San Mateo, CA
Sr. QA Test Engineer / ETL Tester
Responsibilities:
- Developed and maintained Manual and Automated test scripts for Regression testing using Selenium WebDriver and TestNG.
- Involved in rigorous meetings with testing team and DWH Lead to plan and implement the testing Effort.
- Design & Development of 16 ETL mappings using Informatica Power center 10/9.6.1
- Integrate with your existing infrastructure like Servlet Containers, App Servers, Loads of databases with JDBC drivers
- Developed and executed SQL queries in the database to conduct data integrity testing by checking the data tables on the server.
- Wrote python automation testing using selenium webdriver across Chrome, Firefox and IE browsers
- Involved in Performing Functional testing, Regression testing, System testing, Integration testing, Security testing, Configuration testing, GUI testing and User Acceptance testing.
- Created Test plan, High level scenarios, test case construction and test estimates, resource estimates and weekly status reports.
- Responsible for ETL batch jobs execution using UNIX shell scripting to load data from core database to Staging and Data mart tables.
- Conducted Test Case Walkthroughs to achieve consensus on Test Case correctness & completeness ensuring width and depth of test scenarios
- Used HP ALM/Quality Center for reporting and tracking bug and generating reports.
- Responsible for handling daily build installations on Windows servers using Teamcity
- Used HP ALM/Quality Center for the planning and execution of manual testing, along with defect tracking.
- Involved in writing automation scripts for mobile native applications using Appium, Core java and Selenium.
- Prepared Test Traceability Matrix to confirm the test coverage and mapped it with Test cases using HP ALM/Quality Center.
- Maintain the test logs, test reports, defect tracking using HP ALM/Quality Center.
- Verification and Validation experience in Acceptance testing in cucumber and also maintain Future file, Step Definition, Runner
- Implemented Agile/Scrum methods for testing approach and configured Selenium GRID scripts on Virtual machines.
- Performed Compatibility testing of applications for dynamic and static content of browsers using HTML Ids and XPath in Selenium
- Created manual test cases for ETL jobs. Ran ETL jobs in VERTICA and compared final data with source data.
- Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from source systems like Netezza loaded into Oracle.
- Monitored resolution status of the bugs and verify them fixed in new releases.
- Maintained Selenium scripts in between releases. Reproduce failed automated test cases manually.
- Provide cross-browser (Chrome, Firefox, MSIE, Safari, Opera) and cross-platform (Windows 8) testing of the application's web pages.
- Installed, implemented, configured, managed and support Virtual Machines with VMware
- Maintain the highest level of expertise in designated products and components of the VMware Environment
Environment: Selenium, TestNG, SoapUI, Python, HP ALM/Quality Center, Informatica power center, Snowflake, SQL, Agile, Java, Web Services, Mercury Test Director 6.5,AWS,EXSi MS Excel, Flat files, Animate, UNIX- Putty, AutoSys, IBM Rational ClearQuest, itHub, Teamcity, JIRA, Confluence, RIDE, PyCharm IDE, Eclipse, VMware, VCentre
Confidential, Northfield Township, Illinois
Sr. Automation Test Lead / ETL Tester
Responsibilities:
- Involved in analyzing Business Requirement Documents and Technical Specification document and developed test plan and test cases for testing the application.
- Tested independent and dependent modules individually and prepared Test Matrix to keep track of the requirements and the test cases.
- Develop Test Cases using HP ALM/Quality Center.
- Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
- Defined, developed, and executed automation test scripts using Java that leverage black and white box testing across functional, non-functional and performance testing.
- Used HP ALM/Quality Center for maintaining Test Cases and for Defect Tracking and Defect Reporting.
- Created automation framework in Page Objects design and page navigation framework for readable test script and easy maintenance from developer perspectives.
- Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
- Developed test automation framework scripts using Python Selenium WebDriver
- Integrated Automation scripts (Selenium WebDriver API) in Continuous Integration tools (Jenkins) for nightly batch run of the Script. Created Project plan on Jenkins, configured scheduled using Chronos job.
- Provide technical support to ETL applications on Informatica 10/9.6.1, UNIX and Oracle 11g.
- Developed test automation scripts using Selenium WebDriver for regression and performance testing of the various releases of the application.
- Performed manual testing of each build and then regression testing using Selenium WebDriver.
- Worked on Cross Browser testing through Selenium WebDriver by testing the website on different browsers like Chrome, IE and Firefox.
- Involved in running the Informatica jobs for loading the test data into the target and testing of ETL Informatica mappings and extensively worked on Workflow logs and Session.
- Developed Test Framework in Selenium for UI Regression Test Automation and when necessary, and potentially execute Unit Test automation (Java).
- Developed data driven test scripts to check the same functionality with multiple sets of data
- Used TestNG Annotations in Selenium WebDriver and executed a batch of tests as TestNG suite
- Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
- Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
- Developed Selenium scripts in TestNG for parameterization using Data Provider annotation.
- Conducted System Testing and User Acceptance Testing for every client and Conducted Backend testing writing extensive SQL queries
- Review and understand the ETL processes, functionality & identify test requirements and coverage.
- Involved in documentation as to how to maintain and run scripts for future enhancements. Responsible for testing the application against different environments in QA, staging and production
- Analyzed the business requirements, developed test plans and created test cases in Quality center, a test management tool
- Maintain the highest level of expertise in designated products and components of the VMware Environment
Environment: Java, Selenium WebDriver, TestNG, HP ALM/Quality Center, Jenkins, SoapUI, Java Script, SQL Server,AWS, IE, Firefox, Chrome, WebLogic, Windows, UNIX.EXSi VMware, VCentre
Confidential, Lawrence, MA
Sr. Automation Test Engineer
Responsibilities:
- Performed application server builds in Azure environment and monitoring them using Azure monitor.
- Tested all the ETL processes developed to fetch data from source to the data warehouse.
- Reviewed the Test Basis, designed, Test Cases and executed test cases.
- Responsible for writing and maintaining Selenium WebDriver scripts for regression and functional testing using data driven framework.
- Implemented Page Object Model framework with Python and Selenium
- Worked extensively on the Netezza framework on Windows platform and contributed to building the customized ELT framework using Shell scripting
- Worked on Informatica Power Center 8.6.1 tool - source analyzer, warehouse designer, mapping designer, workflow manager, mapplets, and Reusable Transformations.
- Setup the Automation framework using Selenium to run test cases in multiple browsers and platforms.
- Validated PL/SQL and ETL batch processes that are scheduled using Control M.
- Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (TestNG).
- Involved in testing the application utilizing the Scrum (Agile) methodology.
- Involved in learning and designing of automation framework to be used in UI testing with Selenium.
- Execute browser compatibility and regression tests using Selenium WebDriver for testing UI for every new build release.
- Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
- Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
- Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
- Created test plans and performed unit testing for the Informatica mappings.
- Tested ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
- Reduced manual testing to convert test case to Automation using Selenium web Driver
- Experienced in using Maven build tools to manage framework dependency jar files.
- Expert in using Git / GitHub/Bit Bucket as a source repository system.
- Skilled in using Jenkins and AWS Bamboo as a Continuous Integration / Continuous Deployment tool.
- Developed Automation scripts for new enhancements using Selenium WebDriver and Junit.
- Supported Linux servers in production/QA/Deployment environment.
- Good Knowledge in using JIRA for tracking, analyzing and documenting defects.
- Identified defects during test executions, logged them into Quality Center's Defect module for bug tracking and generated defect reports.
Environment: Java, GIT/ Bitbucket, Bamboo/Jerkins, Maven, TestNG, Eclipse, Selenium, Jira, REST API .
Confidential, Dallas, TX
QA Test Engineer
Responsibilities:
- Performing functional testing as per user stories and performed Integration testing & system testing using Selenium WebDriver automation scripts and test automation for web application (SWAP module) using Ruby in Watir.
- Testing using data driven testing approach to validate the components displayed on the website using Selenium. Also performing Parallel and Cross Browser testing on different browsers like Internet Explorer, Chrome, Safari and Firefox where multiple tests were run at the same time.
- Designing and developing test automation Artifacts (scripts, functions, scenarios, processes) for simple to complex automated testing situations using tools like Selenium, TestNG and XPath.
- Preparing test cases using Selenium Web driver to validate all UI components, Popups, Browser navigations, Mouse movements.
- Developing and executing test scripts using Selenium WebDriver, TestNG, analyzing test results.
- Implementing TestNG automation framework for Smoke Test to ascertain that the crucial functions of the application work and also implementing Regression Test to detect bugs after enhancement and configuration settings of the code.
- Working on Application Screenshots and copying the images whenever exceptions occurred and also at important checkpoints of application execution.
- Using Fire Bug, Fire Path to debug, edit and locate the objects based on ID, Name, XPath, and CSS Selector. Also developing automated test cases using Ruby in Watir.
- Performing Web services testing using SOAPUI Tool. Validating request and response XML. Adding assertions to validate the XML in Web services SOAP and RESTFUL service.
- Performing manual testing for Mobile application.
- Executed end-to-end testing for integration of various components in the application.
- Participating in Release Review/Requirement Analysis and Design review meetings.
- Updating Test Plans and Test Cases periodically to manage changes to requirements.
- Tracking defects and sending them to the developer-using clear quest and generating various query defects and defect reports.
Environment: Clear quest, SQL, SOAP UI, I-Phone, Android OS, Agile, Web Service, Ruby Script, Watir-WebDriver, Selenium IDE, XML, Microsoft Office, TestNG.