● 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.

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.