SUMMARY

• 6+ years of experience in teh field of Information Technology in Software Development Life Cycle (SDLC) with emphasis on Software Testing/Quality Assurance and ETL testing.
• 3+ years of Big Data testing experience with 5+ years of ETL testing.
• Expertise in Selenium Automation using Selenium WebDriver,SeleniumIDE, Java, TestNG, Cucumber Maven.
• Maintained Selenium and Java Automation Code and resources in source controls like SVN for improvements and new features.
• Extensively involved in Load Testing, GUI Testing, Integration Testing, Regression Testing, Data Driven Testing, Functionality Testing and UAT on Client /Server and Web - based applications.
• Experience with Fast paced environment like Agile/Scrum Methodology.
• Experience on testing tools like QTP/UFT, ALM Quality Centre (QC) andSelenium Web Driverand Grid.
• Experience in formulating Test Strategies and methodologies, Test Plans, Test cases, based on User Requirement and Business Requirement documents in various Frameworks inSeleniumand QTP/UFT.
• In depth technical noledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Extensive experience in Retail and E-commerce domains with POS, ETL and Mainframe applications testing.
• Highly adept in Database Testing using SQL Queries with multiple Databases Oracle, DB2, SQL Server and MySQL.
• Experienced in different types of testing on AUT like GUI, Functional, Regression, System Testing, Integration, Performance and end to end Testing.
• Experienced in testing Mobile Application both in Emulator/Simulator and Real Devices. Tested mobile customized website using Chrome User Agent.
• Experienced in Back-End testing to ensure data consistency on front-end by writing and executing SQL queries.
• Wrote complex SQL query by joining multiple tables according business logic for data validation
• Experienced in load test, stress test and performance test using Load Runner by scripting V-User scripts for multiple users, multiple transactions at rendezvous points
• Extensive working in VI editor to update, configure file & check text based data file.
• Strong experience on Web Service & Hands on experience in validating Web Services using SOAP-UI.
• Expertise in Defect Management and Tracking, Test Execution, Test Report generation, and Analysis using HP ALM, and JIRA.
• Worked in Multiplatform Environments like Windows, UNIX, Web applications, and GUI based client/server applications.
• Excellent communication, problem solving skills, coordination, documentation, project planning and interpersonal skills.

TECHNICAL SKILLS

API testing Tools: Postman, SOAPUI

Language: SQL, JAVA, XML, JSON, HTML, Python

Microsoft Tools: MS Office, MS Project Professional, MS Access, WinSCP

Databases: HIVE/IMPALA, Oracle, MySQL, SOQL, MS SQL Server

Query Analyzer Tool: TOAD for Oracle, MS SQL Server Management studio, Hive, Impala

Testing Tools: Selenium IDE & Selenium Web Driver, SOAP UI, PUTTY, TOAD

Reporting Tools: HP ALM QC., JIRA

ETL Tool: Informatica workflow Monitor, Informatica Designer, Business Object, Universe

Operating Systems/ Products: Windows, UNIX, UBUNTU, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills, MI

Sr. QA Analyst (ETL & BIG DATA/Hadoop)

Responsibilities:

• Analyzing teh business requirement with all possible scenarios, creating test scenarios as per teh business requirement.
• Performed Functional testing, regression testing and End to End testing of ETL.
• Reviewed test scenarios with business and developers to make sure all points are covered and make updates if necessary.
• Created expected results SQL script to perform functional and regression testing.
• Created UAT test scenarios and worked with business users to execute teh UAT test scenarios.
• Extensively involved in source to target data validations by verifying teh mapping documents and ensuring teh data is being populated correctly.
• Inserted mocked up data in Hive, Salesforce and Data warehouse to get teh best testing result to cover all possible scenarios.
• Provided training to new resources on using Hive/Impala, how to validate, create data and views in salesforce and test case and defect creation in JIRA.
• Used Hive, Impala, Salesforce Developer Console, and TOAD for Oracle to write and execute complex queries.
• Reported bugs and followed up with developers to resolve teh defect using JIRA.
• Created test cases in JIRA using Zephyras teh tool for mass loading test cases and defects and also used JIRA as defect tracking tool.
• Created and executed test cycles in JIRA and extracted RTM for testing approval from business.
• Attended Daily standups, scrum, sprint demo and other meetings on special topics.
• Used confluence to track releases and reviewing demos and to discuss with other team members.
• Analyzed teh defects and performed root cause analysis for issues in production and QA environment.
• Experience using Shell Script by running Perl Script, changing parameters and loading or extracting files to share folder directory with teh help of PuTTY.
• Experience monitoring ETL Workflow and Session logs using Informatica Workflow Monitor.
• Performed integration testing between SAP FICO and Datalake to test encrypted file transfer.
• Involved in testing file transfer between Client and External vendor by creating sample files using WinSCP.
• Performed Web service testing by validating Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI and POSTMAN tools.
• Experience using Kibana and sumo logic to extract XML and Jason requests and debug teh issue.
• Mocked up data in XML to test Webservice using SOAP UI. Created UAT test scenarios and worked with business users to execute teh UAT test scenarios.
• Validated Data security and sharing rules in Salesforce. Tested Users, Profiles, Role hierarches and Permission sets as per user profile and Public group.
• Created SOQL query using Salesforce developer console to test data load from Datalake to salesforce and vice versa.
• Possess extensive experience on salesforce functionality and experience using salesforce to create data for ETL.
• Performed End to End testing between MDM, Datalake and Salesforce.
• Used Hive and Impala as Query Scripting tool for Datalake and Salesforce Developer for SOQL.
• Hands on experience on testing salesforce UI and VW portals.
• Paced up teh work to maximum ability in teh tight situation of deadlines.
• Experience in Performance testing by loading thousands of records and noticing time required to extract those records without any errors.

