We provide IT Staff Augmentation Services!

Automation Qa Lead/bigdata-hadoop Test Lead Resume

Mnemoneefalls, WI

SUMMARY:

  • Having 11 + years of Software Quality Assurance experience as a QA Automation Test Lead /ETL Test Lead/Bigdata Hadoop Test Lead which includes Selenium Webdriver Java Automation frame work Testing,Web Services/Rest API Testing with Soap UI, Cucumber BDD Testing, Web Application Testing, Database Testing, Dataware house ETL Mapping Testing and Hadoop Bigdata Testing.
  • Having experience on various domains like Retail Marketing, E - commerce, Insurance,911 Emergeny Call, Power station and Mobile Telecom.
  • Selenium Automation Framework Testing (Java Environment, .Net Environment)
  • ETL Dataware house Testing
  • BI Report Testing
  • Bigdata-Hadoop Testing
  • Web Application Testing
  • Backend/Database Testing
  • API Testing/Webservices Testing
  • Unix Testing
  • Excellent experience in each phase of Test Life Cycle, Test strategies, Test plans and UAT.
  • Experience in Defining Testing Methodologies, creating Test plans, Test Strategy, Test cases, Test Reports, Verifying and validating QA implementation in all phases of Software Development Life Cycle (SDLC).
  • Automated highly transactional e-commerce web application using Selenium WebDriver.
  • Experience in Selenium automation testing by using Selenium WebDriver, Selenium Grid and Selenium IDE
  • Designed and implemented different automation frameworks from starch like Page Objects framework, Keyword Driven framework, Data Driven framework and Hybrid framework.
  • Experience in Maven, Jenkins, Git, TFS and GitHub.
  • Experience in CI/CD integration testing on the Devops principles.
  • Experience in the frame works by using TestNG,JBehave and JUNIT
  • Experience on the Performance Testing by using JMeter.
  • Hands-on coding experience in scripting language- VB Scripting.
  • Having experience on the Bigdata Hadoop Testing by using HDFS,Pig,Mapreduce,Hive,Hbase,Spark and Azkaban.
  • Having experience on the Data Ingestion process Testing and validation testing by using Hive-HQL and HBase.
  • Solid experience of Software Development Life Cycles, Cucumber, JAVA, JUnit, Web Applications, JIRA, Maven.
  • Executed automation scripts on different browsers/environments & reported defects/results to the team.
  • Experience on the Web services/API testing by using SOAP UI, REST, XML, WSDL and XSD.
  • Having very good experience of Quality Assurance methodologies like Waterfall, V-Model, and Agile Scrum.
  • Solid experience of AGILE Methodologies, Scrum processes
  • Solid experience of Defect/Test Management tools like JIRA, Quality Center/Test Director, BugZilla and Rational Clear Quest.
  • Proven ability in developing BDD scripts with Cucumber and writing step definitions for behavior.
  • Excellent experience of build tools like Maven and managing JAVA automation projects using them.
  • Strong communication & interaction with Clients, Developers, Business Analysts, Management
  • Experience in Working individually or as a part of team, Problem solving, Process improvement activities, Analytical skills, Reporting and Assisting to Manager
  • Experience to handle the multiple projects and delivered as per the project deadlines.
  • Expertise to write complex SQL Queries and performance Database testing.
  • Experience on the Web testing by using HTML, XML, Java,J2ee,CSS,Java Script, AngularJS, jQuery, PHP.
  • Strong experience on the On-shore -off-shore model process and leading the off-shore team.
  • Experience in the Mainframes Testing on the Batch-process and On-line process.
  • Experience on the Pre-Production validation testing and Post Production validation testing.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data verification and identifying data mismatch.
  • Experience in ETL testing of applications which use integrated database using Informatica, Oracle, DB2, Tera Data, Sql Server, Hive and Netezza.
  • Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
  • Experience on Data Validation Automation Testing by using Informatica DVO tool.
  • Experience on the Testing of Unix shell scripts and Linux commands.
  • Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
  • Expert in different types of testing that includes Black Box testing, White Box Testing Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT).
  • Knowledge in testing Python Scripting and Ruby Scripting.

TECHNICAL SKILLS:

Automation Testing Tools: Selenium WebDriver/RC/Grid/IDE,QTP,UFT

Languages/Frameworks: JAVA, JBehave,JUnit,TestNG,Python,Ruby

BigDataHadoop: Hive, Hbase, HDFS,Azkaban,Pig,Unix

Bug Tracking Tools: JIRA, BugZilla, Rational Clear Quest

