SUMMARY

• 7+ experience in QA Testing of software systems in Data Warehouse/ETL Testing for Client Server and Web - based environments under Windows and
• Expertise in testing Complex ETL Mappings based on business user requirements and business rules to load data from source flat files and tables to Confidential tables
• Extensively worked on the entireQALife Cycle, which includes designing, developing and execution of the entireQAProcess.
• Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) andQAMethodologies like Agile, Waterfall, and Iterative process.
• Experience in developing testautomationscripts using Selenium Web Driver for Regression and Performance testing for various releases of the application.
• Great experience working in Healthcare domain like HIPPA Guidelines, Claims, enrollment and Benefit.
• Experienced in developing, executing and maintainingautomationtest script with Selenium WebDriver and crating the tests in Java. Implement Integration, Functional testing using Java framework.
• Hands on experience in Automation testing using QTP.Experience in working with BigData technologies like Hadoop, Hive, Hadoop Distributed File System and Map Reduce
• Experience with automatedataextraction and processing ofdatafor modeling purposes where applicable, and experience withbigdatastorage systems that enable production and research use-cases such as Hadoop Distributed File System.
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Extensive experience withETLtools Informatica Power Center, IBM Data stage and Ab Initio.
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Extensively use ofETLmethodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETLSolution using Informatica
• Experience in maintaining Full and Incremental loads throughETLtools on different environments.
• Involve in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application and Test Data Management Plan.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.
• Extensive experience in writing complex SQL Queries and PL/SQL scripts.
• Expertise in test management using HP Quality Center and ALM and maintained Versioned objects using Rational Clear Case.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8x,DataStage, Ab Initio

BigData Technologies: Hadoop, MapReduce, Hive, Pig, HBase, Impala, Hue, Sqoop, Kafka, Storm

Analytics Tools: SQL

Others: MS Office Suit (Word, Excel, Power Point), MS Project)

PROFESSIONAL EXPERIENCE

Confidential -VA

Sr.ETL Tester

Responsibilities:

• Established and documentedETLQAstandards, procedures andQAmethodologies.Analysis of Business requirements & Design Specification Document to determine the functionality of theETLProcesses.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2 TestedETLjobs as per business rules usingETLdesign document.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Worked inBigDataenvironment projects to re-build the business system using the Hadoop, Spark, Hive and otherBigDatatechnical, including Planning Management and Inspection Management.
• DevelopingETLscripts in Hive Query Language in theBigDataEnvironment to allow for more streamline reporting.Responsible for providing ad-hoc queries offBigDataHadoopSystem.
• Performedbigdataprocessing usingHadoop, MapReduce, Sqoop as well as Kafka.
• Responsible for developingdatapipeline using Flume, Sqoop and Pig to extract thedatafrom weblogs and store in HDFS.
• Provided design and technical assistance with challenging issues thatBigDataIntegration spans multiple systems beyond Hadoop.
• Importeddatafrom MySQL to HDFS, using Sqoop to loaddatain both static and dynamic mode
• Responsible for software producttestand development for a core, high growthAutomationcontrol system infrastructure system in Agile environment. Developedtestcases andtestautomation, per the development process, that verifies the software requirements.
• Developed and implemented Key Word Driven, Data Driven Hybrid Framework with Selenium Page Object Model to automated application undertestto maximize theautomationtestscript with Selenium.
• Converted commercialScripts to open sourceSeleniumWebDriver scripts to maximize the profits of the company without compromising Quality. Created test cases with automation framework for Selenium, Selenium Web driver, Selenium Grid.
• Developed automation scripts using Selenium WebDriver, JAVA, Selenium Grid and Maven for web applications.
• Prepared the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Extensively tested severalETLMappings developed using Informatica.
• Worked withETLSource System and Confidential System (ETLMapping Document) for writing test cases and test scripts.Tested Ab Initio graphs and used Ab Initio as anETLtool to load the final loads.
• Analyzed application data using SQL to identifyETLprocesses.Analyzed and testedETLInformatica Mappings with source data, staging and Confidential data.
• Wrote InformaticaETLdesign documents, establishedETLcoding standards and performed Informatica mapping reviews.
• Tested ComplexETLMappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to Confidential tables.
• Tested theETLprocess for both before data validation and after data validation process.
• TunedETLjobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Designed and developed UNIX shell scripts as part of theETLprocess to automate the process of loading, pulling the data for testingETLTest loads.Performed Data stage,ETLjobs logic into SQL query to compare logic and track the defects in UAT rack sheet.
• Involved in data warehouse testing by checkingETLprocedures/graphs.Performed the tests in both the SIT,QAand contingency/backup environments
• Extensively worked on various types of testing likeETLTesting, Reports Testing, Integration Testing, Functional testing, Regression testing, Back-End testing
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle.

Confidential -CT

