Interacted and understood the BRR and FSD documents of the project. Preparation of Test Plan and get it reviewed by different stakeholders. Test Case, Test Script ,Test data preparation based on the requirement. Assign tasks and guide the team to overcome technical challenges. Loading and Validating the files in the live queue. Generate and Execute jobs to load data from Talend tool. Validation of the configuration file and setting the parameters before the job execution. Design of Complex Hive / Impala queries based on the transformation rules defined in the STTM document. Data Validation in all the Data Lake and Data Mart tables. Analysis of the Job error logs and identifying the root cause for the job failure. Design and develop Regression suite to validate the existing system whenever a new change has been implemented. To be a part of the Defect Triage Calls to discuss on the open defects with Development team,BA,Architect and Business Stake holders and also raise concerns of the QA team if any.

Interacted and understood the BRR and FSD documents of the project. Preparation of Test Plan and get it reviewed by different stakeholders. Design and Review of Test cases using HP ALM 12.51. Validation of transformation logic from source DB to IVR Data Warehouse. Execution of Test case, Test Script and reporting defects in HP ALM. Preparation of Ambiguity document, Traceability Matrix and Test Summary Report . Provide QA sign off once the Testing activities are completed.

Interacted and understood the BRR and FSD documents of the project. Preparation of Test Plan and get it reviewed by different stakeholders. Design and Review of Test cases using HP ALM 12.51. Designing Complex SQL queries using tools like SQL Server, ToadDataPoint to validate that UCCE Reports data are captured correctly as per the Business requirement. Identifying and Validation of Aggregate fields in UCCE Reports are captured as per the Business logic. Validation of data retrieved from Table Value Functions created in SQL Server DB against fact and dimension tables in Data Mart/DWH by designing SQL queries. Validation of Drill Up, Drill-down, Drill-through, Slice and Dice features in UCCE Reports. Validation of Sub-reports and the data captured are specific to the filter condition applied. Execution of Test case, Test Script and reporting defects in HP ALM. Preparation of Ambiguity document, Traceability Matrix and Test Summary Report . Provide QA sign off once the Testing activities are completed.

● Interacted and understood the BRR and FSD documents of the project.

● Preparation of Test Plan and get it reviewed by different stakeholders.

● Design and Review of Test cases using HP ALM 12.51.

● Designing Complex SQL queries using tools like SQL Server, ToadDataPoint to validate that UCCE Reports data are captured correctly as per the Business requirement.

● Identifying and Validation of Aggregate fields in UCCE Reports are captured as per the Business logic.

● Validation of data retrieved from Table Value Functions created in SQL Server DB against fact and dimension tables in Data Mart/DWH by designing SQL queries.

● Validation of Drill Up, Drill-down, Drill-through, Slice and Dice features in UCCE Reports.

● Validation of Sub-reports and the data captured are specific to the filter condition applied.

● Execution of Test case, Test Script and reporting defects in HP ALM.

● Interacted and understood requirement, develop test scenarios/ conditions along with test data requirements with support from Client and on-shore team

● Identified the test scenarios and estimated the number of test scripts

● Designed and reviewed test cases and test scripts

● Organized knowledge transfer sessions for new team members

● Design of SQL scripts in Green Plum DB as per the mapping document to validate data in different staging area and Target tables.

● Validation of data in Staging area data in Data capture module against the data in Source Systems using SQL Queries and excel macros.

● Validation of implementation of transformation logic from Clean tables to BDW tables and subsequent fact tables as per the mapping logic defined in mapping document by executing SQL Queries in Green plum DB.

● Validation of implementation SCD Type1 , Type2,Type3 in BDW tables.

● Interacted and understood requirement, develop test scenarios/ conditions along with test data requirements with support from Client and on-shore team

● Identified the test scenarios and estimated the number of test scripts

● Designed and reviewed test cases and test scripts

● Organized knowledge transfer sessions for new team members

● Design of SQL scripts in Green Plum DB as per the mapping document to validate data in different staging area and Target tables.

● Validation of data in Staging area data in Data capture module against the data in Source Systems using SQL Queries and excel macros.

● Validation of implementation of transformation logic from Clean tables to BDW tables and subsequent fact tables as per the mapping logic defined in mapping document by executing SQL Queries in Green plum DB.

● Validation of implementation SCD Type1 , Type2,Type3 in BDW tables.

Analyzed business requirement and prepared test strategy, test plan, and test estimation for the project Handled database testing module Designed and executed test case, test script, and reporting defects in HP QC Identifying and validation all the Parent and child integrity is maintained across DB. Performing Schema validations and smoke testing. Validations of data inserted, updated and deleted through Application UI are populated correctly in all the parent and child tables. Prepared daily and weekly status report and shared with the client

Analyzed business requirement and prepared effort estimation for the project Identified the test scenarios and designed test cases/ scripts Performed complete ETL cycle testing, extract to transform to load for various source system Performed end-to-end testing to validate complete data flow for the application

Prepared test case design and test case execution to cover the entire range of functionality Performed database migration testing for database upgrade and migration Performed ETL/ DWH testing to validate the data flow

Below are few roles

● Test Case, Test Script ,Test data preparation based on the requirement.

● Assign tasks and guide the team to overcome technical challenges.

● Loading and Validating the files in the live queue.

● Generate and Execute jobs to load data from Talend tool.

● Validation of the configuration file and setting the parameters before the job execution.

● Design of Complex Hive / Impala queries based on the transformation rules defined in the STTM document.

● Data Validation in all the Data Lake and Data Mart tables.

● Analysis of the Job error logs and identifying the root cause for the job failure.

● Design and develop Regression suite to validate the existing system whenever a new change has been implemented.

● To be a part of the Defect Triage Calls to discuss on the open defects with Development team,BA,Architect and Business Stake holders and also raise concerns of the QA team if any.