We provide IT Staff Augmentation Services!

Etl Automation Tester Resume

Columbus, OH

SUMMARY

  • Around 5 years of experience in Software Testing along with Manual & Automation Testing process.
  • Experience in Testing Web and Windows applications.
  • Having good experience in Software Development Life Cycle (SDLC) process.
  • Having good experience in working with different Software Development Life Cycle (SDLC)models like Agile (2 weeks) Scrum Model, Iterative model and Waterfall model.
  • Having good work Experience under Agile environment, attended story walk throughs (3 amigos), providing estimates for the stories, developing acceptance criteria, developing test data preparing MOM (minutes of meeting) and scrum reports as well as attended scrum meetings, show and tells demos for every 2 weeks and Retrospective meetings.
  • Expert in Black Box and Whit Box Testing.
  • Highly experienced in writing and implementing Test Plans, Design, Development and execution of Test Scripts.
  • Proficient in using Quality Center, JIRA and Bugzilla as defect tracking and Test management tools.
  • Worked on Smoke Testing, Functional/Non - Functional Testing, Regression Testing, Retesting, UAT, UI Testing, Database Testing, API Testing, Adhoc Testing, Cross-Browser, Cross device Testing.
  • Worked on both SOAP and REST services for API Testing.
  • Having good experience on using SOAP UI, Ready API and POSTMAN.
  • Having good experience in writing queries using DDL, DML and DCL.
  • Having good experience in Working with UI and Backend automation.
  • Having good experience in working with RUBY-Cucumber, Java-Selenium-TestNG and Cucumber Java frameworks.
  • Having good experience in writing feature files in Gherkin language.
  • Having good experience in developing automation frameworks.
  • Having good experience in working with Page object model.
  • Having good experience with Selenium and Watir web drivers.
  • Having good experience to use the GIT commands to commit the code to GIT Hub.
  • Having good experience in using Docker to run Automation for parallel execution.
  • Having good experience in using Jenkins for continuous integration process.
  • Having good experience using Maven.
  • Having good experience using PUTTY and WinSCP.
  • Having good knowledge on Linux commands.
  • Experienced on Data ware/ETL Testing with Relational Databases such as Oracle and developed using SQL and TOAD.
  • Good experience in working with BDD (Behaviour driven development approach) writing feature files in Gherkin language, using page object methodology, developing step definitions and support methods in Ruby.
  • Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
  • Experienced with TDD, BDD and Cucumber Framework using Ruby Scripts.
  • Proficient in using Source Version Control tools like ANT, SVN, MTM (Microsoft Test Manager), TFS &GIT.

TECHNICAL SKILLS

Testing Tools: Selenium Web Driver/IDE/GRID/RC 2.4, HP Quality Center 12.5, J-meter, Cucumber, Firebug, Fire Path, Soap UI, HP UFT

Programming/Scripting Languages: Java, Ruby, VBScript, C, HTML and XML.

Frameworks: Junit, TestNG, TDD, Cucumber (BDD), Data Driven, Keyword Driven, Hybrid and Modular Frameworks, ATF (Automation Test Framework), Page Object Model, and Backend Testing Testing Integration, Functional, Regression, UAT, Retesting, Smoke, Adhoc, Black Box and White Box Testing.

SOA Technologies: SOAP and REST Web Services

Bug Tracking Tools: HP Quality Center, Bugzilla, JIRA.

Methodologies: Agile and Waterfall.

Build/ CI Tools: Ant, Maven, Jenkins.

Databases Technologies: SQL, Oracle

Operating Systems: UNIX and Linux.

Web Technologies: HTML, XML, CSS, Java script

Firefox Add-ons: Fire path and Firebug.

Networking Protocols: HTTP,FTP,SNMP and SSH,TCP,UDP,ICMP

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

ETL Automation Tester