Test Management Tools: HP QualityCenter/TestDirector

RDBMS: Netezza,SQL,Teradata,MySQL,Oracle,DB2,Mongo DB, No SQL

Scripting Languages: Java Script, Python,Ruby,HTML,XML,VB ScriptAngularJS,jQuery

Operating Systems: Windows 7/8, OS/390, UNIX, LINUX, Windows-10, Windows - 7, Vista, XP, NT

Domain Knowledge: E-commerce,Retail, Insurance, Banking, TelecomETL Tools: Informatica Power Center 9.5/9.1/ 8.6/ 8.1 , Abinitio, Aginity MDM

Analytics: Netezza Analytics

Tools: / Utilities: Erwin 8/ 7.2, Aginity, IBM Fluid Query, JIRA, IBM-Unica, Informatica DVOIBM: COBOL, JCL, CICS, DB2, Fi le-Aid, QMF, SPUFI, Unica

BI Tools: Cognos, Microstrategy, Tableau

Application environments: C#, .NET Framework, ASP.NET, VB .NET, Web Services, Java,J2EE,JSP

MS Suite/ Project Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio

SDLC Methodologies: Waterfall, Agile Scrum, V-Model

Google environment: Google Sheet, Google Drive

WORK EXPERIENCE:

Confidential, Mnemoneefalls, WI

Automation QA Lead/BigData-Hadoop Test Lead

Responsibilities:

  • Agile Methodology implemented.
  • Analyzed the Sprint User stories and the technical specification documents.
  • Involved in Sprint planning, Sprint Review, Sprint Retrospective and Sprint Demo
  • Prepared the Test Plan, Test schedule estimates based on the Sprint User stories.
  • Understand JIRA stories, use cases, business rules, requirements and acceptance criteria and convert them to test scenarios and test cases.
  • Implemented automation using Selenium WebDriver, JAVA, Selenium Grid, Cucumber and Maven .
  • Writing and modifying the automation test scripts according to requirement changes for every release using Selenium WebDriver.
  • Created and developed automation testing framework by using TestNG,Jbehave & JUnit
  • Running the scripts for validation and stabilization, analyzing the errors and issues.
  • Extensively automated regression and functional test suites by developing the automation scripts using Selenium WebDriver and JAVA.
  • Implemented Page Objects framework and classes from scratch to represent web pages.
  • Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel files and SQL Databases.
  • Used Maven, Selenium Grid to execute Selenium automation suites on different platform, browser combinations in parallel.
  • Developed BDD tests using Cucumber by writing behaviors and step definitions. Developed required Selenium support code in JAVA for Cucumber.
  • Wrote SQL queries extensively, queried database and generated test reports. Performed Purchase Orders Database testing by developing SQL scripts .
  • Performed Defect Tracking & Management in JIRA. Generated automated daily dashboards reports using JIRA.
  • Assisted Manager by providing automation strategies, Selenium/Cucumber Automation and JIRA reports.
  • Identified weaknesses in QA Processes, Web testing, Selenium Automation. Suggested & implemented improvements.
  • Executed and managed test cases and reported bugs in Quality Center-ALM.
  • Jira tool has been used to develop the User Stories for Agile process.
  • Developed the Automation scripts and did the Mobile Automation Testing by using Appium.
  • Followed the On-shore -off-shore model process and lead the off-shore team.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, System testing and User Acceptance Testing.
  • Supported for the Production Data validation testing and UAT testing.

Environment: Selenium, Java,Java script,HTML,Json,jQuery,TestNG,SQL,Teradata,UNIX, QC-ALM, Jira, MS Visio,Junit,Jbehave, Google Drive, CIA-Unica, JBehave,Netezza,Hive,Jenkins, GitHub,JMeter, Cucumber,BDD, Maven, Eclipse, IntelliJ IDEA,HDFS,Pig,Hue,Putty,Unix,Hbase,Azkaban.

Confidential, Beaverton, Oregon

Automation QA Lead/ETL Test Lead

