We provide IT Staff Augmentation Services!

Automation Test Engineer & Etl Tester Resume

3.00/5 (Submit Your Rating)

Charlotte, NC

OBJECTIVE

  • Over eight (8+) Years of Experience in Information Technology Industry seeking a Challenging position in order to utilize my Experience and Professional & Technical Skills in Software Development Industry as a Software Test Engineer, Quality Assurance Analyst using widespread Knowledge of Information Systems Technology.

SUMMARY

  • Over 8 years’ experience in testing of various industries including Government Solution, Finance and bio - pharmaceuticals as Software Quality Assurance on various levels of Quality Assurance and User Acceptance Testing for Client/Server and Web based applications on Windows.
  • Solid understanding of Software Development Life Cycle (SDLC), CMMI, and different types of methodologies such as waterfall, Agile and Iterative.
  • Extensive work experience in Software Quality Assurance and Testing with excellent knowledge and experience with Software Development Life Cycle (SDLC) & Quality Assurance Life Cycle (QALC).
  • Experienced with QA Methodology and QA Validations to ensure the Quality Assurance.
  • Efficient in implementing QA Process, establish standards, procedures, and methodologies.
  • Specialized in user requirements analysis, Test Estimation, Test Plan for various types of testing,( Defect Management and interaction with client)
  • Developed Test Plans, Test Cases, Test Scripts and Test Reports.
  • Expertise in Manual Testing, Client Server, Web testing, Business Functionality Testing, System Testing, Integration Testing, User Acceptance Testing, Performance Testing, Stress Testing, Black box Testing, End-to-End Testing.
  • Expertise in Manual Testing (MTM “Microsoft test manager”, Test manager, HP Quality Center, ALM Quality Center). Solid Experience with Automation Testing Tools using Quick Test Professional (QTP), Soap UI, Selenium Webdriver.
  • Maintained projects in JIRA. Maintained the sprints and releases and communicated defects through the projects efficiently.
  • Strong knowledge of SQL, T-SQL and excellent understanding of ETL testing.
  • In depth knowledge of statements for backend testing, skill at writing in SQL quarries/sub-quarries and joining multiple tables.
  • I performed the reporting with Crystal Report and also have strong knowledge in SSRS.
  • Experience using defect tracking tool Test manager, Quality Center, Test Director, and Jira.
  • Developed automation project using Selenium Webdriver with Java programming language.
  • Developed Page Object Framework and also Page Factory Framework.
  • Expertise in Build management tool Maven, TestNg Framework and Jenkins CI tool.
  • Strong experienced to identify objects using Locators.
  • Organized, attention to details, self-motivation, personable, multi-focused and ability to meet project milestones and deliverable dates.
  • Quick learner, capable to learn new system, software & hardware technology quickly.
  • Ability to handle multiple projects with competing deadlines in a fast paced environment.
  • Possess excellent interpersonal, written, verbal communication skills and strong analytical, problem solving, decision-making skills.
  • Ability to work effectively both in a team environment and independently.

TECHNICAL SKILLS

Programming Language: Java, Ruby, VB Script, HTML, CSS, XML, Java Script, JSON, and YAML

Software testing tools: HP Quality Center, Quick Test Pro, Selenium Webdriver, Ruby Mine IDE, Eclipse IDE, Soap UI, Jira, Bugzilla, SharePoint and Crystal Report

Operation Systems: Windows XP, Vista, Win 7, Win 10

Testing Methodologies: Regression Testing, System Testing, Sanity Testing, Functional Testing, Positive and Negative Testing, Validation, User Acceptance Testing

Databases: My SQL, Microsoft SQL Server, Oracle

Browsers: Internet Explorer, Firefox, Chrome, Safari

CI: Version One, Jenkins.

Server: Windows

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Automation Test Engineer & ETL Tester