ETL Tester

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Analyzed business requirements, scope documents and detailed functional requirements and to propose feature changes, determine and provideETLtesting effort estimates.
• Used ALM/Quality Center for writing Test Plan, Test Cases development, test script writing, Test case execution & Defect Tracking Assisted in gathering the business requirements,ETLAnalysis,ETLtest and design of the flow and the logic for the data warehouse project
• Developed Test Cases for Black Box and GUI Testing of the entire product and analyzed the test results with the Customers. Performed Seleniumautomationusing Selenium Web Driver and Selenium IDE
• Wrote and developedautomation/manualTestStrategies,TestPlans,TestScenarios and definingtestcases for a given set of requirements.
• Performedbigdataprocessing usingHadoop, MapReduce and Sqoop.
• Designed and deployed ofHadoopcluster and differentBigDataanalytic tools including Hive, Sqoop, Flume and Spark
• Involved in importing the real-timedatatoHadoopusing Kafka and implemented Oozie jobs for daily imports.
• Designed and Implemented the ETL process using EnterpriseBigDataEdition to load thedatafrom Source to Confidential Database.
• Createdautomationframework in Selenium WebDriver using behavior driven approach like Cucumber. Wrote and executed test cases for major program modules as per Business Requirement Documents
• Developed automated scripts usingSeleniumWeb Driver and Implemented Frame work using Java.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment usingSeleniumWeb Driver.
• Responsible for testing packages using SSIS (ETL) to verify Data Completeness, Data Transformation, Data Quality, Integration Testing, UAT & Regression Testing.
• Implemented quality software best practices to developteststrategy,testplan,testdata,testcase andtestautomationalong with active participation in process improvements.
• Tested different DWHETLInformatica Mappings especially are used effectively to develop and maintain the database.
• Extensively usedETLmethodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETLSolution using Informatica
• Tested theETLmappings output with the back end by writing test cases and SQL test scripts.
• Responsible for testing ofETLjobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Involved inETLprocess for a Data Warehouse from their legacy systems using Informatica Power Center.
• Tested theETLInformatica transformation and otherETLProcesses (DW Testing)
• Prepared Test Cases and Test Plans for the mappings developed through theETLtool from the requirements.Verified session logs to identify the errors occurred during theETLexecution.
• Worked onETLtool Informatica Mapping Designer, Workflow Manager, and Workflow Monitor.
• Involved in Inserting Checkpoints to check for broken links, Text and standard properties of an object using QTP
• Tested user interface and navigation controls of the application using HP ALM
• Performed smoke and sanity testing while deploying the reports from Dev system toQAto prod box.
• Wrote Test cases and SQL queries to validate the data pulled in from the Data Marts and populated.
• Wrote SQL queries in order to data validation in migration as part of backend testing
• Responsible for developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements. Created slides for explaining data flow and process flows using PowerPoint and Microsoft Visio

Confidential -MN

QA Analyst

Responsibilities:

• As an ETLTester responsible for the business requirements,ETLAnalysis,ETLtest and design of the flow and the logic for the Data warehouse project using Informatica.
• TestedETLmappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle.
• Involved in testing theETLmappings, by validating whether the mapping adhere to the development standards and naming conventions, whether the mapping work correctly in relation to other processes in your data logistical flow.
• Developed test cases and scripts forETLrules in Quality Center Test Plan.Involved in preparing detailed Business Analysis documents,ETLdesign documents, unit test plans for the mappings
• Testing theETLdata movement from Oracle Data mart to SQL Data mart on an Incremental and full load basis. Involved in the error checking and testing of theETLprocedures and programs Informatica session log.Responsible in testing Initial and daily loads ofETLjobs.
• DevelopedETLtest scripts based on technical specifications/Data design documents and Source to Confidential mappings.
• Developed data quality test plans and manually executedETLand BI test cases.Involved in data warehouse testing by checkingETLprocedures/mappings.
• Performed transformations, cleaning and filtering on importeddatausing Hive, MapReduce, Impala and loaded finaldatainto HDFS.
• Involved in development ofHadoopSystem and improving multi-nodeHadoopCluster performance.
• Exported thedatausing Sqoop to RDBMS servers and processed thatdataforETLoperations.Responsible for ingesting large volumes ofdataintoHadoopDataLake Pipeline on daily basis.
• Designed and developBigDataanalytic solutions on a Hadoop-based platform and engage clients in technical discussions.
• Involved inTestCase Preparation andTestCase Execution using both Manual andAutomationtechniques.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment usingSeleniumWebDriver.
• DevelopedTestFrameworks in Selenium for UI RegressionTestAutomationand when necessary and potentially execute UnitTestAutomation(Java)
• Performed Regression testing on new builds, every modification in the application using Selenium Web driver.Conducted back end testing in QTP by inserting database checkpoints
• Wrote and executed automated test cases using SeleniumWebDriverto automate manual testing solutions.
• Designed & Developed data driven framework using SeleniumWebDriver. Involved in setting up configuring the testing environment with Eclipse, TestNG and SeleniumWebDriver.
• Participated in workflow migration from development toQAand to UAT environments as required.Responsible complete manually testing of the User Acceptance Test (UAT)