SUMMARY

• Experienced Sr. QA Analyst and Data Warehouse ETL/Bigdata Tester with around 10 years in manual and automated testing of various Web - based, Client Server and Data warehousing Applications.
• Experience in Functional, Regression, Performance, System Integration Testing, Smoke Testing, GUI testing and User Acceptance Testing.
• Proficient in testing Web Based applications developed in C++, Java, .NET and used SQL Queries to query the databases like Microsoft SQL Server, Oracle, Teradata, IBM DB2 and Bigdata Hadoop.
• Solid experience in creating Test strategy, Test Plan, Test Scenarios, Test Scripts and Test Reports.
• Experience in ETL testing using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), DataStage, SSIS.
• Extensive Experience with the Utility Tools like TOAD, Teradata SQL Assistant, SQL Server Management Studio, SQL Developer and SQL Query Analyzer.
• Very good at writing complex SQL queries. Experienced in writing Joins, Stored Procedures, and Functions.
• Working experience on methodologies like Agile, Waterfall.
• Involved in upgrade, migration of application during which data validation was performed to test if the data from the older application was same as the data loaded into new application.
• Validating Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
• Experienced in Source to Target Testing to check the data before and after it passes through the transformation/mappings are exactly same and to test if the values before transformation and after are corresponding to the expected values.
• Worked on various active & passive transformations like Aggregator, Expression, Filter, Rank, Router, Lookup, joiner transformation, Stored Procedure and Sequence Generator.
• Testing slowly changing dimensions SCD Type 1 & SCD Type 2 to keep track of historical data.
• Expertise in developing and executing scripts using Selenium Web Driver and TestNG framework.
• Involved in setting up Automation Framework Using Selenium WebDriver, JAVA and TestNG.
• Expertise in validating SOAP and REST based web services.
• Strong in BI report validation developed using Tableau/Power BI and SSRS.
• Experienced in coordinating with the Project Management, Development, Configuration Management teams for release management, regression testing.
• Participated in daily defect review meetings and resolved issues related to bugs.
• Ability to handle multiple tasks and work independently as a team member.

TECHNICAL SKILLS

Test Management Tools: HP ALM 11/12.20/12.60 , HP Quality Center 9.2/10.0, JIRA, SOAPUI

Programming Languages: C, C++, SQL, PL/SQL, VBScript, JavaScript, Python

Automated Testing Tools: Selenium WebDriver, TestNG, Load Runner.

Database Systems: Oracle 11g/12c/19c, SQL Server 2008R 2/2012/2014/2016 , Teradata 15.00/16.20/17.00 , IBM DB2, Bigdata Hadoop, Amazon Aurora

ETL Tools: Informatica Power Center 9.6.1/10.1/10.2.0 , Data stage and SSIS

Reporting Tools: SSRS, Power BI, Tableau

Database Access Tools: Teradata SQL Assistant, SQL Server Management Studio, TOAD 12.12/ 13.1, Oracle SQL Developer

Web Technologies: HTML, XML and VB Script

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

ETL/Bigdata Test Lead

Confidential - Strongsville, OH

Responsibilities:

• Creating Test strategy, Test plans, Test cases and Test summary reports based on business requirements, Use cases and Functional specifications in Test plan tab of Microfocus ALM tool.
• Validated structure, data type and data for newly created Landing zone, stage, and base tables against STM document.
• Validated one time conversion for the historical data to SCD type 2.
• Coordinating with business users to get the UAT testing completed.
• Created complex SQL test scripts using sub queries and joins to retrieve data from multiple tables.
• Developed SQL queries to retrieve and created test data from different databases.
• Extensively used Workflow Manager and Workflow Monitor for creating and monitoring workflows and sessions.
• Verified the NO PII user is not able to see the PII data.
• Coordinated with all the downstream users involved in testing for signoff approvals.
• Managing and leading QA team of 4-5 members and participating in Daily Stand-up meeting, document walkthrough meeting, weekly assessment meetings with business analysts and developers.
• Involved in Production validation testing, Source-to-target count testing, Threshold value validation testing and Data check and constraint testing.
• Involved in extensive data validation by writing several complex SQL queries, back-end testing and issues related to data quality.
• Used Aggregate, scalar functions to verify the accuracy of data.
• Verified CA7 jobs execution.
• Importing and exporting data into HDFS using Sqoop.
• Involved in creating Hive tables, loading data, and writing hive queries.
• Validated data in interim tables using SQL queries based on logics provided by business.
• Validated the final consolidated file met the business requirements.
• Identifying duplicate records in the stage area before data gets processed.
• Responsible for generating Daily status report within depth information including Test case execution summary, Defect summary and issues and Risks details to make sure all stakeholders aware of the progress.
• Tested reports developed using Tableau.