Responsibilities:

  • Followed Agile/Scrum Methodologies for all of the project activities and attended daily standup meetings, reviewed user stories.
  • Was involved in creating the Test plan based on BRD and User Stories.
  • Developed and executed Automation Test Scripts using Selenium Web driver to test the web application.
  • Used Firebug, Fire Path Add-on tools to identify the object’s id, Name, Xpath, link in the application and also used custom xpath and cssSelector going to console.
  • Used regular expression to make the script handier.
  • Handling special keyboard and mouse events are done using theAdvanced User Interactions API, containing theActionsand theActionclasses.
  • Involved in developing selenium automation framework using TestNG and performed Data driven testing which reads data from property and XML files.
  • Performed build acceptance testing and smoke testing.
  • Used the profiler in the pom.xml file to run the tests according to need through Maven.
  • Used Maven to build and run the Selenium Automation framework.
  • Integrate the test suites to Jenkins to execute them automatically after every successful deployment.
  • Developed automated Data driven scripts to perform negative and positive testing of the application by providing different data.
  • Performed functional, compatibility testing on different browsers like Firefox & Chrome.
  • Implemented the Logger using Log4j for Selenium test cases.
  • Performed the automation process with Page Object framework.
  • Implemented Listener Interface to get all the information likes - success, failure etc. and also used Extent Report to get the overall result.
  • Extensively used SQL queries to check storage and accuracy of data in database tables.
  • Written complex SQL queries for validating the data stored in different database tables.
  • Helped the team in analyzing the data to be able to identify the data quality issues.
  • Involved in Database testing by writing & executing SQL queries using Microsoft SQL Server to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
  • I performed Product Validation Testing, Source to Target Testing, Meta Data Testing, Data Completeness Testing, Data Accuracy Testing, Data Transformation Testing, Data Completeness Testing etc.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing of the flow and the logic for the Data warehouse project.
  • Monitored the data move process through Data Extract to Flat file through SSIS (SQL Server Integration Services) Execution flows and Loading data to Data mart.
  • I tested the assigned stories, Task and Sub-Task in Jira and reported issues in the Bug reporting system and followed up with the development team until it was resolved using Jira.
  • At the end of every sprint, I submitted QA Regression Sign-Off status report and QA Sign-Off report status report.

Environment: Selenium Webdriver, Eclipse IDE, Jira, Java, HTML, XML, SQL Server, Jenkins.

Confidential, Charlotte, NC

Software Test Engineer

Responsibilities:

  • I identified the objects using Locators, such as- Name, ClassName, Id, linkText, partialLinktext, xpath, and cssSelector.
  • I performed Action class to interact with the object handling Ajax and Mouse interactions.
  • I handled Auto Suggestive dropdown, tables and grids.
  • Prioritized the test cases with TestNg Annotation such as- using BeforeSuite, AfterSuite, BeforeTest, AfterTest, BeforeMethod, AfterMethod, SupressWarning etc.
  • Executed test cases at suite level, package level, test level and class level.
  • Executed test cases through the testng.xml file for example- including the exclude and include keyword using either test level or method level not to execute certain tests or methods or to execute certain of them.
  • Performed Group functionality like smoketesting, regression testing, creating groups tag in the testng.xml file and add the functionality name inside the @test
  • I used Annotation Helper Attribute when to execute the dependencies one method to one or multiple methods while executing.
  • Data Provider Annotation when to run the test cases with multiple data it means data driven. a
  • I used Listener Interface which implements ITestListeners interface to get the fail, success, info etc. by implementing the unimplemented methods.
  • Using the Eclipse IDE to develop the code for the application and execute the test cases, also running the Page Object Framework.
  • Performed Data Driven Testing using Excel File attaching the dependency of the apache poi file in the Maven pom.xml file.
  • Developed automated Test Scripts using Java programming language for .testing application..
  • Also adding the log4j dependencies to see the log for error, info etc. which is framework used in the Maven dependencies actually pom.xml file to log the information wherever in the test cases do I need, we can get the information either in the console or file.
  • Performed the automation process with Page Object framework and also Page Factory Process.
  • Worked on Jenkins (CI tool) to execute the test cases periodically schedules.
  • Worked with the developer to ensure that the testing issues are solved immediately.
  • Strong analytical skills, ability to multi-task in fast paced environment & display flexibility

Environment: Selenium Webdriver, Java, Jira, HTML, XML, Jenkins, Eclipse IDE.