Responsibilities:

  • Responsible for Manual and Automation deliverables
  • Extensive experience in Analysing Functional Specifications and developing Test plans, Test cases, Test estimation, execution of Test scenarios, analyzing the Test results. Defect Test Management in Informatica version upgrade V9.6.1 to V10.2.
  • Followed BDD approach developed feature files in Gherken language followed Page object model for defining elements and developed automation scripts in Ruby
  • Developed scripts for performing data base Automation using Ruby DBI module, sequel gem and data load validations using SQL Queries.
  • Participated in Dev/Test pairing for complex scenarios.
  • Good knowledge on Linux environment and commands for running a job in ETL perspective.
  • Used Git as code repository and Code Collaborator to manage code reviews and creating projects and assigning ownerships for the team.
  • Extensively used SQ LITE database in Ruby mine for creating models and creating temp tables for Target and source mappings.
  • Worked on IAM project for password management, Provided my Test support to the Business Partners.
  • Performed manual Testing on Chatbot for Service now queue.
  • Worked in Agile methodology and as a good team member in Standup meetings, Retro sessions, Show and Tell, Exit and Enter 3 - Amigos, Code Review and daily meetings.
  • Worked as BA for a while as not presence of our team BA (Created story cards).
  • Worked in an agile environment, and involved in writing Test plans, Test cases, Feature testing, Bug verification and regression test. Contributed to the functional automation suite. Analyzed failed test runs and fixed the scripts.
  • Extensively created and executed SQL queries in Oracle and SQL Server tables to validate data at the back end Excellent understanding and knowledge of Business intelligence tools for various applications of ETL, Reporting, Data mining, Data Warehousing, and Analysis of data..
  • Performed I&O validations(manually) after every patching in all applications like Informatica PWC, FileNet, Tridion and GIS (All supported apps) etc.
  • Performed I&O validations(Automated) after every patching in all applications like Informatica PWC,FileNet,Tridion and GIS(All supported apps) etc.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Data Stage Mapping.
  • Written several Teradata SQL scripts to load the data between Teradata tables.
  • Prepared documentation for show and tell and took part in retrospectives, Logged and tracked defects using HP Quality Centre.
  • Monitored server performance metrics on UNIX level.
  • Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
  • Involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP ALM.
  • Tested Netezza database for Data Validation, Data Verification using NZ SQL.
  • Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts.
  • Performed Testing by using salesforce and Sieble database connectivity’s in Informatica power centre.
  • Used Source to target (STM) mapping document to perform ETL testing for end-to-end flow of data.
  • Verified webservice testing in every month release activities on Performance test environment as well as in Production environment using Soap UI.
  • Developed Test cases to test different scenarios including positive and negative testing.
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software.
  • Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.

Environment: Ruby, Informatica PWC, IDQ, Cucumber, Maven, Groovy, Jenkins, Soap UI, HTML, XML, Eclipse, Ruby mine, SQL, Oracle, Netezza, Teradata, HP ALM Pearl Scripting, Unix.

Confidential, Dallas, TX

QA Automation Engineer

Responsibilities:

  • Responsible for Manual and Automation deliverables
  • Involved in designing and developing of Automation Test cases using Selenium WebDriver, Java, TestNG.
  • Responsible for implementation of Data Driven Frameworks, Page Object Model for web application.
  • Involved in preparing the functional test cases using test design techniques data validation concepts Equivalence partitioning, boundary value analysis.
  • Performed data driven testing by using JDBC and Groovy script as a data source in SOAP UI to test the webservices like REST, SOAP of the application and configured SQL queries to fetch data from the Oracle database.
  • Used BDD with Cucumber, Java and created feature files with scenario and scenario outline.
  • Good Experience in Agile methodology with SCRUM Process for the product development.
  • Involved in Writing Java Scripts to develop automated scripts and frame works to perform some backend functionalities.
  • Logged and managed defects using Quality Center/ALM defect management tool.
  • Experienced in load and performance testing tool JMeter by developing a java applicationfor validation of the responses and return descriptive error messages.
  • Involved in writing SQL Queries and validating schema, tables, server-side validations, triggers, data duplication, stored procedures using backend/ETL testing.
  • Worked with defect management tools like Jira, Bugzilla.
  • Worked on Cross browser compatibility of the project using tools like IE Tester.
  • Performed Unit testing using TestNG.
  • Maintained and executed Maven build files for running automated tests by adding dependencies.
  • Conducted Regression testing, smoke testing, cross browser testing through automated testing tools like Selenium web driver using Java and with cucumber using Java along with manual testing.
  • Used Jenkins as continuous integration server to run automated test suites.
  • Utilizing Jira and Git to document issues and store files.
  • Used web-debugging tools like XPath, Firebug and Firepath to locate elements.

Environment: Selenium WebDriver, Groovy Script, Cucumber, Gherkins, SOAP UI, Jenkins, Maven, TestNG, GIT, POM, Fire path, Firebug, Eclipse, XPATH, Java, SQL Server, JavaScript, JIRA, Bugzilla, IE Tester, ETL Testing.