Environment: Datalake, Salesforce.com, Oracle SQL Developer 4.0.3, MySQL 7.9, Hive/Impala, Salesforce developer Console, PuTTY,, Informatica 10.4.1, WinSCP, Hadoop, POSTMAN, SOAPUI, Kibana, sumo Logic, MS Office.

ETL QA Tester

Responsibilities:

• Experience working in Agile SCRUM environment and sound interaction with Scrum Master and Technical Lead.
• Extensive experience creating test plan document, test strategy, test cases and execution of test cases.
• Experience Creating Test Scenarios using Business Requirement Document and Functional Requirement Documents.
• Logged Bugs and created different Bug reports using JIRA.
• Working experience in ETL Testing using testing tool like Informatica, Toad and Test Management tool as Quality Center.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Mapping.
• Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Weekly Status reporting to client and coordinating project budget, yearly task order sign-off and release planning in Agile methodology.
• Tested teh ETL process for both before data validation and after data validation process. Tested teh messages published by ETL tool and data loaded into various databases.
• Recorded and created test using Selenium IDE.
• Performed automated Functional and Regression Testing using Selenium Webdriver using TestNG framework.
• Performed Cross Brower testing using Selenium Webdriver.
• Handled Elements using different plug-ins like Firepath(Xpath).
• Added different breakpoints and enhancing script using different java features for writing teh test script.
• Extensive experience doing smoke testing and sanity testing when builds get released.
• Extensive experience using Jenkins for Continuous Integration Testing.
• Performed Database testing using JMeter with adding different listeners and samplers and also creating different forms of test results.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Tested Business Objects reports and Web Intelligence reports
• Extensive experience writing SQL queries using joins and stored procedures. To write queries used MS SQL Management Tool.

Environment: Manual/Automated Testing, Agile-SCRUM, JIRA, Informatica, SeleniumIDE, Selenium Web Driver, Java, JMeter, TestNG, Junit, Eclipse, Jenkins, X-path, CSS, MS SQL Server.

Confidential

Jr. QA tester

Responsibilities:

• Worked with team members in development of Test Plan and Test Cases based on Business Requirements and Required Documents.
• Maintained QA lab standards, documentation review and assisted in establishing and maintaining best practices for QA.
• Analyzed requirements and critical areas of teh application to set up and execute Baseline Tests.
• Performed Manual Testing of teh website to determine ease of usability of teh website.
• Conducted Data Driven Testing using Parameterization.
• Generated and implemented templates for Test Plan, Test Cases, Test Scripts, Gap Analysis, Test Defect Log, Test Case Checklist etc.
• Conducted Functional Test and Regression Test during various phases of teh development.
• Performed backend testing for data validation using SQL Queries.
• Performed Positive and Negative Testing manually.
• Analyzed teh results of manual tests.
• Tracked Defects using ALM QC.
• Designed and maintained Test Matrix and Traceability matrix.
• Involved in Baseline, Functional, Stress and Usability Tests.
• Participate in various meetings and discussed Enhancement and Modification Requests.
• Held daily meetings with teh developers to update test documents.
• Provided regular feedback to developers on defects status.

Environment: Windows 7, HP ALM Quality Centre, MS office (Outlook, Word, Excel), WTMS, SQL