Etl Tester/automation Tester Resume
SUMMARY:
- More than 5+ years of experience in Information Technology as an Quality engineer.
- Exposure to all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC) and Defect Life Cycle Management.
- Experience in different Methodologies like Waterfall and Agile.
- Experience in Writing and Creating Test Scenarios, Test Cases, and Test Scripts, Execute Test Scripts, Verify Test Results, and Log Defects.
- Excellent understanding with Verification and Validation in the testing phase of Software Development Life Cycle.
- Performed and coordinated Peer Reviews of Test cases, Defects and maintain Review Checklists.
- Performed bug and defect reporting using JIRA
- More than 4 years of experience using Selenium Web Driver, Cucumber, Maven.
- Expertise in analyzing Software Requirement Documentation and based on the SMART criteria writing the test cases and developing test scripts.
- Experience in using Selenium Automation tool that includes Selenium Web Driver and Selenium IDE and Protractor.
- Experience in developing Automation Framework after Proof of Concept with different frameworks as Data Driven, Keyword Driven and Hybrid Automation Framework.
- Expertise in Selenium automation using Selenium Web Driver, Cucumber tool on Eclipse IDE, JAVA, JUNIT, Maven, TestNG and Jenkins as a Continuous Integration.
- Developed scenarios and features for the test cases using Gherkin language on Cucumber.
- Extensive knowledge of developing different type of framework like POM(Page Object Model), Data driven and Hybrid framework by using Junit, Maven, Cucumber, TestNG.
- Expert in performing Data driven & Keyword driven testing using Maven building tool (Using Java).
- Expertise in Smoke testing, Positive, Negative, Black Box, Functional, Integration, Regression Testing.
- Experienced in writing SQL queries to validate the data for the Back - end testing.
- Experience in Automation Testing of applications in different layers API using REST API.
- Expertise in using Firefox plug-in like Firebug and Fire Path for identifying Web Element Locators.
- Experience in creating Page Object Model and Page Factory framework as a part of the folder structure.
- Ability to test the compatibility of application with various browsers using HTML IDs and XPath with Selenium Web Driver.
- Proven ability to create an automation project using build management tool Maven using Java.
- Experience in configuring Maven built tool for automation projects and developing Maven project object model file (pom.xml).
- Expertise in developing BDD scripts with Cucumber and writing reusable methods for the behavior.
- Expertise in using Jenkins to pull the code from the repository, scheduling the Smoke test for continuous integration.
- Good experience in date validations between sources and targets using PLSQL, also involved in back end automation.
TECHNICAL SKILLS:
Testing Tools: Java, SQL, Jira, Informatica, JUnit, Maven Apache, Selenium Web Driver, TestNG, Jenkins
Other Relevant Tools: Eclipse, X-Path, SQL Developer, Notepad++, MS Office applications, First object xml editor, FireFox Firebug, Selenium IDE
Languages: SQL, HTML, XML, Java
Database: Oracle, MSSQL
Operating Systems: Windows, Unix
SDLC Methods: Agile, Waterfall
PROFESSIONAL EXPERIENCE:
Confidential
ETL Tester/Automation Tester
Roles and Responsibilities:
- Extensively involved in testing the application developed in Agile Methodology and detailed designs.
- Analyzed and optimized the use cases and created the Test cases based on them for Change Requests.
- Executed all Test cases in different phases of testing like Smoke, Regression and System testing of the application.
- Validated the Informatica workflows according to business requirement documents and used Informatica workflow monitor to run the workflow and verify their status and logs.
- Validated the Data Warehouse (DWH) Table structure part of ETL testing and executed batch processing and verify the ETL jobs status and data in database table.
- Tested all the rules implemented during ETL job and data move from source to target Data Warehouse (DWH).
- Developed complex SQL queries to test ETL jobs from source to target Data Warehouse (DWH).
- Designed data validation queries using analytical functions such as RANK, DENSE RANK, ROWNUBER and set operators UNION, UNION ALL, MINUS and INTERSECT.
- Involved in defining Test Scenarios for the applications and performed manual testing in HP Quality Center.
- Extensively tested OLAP applications and good knowledge on end to end testing of OLAP databases. Environment : Informatica 9.1, Oracle Database 11g, OBIEE 11.1.1.6, TOAD, SQL Developer, Windows XP, LINUX, EBS R 12.1.1/11.5.10
Confidential
Quality Engineer
Roles and Responsibilities:
- Create Automation Framework Using Selenium Web driver with TestNG and Junit framework.
- Create Page Object Framework, and Test Data Driven Framework using Selenium Web driver.
- Implement CICD using Bitbucket and Jenkins integration.
- Performed software web application testing included Functional, Integration and Regression Testing using Selenium Web driver.
- Prepared Automation Test Strategy, Automation Test Estimations, Test Plan, Test Cases and handling design Test steps and associated the corresponding requirements.
- Update and maintain test automation scripts in GIT Repository Integrate Automation Scripts with Bitbucket and Jenkins tools for Automated Test Execution.
- Implemented Continuous Integration & Continuous Development (CICD) using Jenkins Pipeline.
- Update and maintain Business Requirements/ User Stories, Test Plan and Test Case in JIRA tools.
- Prepared daily and weekly test automation reports and shared the same with the Client.
- Used JIRA for bug tracking and reporting, also followed up with development team to verify bug fixes and update bug status.
- Performed webservice testing using RESTFUL Web Services.
- Conducted defect triage meeting to discuss open defects/ issues on daily basis.
- Coordinated with Onsite-Offshore team as an Automation Test Lead/ Project lead as a part of Onsite-Offshore model.
- Performed back-end testing and wrote sql queries using Informix and validated functionalities. Creating automation script for backend testing using Selenium and JAVA.
- Worked as Automation Test Lead in project with onsite and offshore environment E2E testing for retail application.
- Created a few testcases Using protractor.
- Performed Functional testing on POS systems.
- Automation script development in Java for DB validation.
Environment: Oracle, SQL, Java, Selenium IDE, Selenium WebDriver, PLSQL, Protractor, NodeJS
Confidential
Quality Engineer
Roles and Responsibilities:
- Experienced in Software Quality Assurance including Manual and Automated testing with tools such as Selenium RC/WebDriver/IDE/Grid, and Junit/TestNG, Maven, Jenkins, Cucumber and Jira.
- Expertise in Functional Testing, Regression Testing, System Testing, Configuration Testing, Data Driven Testing & Cross-browser Testing.
- Extensive experience in using Selenium WebDriver APIs for writing Junit test suites and test cases for testing functionality with the Selenium Server.
- Expertise in performing different types of Testing like Sanity, functional, regression, smoke, user acceptance testing, GUI/Front-End testing and end-to-end testing.
- Experienced using Web-debugging tool like Fire path and Firebug for finding elements locator.
- Experience in providing the efficient locators strategy like XPath and CSS to run WebDriver script in stable condition.
- Experienced in using Jenkins as a Continuous Integration server to configure with Maven. Experience in identifying defects, prioritizing and tracking defects to closure.
- Experience in automating Java, Web and backend validations using Selenium WebDriver.
- Strong understanding of Object Oriented Programming (Oops) concepts.
- Good Knowledge in Black box, White box and GUI Testing.
- Experienced in building Test Cases and Test Sets in Quality Center.
- Performed Data Driven testing with multiple test data inputs with Selenium and MS-Excel. Experience in software testing process Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test Log, Test Results, Test Metrics & Traceability Matrix.
Environment: Java, Selenium WebDriver, IOS, Android, Jira, Back-end, Test Cloud
Confidential
Quality Engineer
Roles and Responsibilities:
- Generating test scripts to automate Functional and Regression Testing with Selenium IDE and Selenium Web driver using Junit.
- Executing SQL Queries which using multiple tables and join statements and validated the queries against Web-UI.
- Creating test strategy document and executing test cases and performed data driven testing. Responsible for identifying test cases for Automation, developing Automation test plans and Traceability matrix/Test strategy.
- Involved in team projects and focused on testing knowledge, technology, methodology and resources across similar projects.
- Implementing Backend testing by passing SQL Queries to verify the data integrity. Implemented Maven and POM (page object model) to manage a project's build and report. Developing manual test cases and reviewed it with different team members to verify its functionality.
- Proficient in working on Cross Browser testing through Selenium WebDriver by using different browsers like Chrome, IE and Firefox to test the website.
- Creating Bug reports, tracking and defect Management using JIRA.
- Used Firebug/Fire Path Add-on tools to locate elements and identify the Object's id, Name, X-path, link in the application.
- Executed Functional testing and Smoke testing on every build of the application.
- Performed User Acceptance Testing (UAT) with the help of end user requirements for each release.
- Involved in Agile Scrum Stand-up meeting, weekly automation and walkthrough meeting.
- Initiated and participated in Team meetings on a regular basis.
- Involved in active discussions by implementing better strategies and testing approach to improve the testing quality .
Environment: Eclipse, Selenium (Webdriver/IDE/Grid), Internet Explorer, Chrome, Firefox, SQL and Windows, Java, Javascript, Junit, Oracle SQL Developer, Firebug, Firepath, Jira, GitHub, Jenkins, SOAPUI.