Responsibilities:

  • Created automated Test scripts using automated tools and ran the test scripts on various Builds and instances.
  • Created Test cases using Element locators and Selenium Web driver methods
  • Enhanced Test cases using Java programming features and TestNG Annotations.
  • Execution of selenium test cases and verified the Test suits.
  • Conducted Data driven testing, cross browser testing and parallel test execution.
  • Involved in Automation environment setup Eclipse,Java,Selenium Web driver and TestNG
  • Designed the Automation Framework and Implemented the Automation Framework.
  • Followed the Agile Scrum methodology process.
  • Involved in Sprint planning, Sprint Review, Sprint Retrospective and Sprint Demo
  • Understand JIRA stories, use cases, business rules, requirements and acceptance criteria and convert them to test scenarios and test cases.
  • Define the scope of what will be tested, how it will be done (i.e. the testing tasks), when it will be tested (start/end dates), testing dependencies, associated program/project risks with testing, test entrance/exit criteria and who will be testing.
  • Develops test plans and strategies based on system requirements and design documentation.
  • Execution of test cases with documented results by using HP Quality Center Tool.
  • Raised the defect s for unmacthing of the expected and actual results.
  • Logged defects in HP Quality Center Tool with thoroughly documented details and attached examples.
  • Written the complex SQL queries to perform the data validation.
  • Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
  • Involved in Test Reporting on daily/ weekly basis and updated to same to the management and client.

Environment: Java, JSP, Selenium,Junit Webservices, Rest API, HTML, XML, CSS, JUNIT, Windows-10, Quality Center-ALM, VB-Script,QTP,UFT,Jira, Jenkins, Maven, Eclipse, AngularJS, Bootstrap, Node.

Confidential, Minneapolis, MN

QA Test Lead

Responsibilities:

  • Performed web Application Testing by using client provided environment.
  • Applied Agile Scrum methodology
  • Analyzed the Sprint User stories.
  • Involved in Sprint planning
  • Involved in Sprint Review meeting
  • Write requirements for user stories in QC
  • Peer review on requirements
  • Write test cases for new requirements
  • Associate requirements to test cases in QC
  • Participate in Prerelease review
  • Verified the data transfers through executing the SQL queries by using DB2.
  • Report and Review defects in Quality Center
  • Performed Functional testing, Regression testing, Integration testing, System testing, and E2E Testing
  • Interaction and discussion with Client on daily basis
  • Interaction with Australia customer on daily basis
  • Prepared Best Practice documentations and shared with team
  • Conducted trainings and mentoring junior team members.
  • Responsible for offshore deliverables and Team.
  • Responsible that there are no defects escape and high severity incidents for all tests delivered in subsequent faces.
  • Conducted weekly status meetings and Bug review meetings.
  • Organize the test status meetings and send the Status Report (Daily, Weekly etc.) to the Client.
  • Track and prepare the report of testing activities like test completion report for each phase, defects discovered and their status, performance baselines etc.
  • Updating Test results in QC and reporting the results on daily basis and weekly basis.

Environment: Eclipse, Core Java, Selenium, Webservices, Rest API, HTML, XML, Ajax, CSS, JUNIT, Windows-10, Quality Center-ALM, Jira, Jenkins, Maven, XML, XML SPY, Oracle, SoapUI,WSDL,PHP,MYSql

Confidential, Sanfransico, TX

Senior QA Test engineer

Responsibilities:

  • Involved in the Business Requirements and scope of the application Testing.
  • Performed various levels of testing like System testing, Integration testing and Regression testing.
  • Prepared the Test plan based on the business requirements.
  • Prepared the Test cases based on Functional Specification and System Requirement document
  • Peer review on Test cases
  • Upload the Test cases in Quality Center
  • Associate requirements to test cases in QC
  • Developed Automation test scripts using QTP and enhancement of the functionality of the Script for automation of testing Scenario.
  • Created and Tested framework module wise by using Vb-scripts to test the application functionality.
  • Prepared Test data for Test case execution
  • Executed the Test cases and validated the Test results.
  • Raised the defects for unmatched of the expected and Actual Test results.
  • Interaction and discussion with Client on daily basis.
  • Conducted weekly status meetings and Bug review meetings.
  • Monitoring Work progress on daily basis.
  • Prepared the Test summary report on the weekly basis.

Environment: QTP,VB-Script, ASP.NET, C#.NET, AJAX, HTML, PHP, XML, Quality Center, Windows-XP,, MYSql, Sql Server.

Confidential, Beaverton, Oregon

Senior QATest engineer

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
  • Created complex mappings that involved implementation of Business Logic to load data in to staging area.
  • Used Informatica reusability at various levels of development.
  • Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
  • Building Reports according to user Requirement.
  • Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
  • Implemented slowly changing dimension methodology for accessing the full history of accounts.
  • Write Shell script running workflows in unix environment.
  • Optimizing performance tuning at source, Confidential, mapping and session level
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
  • Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the issues.
  • Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Enhanced and created new ETL test cases based on the change requests.
  • Validate the source and the Confidential systems by executing the complex sql queries.
  • Tested the performance bottle necks at sources, targets, mappings and sessions and employed required measures.
  • Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
  • Performed various levels of testing like System testing, Functional Testing, Integration testing and Regression testing.
  • Conducted various management activities by analyzing and verifying test results, providing status reports.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading and pulling the data.

