PROFESSIONAL EXPERIENCE

Confidential

Sr. QA Automation/ETL Tester

Responsibilities:

• Created Test plan, High - level scenarios, test case construction and test estimates, resource estimates and weekly status reports. Verify the daily/weekly Confidential freight data ETL pipeline is executed properly and validate the data in every step of the pipeline Wrote complex SQL queries for validating Business Reports. Querying using SQL and updating records and validate database records as expected.
• Created frameworks using Selenium Web Driver, Postman, XML, JSON, JavaScript, Test Driven Development and Data Driven frameworks etc. Attended triage meetings to understand and consider the scope changes for the release during the test execution phase. Generated defect reports, bugs validation with tools Test Director / Quality center. Migrated scripts from Selenium IDE to Selenium WebDriver and created framework scripts from scratch.
• Performed backend testing to verify the data integrity by passing SQL queries Automated scripts in Intranet/Internet applications using Selenium Web Driver and SOAP UI

Environment: HP ALM11.0, Selenium IDE, Selenium Web Driver, HP Quality Center 10.0/9.0, Manual Testing, Agile, Eclipse, Windows, Java, XML, HTML, MS SQL, SQL Server 2016, Oracle, Informatica, Test Director, Jira, SSIS

Confidential

Sr. Selenium/ETL Tester

Responsibilities:

• Analyzed the Business Requirement Document (BRD) and Functional Specification documents (FSD) to prepare Test Cases based on the Test Plan and Use Cases and attended Reviews meetings to better understand the applications. Analyzed test data and Conducted Database or Data driven testing under certain business rules for data population in DB. Tested the ETL process for both before data validation and after data validation process.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables. Involved in querying using SQL and updating records and validate database records as expected. Attended triage meetings to understand and consider the scope changes for the release during the test execution phase. Migrated scripts from Selenium IDE to Selenium WebDriver and created framework scripts from scratch.
• Performed backend testing to verify the data integrity by passing SQL queries Execution of test suites and HTML report generation using TestNG.

Environment: HP ALM11.0, Selenium IDE, Selenium Web Driver, HP Quality Center 10.0/9.0, Manual Testing, Agile, Eclipse, Windows, Java, XML, HTML, MS SQL, SQL Server 2014, Oracle, Informatica, Test Director, Jira

Confidential

Sr. QA, Selenium/ETL Tester

Responsibilities:

• Executed Automation Testing for Java applications using Selenium IDE and Selenium RC. Wrote Test Plan for the web application after analyzing the specifications and business requirements. Tested the ETL Informatica workflow and other ETL Processes (Data Warehouse Testing) Performed GUI functional and sanity testing manually for each new build of the application.
• Performed Gray Box Testing, Regression Testing, Manual Testing, and Functional testing and Usability testing. Analyzed system requirements and develop test plan for End - to-End testing. Used Selenium IDE for testing various web applications. Configured Selenium Grid for parallel execution on multiple browsers with 10 VM's. Worked on SQL stored procedures, triggers and views.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity. Developed SQL Stored Procedures and Queries for Back end testing. Defect Management using ALM, JIRA and Conflict Management.
• Monitored the defect tracking process using Clear Quest, trouble shooting and generating customized graphs and reports for the client. Prepared the Manual test cases that were not covered under Automation process.

Environment: Informatica power center, Selenium 2.39.0, Selenium Web Driver, Jira, Agile, Oracle 10g, PL/SQL, Java, Microsoft Office, Windows

Confidential

Quality Assurance Engineer

Responsibilities:

• Interpret application architectures and identify areas for automation. Developed & executed SQL queries in the database to conduct Data Integrity testing by checking the data tables on the server. Coordinate with source system owners, day - to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance. Created Test plan, High-level scenarios, test case construction and test estimates, resource estimates and weekly status reports.
• Conducted Test Case walkthroughs to achieve consensus on Test Case correctness & completeness ensuring width and depth of test scenarios. Created Java based scripts for Selenium Web Driver with Junit as automation framework. Performed Compatibility testing of applications for dynamic and static content of browsers using HTML Ids and XPath in Selenium. Updated framework functions& developed test scripts using Selenium Web Driver.
• Conducted Cross browser testing in IE, Chrome and Firefox using Selenium. Managed Test results and defects using Bugzilla defect tracking tool. Created queries in TFS to validate results of TFS reports.
• Prepared user documentation with screenshots for UAT (User Acceptance testing)

Environment: Selenium, JUnit, SVN, JIRA, JMeter, Quick Test Pro, Quality Center 9/10, PL/SQL, Agile, TFS, HP Load Runner 9.1, XML, Java, Microsoft Visual studio, Web Services