Confidential, Washington, DC

Software Test Engineer & ETL Tester

Responsibilities:

  • Responsible for analyzing the Business Requirements and Functional Specifications to design tests
  • Involved in developing Test Plan, Test Strategies and Test Cases.
  • Developed Requirement Traceability Matrix to map the test cases with the Requirements.
  • Used Quality Center for uploading requirements, creating Test Plan, Test Cases, Test Sets and updating Test results.
  • Wrote Test Plan and performed various kinds of testing such as Functional Testing, Integration Testing, Security Testing, Smoke Testing, Backend Testing, and Regression Testing.
  • Identified the objects using Locators.
  • Performed Action class to interact with the object handling Ajax and Mouse interactions.
  • Handled Auto Suggestive dropdown, tables and grids.
  • Prioritized the test cases with TestNg Annotations.
  • Executed test cases at suite level, package level, test level and class level.
  • Executed test cases through the testng.xml file.
  • Performed group functionality, Annotation Helper, Data Provider Annotation and Listener Interface.
  • Built a Maven project and added all the dependencies in the pom.xml file.
  • Integrated TestNg with Maven.
  • Created profile in the pom.xml file.
  • Using the Eclipse IDE to develop the code for the application.
  • Performed Data Driven Testing using Excel File.
  • Developed automated Test Scripts using Java programming language for .testing application.
  • Extensively involved in writing Test Cases, executing and analyzing AUT with the HTML report or archiving in a folder.
  • Also added the log4j dependencies to see the log for error, info etc.
  • Performed the automation process with Page Object framework and also Page Factory Process.
  • Worked on Jenkins (CI tool) to execute the test cases periodically schedules.
  • Worked with the developer to ensure that the testing issues are solved immediately.
  • Strong analytical skills, ability to multi-task in fast paced environment & display flexibility
  • Good knowledge in creating Tables, Views, Triggers, Stored Procedures, User Defined Functions, and Indexed views.
  • Worked extensively on ETL process and test data type, data size, columns, rows and checking correctness of data while transformed by the data developers.
  • Checked the data integrity between the tables usually by checking the constraints.
  • Excellent knowledge in Data Extraction, Transforming and Loading using SQL Server Integration Services and Bulk insert Task.
  • Performed ETL Testing by extensively writing SQL queries.
  • Validated tests by crosschecking data in backend on SQL Server, using SQL Queries.
  • Worked with the developer to ensure that the testing issues are solved immediately.
  • Strong analytical skills, ability to multi-task in fast paced environment & display flexibility
  • Generated status reports for release tracking purposes.

Environment: Selenium Webdriver, Eclipse IDE, Jira, Java, HTML, XML, SQL Server, Jenkins.

Confidential, Philadelphia, PA

Software Test Engineer & ETL Tester

Responsibilities:

  • Developed Test plan, Test Cases based on the User Requirements and System Requirements Document for functional, Regression, Web testing and Back end testing.
  • Involved in QA Life Cycle to enhance the work flow get going.
  • Understanding the Functional Requirements, Design Documents, Requirements documents and Use Case and designing test cases for corresponding modules to test the complete functionality of application.
  • Using the Eclipse IDE to develop the code for the application.
  • Performed Data Driven Testing using Excel File.
  • Developed automated Test Scripts using Java programming language for .testing application.
  • Extensively involved in writing Test Cases, executing and analyzing AUT with the HTML report or archiving in a folder.
  • Also added the log4j dependencies to see the log for error, info etc.
  • Wrote and executed system test cases for the application on an SQL Server database.
  • Developed complex SQL queries involving multiple tables inner and outer join.
  • Good knowledge in creating Tables, Views, Triggers, Stored Procedures, User Defined Functions, and Indexed views.
  • Involve in writing SQL queries to validate data with Back-end with the GUI.
  • Experience with RDBMSs (SQL Server) and demonstrated ability to write SQL statements.
  • Responsible for the day-to-day and weekly status report on the progress of the testing efforts.

Environment: Java, Windows, SQL Server, Quality Center, HTML, XML

We'd love your feedback!