Environment: Informatica Power Center, Microfocus/HP ALM, SQL, Shell Scripts, Toad, Teradata Studio, Bigdata Hadoop, Hive, Mainframe systems, UNIX, WinSCP, UltraEdit, Amazon Aurora, Tableau, Oracle, MS Office, Version one, Jira, Python, PuTTY.

Senior QA Automation Engineer

Confidential - Omaha, NE

Responsibilities:

• Analyzed Business Requirements document and provided inputs in Test Plan and prepared detailed Test Scenarios for new functionality.
• Worked with Architect, Development team to understand technical designs and architecture for test planning.
• Created whole test framework using Selenium for further test creation and execution.
• Prepared Requirement Traceability Matrix to map the coverage of the test cases.
• Scheduled meetings to collect data for automation from Team members, Project manager.
• Attended review meetings with Business Analysts and End Users to understand the requirements.
• Designed and developed automation scripts for Regression, UAT and functional testing for all modules using Selenium and WebDriver.
• Executed automation scripts on different browsers and reported results to the team.
• Updated Test Strategy and Test Cases periodically to manage changes in requirements.
• Query database using SQL for data verification and validation through SSMS.
• Participated in Daily Stand-up meeting, document walkthrough meeting, weekly assessment meetings with business analysts and developers.
• Developed SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data.

Environment: C#, .Net, Selenium IDE, Selenium RC, JIRA, Junit, Fire Path, Firebug, HTML, Windows XP, Java, JavaScript, XML, Apache-Subversion (SVN), Git, MS EXCEL, SQL, Apache-Ant, TFS.

ETL Tester

Confidential

Responsibilities:

• Created test cases for various levels of test such as Integration test, Regression test, System test, End to End test and User Acceptance test for different modules.
• Mapping the requirements, defects to test cases in ALM.
• Participated with QA Manager in discussing the Resource Allocation, Test Estimation, Test Design, and execution.
• Executed and compared actual with expected results and reported all deviations to the appropriate individual(s) for resolution.
• Documented test scripts, test results, test analysis, and reported the defects using HP ALM.
• Tested the application under Load and Stress using Load Runner.
• Created Manual Test cases for functionality, GUI, boundary, and error testing. Enhanced the test cases / scripts for each nightly build and conducted regression testing on each build.
• Performed Regression testing on every modification in the application using Selenium WebDriver.
• Generated the daily status reports, defect status reports, number of tests executed, and numbers of scripts passed and failed.
• Created test data for all ETL mapping rules to test the functionality of the SSIS Mapping.
• Involved in preparing Requirement traceability matrix and other testing related deliverables.
• Tested Web services using SOAPUI tool.
• Actively participated in QA Status meetings.

Environment: Selenium WebDriver, TestNG, Java, SoapUI, MS Office, XML, HTML, CSS, Windows, SQL Server, SSIS, SSRS, SSMS, Oracle, PL/SQL, SQL Developer, QTP, HP ALM, Load Runner, TFS.

Data Analyst

Confidential

Responsibilities:

• Supported Extract, Transfer, Load efforts using Integration Services tools. Created, configured, and modified SSIS packages.
• Working knowledge on SSIS transformation tools like Sort, Aggregator, Character Map, Lookup Transformation, Merge, Filter, Joins.
• Implemented slowly changing dimension for accessing the full history of transaction information.
• Created reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and Datasets, calculating subtotals and grand totals for the reports using SSRS.
• Experienced in Extracting data from Excel, Flat file and Transform it and Load to MS SQL Server by using SSIS.
• Used SSIS to extract files for the external vendors and coordinated that effort.
• Reported the defects in HP Quality Center and prepared defect reports for each build.
• Assisting User Acceptance Testing and user training sessions.
• Identified the Source and analyzed the Source data.
• Wrote data conversion and data migration scenarios for ETL process.
• Participated in weekly meetings with development Team.

Environment: Quality Center, Java, SQL Server, Oracle, SQL Developer, SSIS, SSRS, SQL, Load Runner, MS Office Suite.