SUMMARY

• IT experience in QA Testing of software systems in Data Warehouse/ Business Intelligence/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 target tables
• Extensively worked on the entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and QA Methodologies like Agile, Waterfall, and Iterative process.
• Experience in developing test automation scripts 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 maintaining automation test 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 Big Data technologies like Hadoop, Hive, Hadoop Distributed File System and Map Reduce
• Experience with automate data extraction and processing of data for modeling purposes where applicable, and experience with big data storage 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 with ETL tools Informatica Power Center, Confidential 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 of ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using Informatica
• Experience in maintaining Full and Incremental loads through ETL tools 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, Data Stage, Ab Initio

Big Data 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 & Confidential

ETL Tester

Responsibilities:

• Established and documented ETL QA standards, procedures and QA methodologies. Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2 Tested ETL jobs as per business rules using ETL design document.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Worked in Big Data environment projects to re-build the business system using the Hadoop, Spark, Hive and other Big Data technical, including Planning Management and Inspection Management.
• Developing ETL scripts in Hive Query Language in the Big Data Environment to allow for more streamline reporting. Responsible for providing ad-hoc queries off Big Data Hadoop System.
• Performed big data processing using Hadoop, MapReduce, Sqoop as well as Kafka.
• Responsible for developing data pipeline using Flume, Sqoop and Pig to extract the data from weblogs and store in HDFS.
• Provided design and technical assistance with challenging issues that Big Data Integration spans multiple systems Confidential Hadoop.
• Imported data from MySQL to HDFS, using Sqoop to load data in both static and dynamic mode
• Responsible for software product test and development for a core, high growth Automation control system infrastructure system in Agile environment. Developed test cases and test automation, 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 under test to maximize the automation test script with Selenium.
• Converted commercial Scripts to open source Selenium WebDriver 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 several ETL Mappings developed using Informatica.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts. Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Analyzed application data using SQL to identify ETL processes. Analyzed and tested ETL Informatica Mappings with source data, staging and target data.
• Wrote Informatica ETL design documents, established ETL coding standards and performed Informatica mapping reviews.
• 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 target tables.
• Tested the ETL process for both before data validation and after data validation process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads. Performed Data stage, ETL jobs logic into SQL query to compare logic and track the defects in UAT rack sheet.
• Involved in data warehouse testing by checking ETL procedures/graphs. Performed the tests in both the SIT, QA and contingency/backup environments
• Extensively worked on various types of testing like ETL Testing, 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

QA 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 provide ETL testing 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, ETL Analysis, ETL test 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 Selenium automation using Selenium Web Driver and Selenium IDE
• Wrote and developed automation/manual Test Strategies, Test Plans, Test Scenarios and defining test cases for a given set of requirements.
• Performed big data processing using Hadoop, MapReduce and Sqoop.
• Designed and deployed of Hadoop cluster and different Big Data analytic tools including Hive, Sqoop, Flume and Spark
• Involved in importing the real-time data to Hadoop using Kafka and implemented Oozie jobs for daily imports.
• Designed and Implemented the ETL process using Enterprise Big Data Edition to load the data from Source to Target Database.
• Created automation framework 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 using Selenium Web 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 using Selenium Web 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 develop test strategy, test plan, test data, test case and test automation along with active participation in process improvements.
• Tested different DWH ETL Informatica Mappings especially are used effectively to develop and maintain the database.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide- ETL Solution using Informatica
• Tested the ETL mappings output with the back end by writing test cases and SQL test scripts.
• Responsible for testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Involved in ETL process for a Data Warehouse from their legacy systems using Informatica Power Center.
• Tested the ETL Informatica transformation and other ETL Processes (DW Testing)
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements. Verified session logs to identify the errors occurred during the ETL execution.
• Worked on ETL tool 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 to QA to 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

QA Analyst

Responsibilities:

• As an ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
• Tested ETL mappings to extract and load data from different databases such as Confidential, SQL Server and flat files and loaded them in to Confidential .
• Involved in testing the ETL mappings, 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 for ETL rules in Quality Center Test Plan. Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Testing the ETL data movement from Confidential Data mart to SQL Data mart on an Incremental and full load basis. Involved in the error checking and testing of the ETL procedures and programs Informatica session log. Responsible in testing Initial and daily loads of ETL jobs.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Developed data quality test plans and manually executed ETL and BI test cases. Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed transformations, cleaning and filtering on imported data using Hive, MapReduce, Impala and loaded final data into HDFS.
• Involved in development of Hadoop System and improving multi-node Hadoop Cluster performance.
• Exported the data using Sqoop to RDBMS servers and processed that data for ETL operations. Responsible for ingesting large volumes of data into Hadoop Data Lake Pipeline on daily basis.
• Designed and develop Big Data analytic solutions on a Hadoop-based platform and engage clients in technical discussions.
• Involved in Test Case Preparation and Test Case Execution using both Manual and Automation techniques.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment using Selenium WebDriver.
• Developed Test Frameworks in Selenium for UI Regression Test Automation and when necessary and potentially execute Unit Test Automation (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 Selenium WebDriver to automate manual testing solutions.
• Designed & Developed data driven framework using Selenium WebDriver. Involved in setting up configuring the testing environment with Eclipse, TestNG and Selenium WebDriver.
• Participated in workflow migration from development to QA and to UAT environments as required. Responsible complete manually testing of the User Acceptance Test (UAT)