Environment: Informatica PowerCenter 8.6.1/9.0.1 , Teradata, Oracle 9i,Unix,Unix Shell Script Flat files,DB2, SQL, TOAD 7.0, Windows XP, OS390 and Autosys. Sql Server, Erwin 8.0, Quality Center, Agile Tool.

Confidential, Mnemoneefalls, WI

QA-Test Engineer

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Created complex mappings that involved implementation of Business Logic to load data in to staging area.
  • Used Informatica reusability at various levels of development.
  • Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
  • Building Reports according to user Requirement.
  • Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
  • Implemented slowly changing dimension methodology for accessing the full history of accounts.
  • Write Shell script running workflows in unix environment.
  • Optimizing performance tuning at source, Confidential, mapping and session level
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
  • Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the issues.
  • Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Enhanced and created new ETL test cases based on the change requests.
  • Validate the source and the Confidential systems by executing the complex sql queries.
  • Tested the performance bottle necks at sources, targets, mappings and sessions and employed required measures.
  • Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
  • Performed various levels of testing like System testing, Functional Testing, Integration testing and Regression testing.
  • Conducted various management activities by analyzing and verifying test results, providing status reports.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading and pulling the data.

Environment: Informatica PowerCenter 8.6.1/9.0.1 , Teradata, Oracle 9i,Unix,Unix Shell Script Flat files,DB2, SQL, TOAD 7.0, Windows XP, OS390 and Autosys. Sql Server, Erwin 8.0, Quality Center, Agile Tool.

Confidential, West-Minister, Colorado

QA-Test Engineer

Responsibilities:

  • Analyzed the Sprint User stories.
  • Involved in Sprint planning, Sprint execution, Sprint demo.
  • Prepared the Test cases based on the user stories in QC
  • Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to
  • Load data from source flat files and RDBMS tables to Confidential tables.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Validated the data in the reports by writing simple to complex SQL queries in the transactional system
  • Performed segmentation to extract data and create lists to load the data in the Confidential system.
  • Running workflows though control-M-jobs. Attending the client calls and updating the status of the Testing status
  • Oversaw the historical loads in UAT and PROD environments.
  • Also worked on Integration of all the processes in UAT/PROD.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Prepared the test cases after thorough analysis of each requirement.
  • Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
  • Conducted and actively participated in reviews, walkthroughs of test cases.
  • Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
  • Executed the workflows in the workflow manager, to start the ETL process.
  • Created and executed SQL queries to perform source to Confidential testing on DB2 database.
  • Worked on Autosys which involved in creation of Autosys jobs and execution.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading and pulling the data.
  • Updating Test results in QC and reporting the results on daily basis and weekly basis.

Environment: Cognos,SQL,Test Cases, Test Scripts, Test Plan, Traceability Matrix, Quality Center,IBM DB2, Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), SQL, Oracle8i.

Confidential, Colorado-Springs, Colorado

QA-Test Engineer

Responsibilities:

  • Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to
  • Load data from source flat files and RDBMS tables to Confidential tables.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Validated the data in the reports by writing simple to complex SQL queries in the transactional system
  • Performed segmentation to extract data and create lists to load the data in the Confidential system.
  • Running workflows though control-M-jobs. Attending the client calls and updating the status of the Testing status
  • Oversaw the historical loads in UAT and PROD environments.
  • Also worked on Integration of all the processes in UAT/PROD.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Prepared the test cases after thorough analysis of each requirement.
  • Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
  • Conducted and actively participated in reviews, walkthroughs of test cases.
  • Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
  • Executed the workflows in the workflow manager, to start the ETL process.
  • Created and executed SQL queries to perform source to Confidential testing on DB2 database.
  • Submitted the Jobs and verified the results in Spool files and tables.
  • Performed On-line Testing by using CICS screens.
  • Verified the data by executing Sql queries by using DB2, QMF, SPUFI
  • Involved in End to End Process Testing for Mainframes Testing and Web application Testing.

Environment: SQL, PL/SQL, TOAD 7.0, Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director,IBM DB2, COBO L, Flat Files, Copy Books, MVS, TSO, JCL, Control-M, ISPF, Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), SQL, Oracle8i.

Hire Now