Confidential, Chicago, IL

QA Analyst

Responsibilities:

  • Implemented Page Objects, Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium.
  • Created & Maintained Automation Selenium Automation Scripts for the Scrum Stories.
  • Automated highly transactional web application using Selenium WebDriver.
  • Execution of automated Test Scripts through Maven. Used Maven for building the WebDriver project.
  • Tested compatibility of application for dynamic and static content under various cross browsers using HTML ids and XPATH in Selenium.
  • Integrated with Continuous Integration tools Jenkins for running test on regular basis automatically.
  • Also responsible for converting automation scripts to new framework using Selenium WebDriver, Java and TestNG/Junit.
  • Experience in using Jenkins as a Continuous Integration server to configure with GitHub and Maven.
  • Experienced in load and performance testing tool JMeter.
  • Performed Regression Testing at various phases of development life cycle for impacted existing functionality.
  • Involved in testing Web services (SOAP and REST) and XML with tool called SOAP UI, for the local WSDL / with URL and created Test cases, run them, do load testing, security testing.
  • Worked in Agile - Behavior Driven Development (BDD) model.
  • Written gherkin and Ruby scripting automation test scripts to execute in Cucumber.
  • Worked on Agile(SCRUM) Methodology and used JIRA for defect tracking.

Environment: Java, Gherkin, Cucumber, Selenium, Maven, Eclipse, Git, JIRA, Soap UI, Jenkins, TestNG, Junit, Agile (SCRUM).

Confidential, Jercy city, NJ

Automation Tester

Responsibilities:

  • Involved in creation of automated test cases for testing various web modules like supplier data, inventory tracker, exchange tracker, damage tracker.
  • Identified test cases to automate the test cases using Selenium WebDriver, Junit and Java (Eclipse IDE) and Contributed in creation of framework.
  • Designed, developed and implemented POM based automation testing framework utilizing Java, TestNG and Selenium WebDriver. Involved in Automation of the test cases using Junit and Ant.
  • Responsible for back-end API testing with SOAP UI and coding in groovy and Java.
  • Created tests with Assertions like Schema Compliance, SOAP, XPath assertions using SOAP UI.
  • Involved in testing Web services and XML with tool called SOAP UI. Used this tool to locate WSDL file on internet, create Test cases, run them, do load testing, security testing.
  • Validated Web Service modules using Soap UI tool (Preparing Web Service request and added authentication information in Soap Header).
  • Used SOAPUI tool to test web services for Order History, Shopping cart, Account Creation and Shipment Tracking web services.
  • Involved in the Continuous Integration of the automation framework with Jenkins.
  • Worked with designing and building automation frameworks in Cucumber BBD.
  • Involved in acceptance testing using Cucumber.
  • Cucumber was used for entire regression testing and functional testing with primary tool as Selenium to test Scenarios, test Cases and Test conditions identified.
  • Used JIRA for Identifying, logging, tracking and escalating bugs.
  • Performed smoke testing in UAT and production environments for deployment verification.
  • Actively participated in daily scrum and sprint meetings as part of Waterfall Environment.

Environment: Java, Eclipse, Selenium, JIRA, SOAP UI, ANT, Junit, Cucumber, BDD, Waterfall.

Confidential

Manual Tester

Responsibilities:

  • Test case preparation based on the requirements document.
  • Designed test scenarios, test cases and test scripts for the application.
  • Conductedmanualtesting by validating all functionalities of the entire application
  • Followed Waterfall Methodology and involved GUI with various browsers, Functional, System, Regression, database and Performance Testing during various phases of the development.
  • Reporting bugs to Team Lead through Quality Center.
  • Interact with the development team on the defect resolution and detect bugs using QC.
  • Involved in database testing by retrieving the data from the tables using SQL queries.
  • Attend the Business review call with client and understand the application/test scenarios.
  • Review and analyze business requirements, use case and functional specifications for the application.
  • Writing test cases for the client scenarios and get baseline from Client.
  • Developed ANT Build scripts to run Sanity Test scripts developed in Selenium RC. Upload test cases in Quality Center and maintain the defect history.
  • Tested the application with various browsers

Environment: Microsoft Enterprise Library, Windows Communication Foundation, Windows Presentation Foundation, SQL Server, IIS Server, Quality Center 9.0,ANT,Selenium RC, Internet Explorer, Google Chrome, MS Word.

Hire Now