Bigdata Validation Tester

**Not Applicable**

**Qualification**:
Bachelors in science, engineering or equivalent
**Responsibility**:
**Knowledge Transition**:

- Understand and analyze business requirements based on the review of documents (functional specifications document, technical specification documents etc) as received from client / onsite.
- Participate in KT calls to understand the requirements.
- Prepare and share query log (tracker) to track queries.
- Followup to ensure resolution of queries as documented in the query log.
- Seek signoff from the client.

**Test Requirements Study**:

- Participate in the requirement walkthrough session conducted by Sr Test Analyst and identify the gaps in the requirement, Seek clarification on requirements from the Test Lead if required.
- Seek clarification on requirement and update the clarification tracker with the same.
- Identify the preliminary test data requirements.
- Provide inputs to the test manager/test lead on the scope of testing, analyst effort estimate for the total volume of work, requirement analysis and clarification, test approach etc.

**Test Planning**:

- Provide inputs for test plan creation including number of test scenarios and test cases used for estimation of the test cycles /schedule, dependencies etcin addition to the other dependencies from various teams like environment availability, third party interfaces and test data etc.
- Provide inputs to the Test Lead/ Sr Test Analyst on test tool evaluation if required.
- Conduct POC to analyze the feasibility of the tool / approach and share the findings with the lead to finalize the approach.

**Test Design**:

- Identify testable scenarios (test scenario document).
- Track resolutions through query log.
- Seek review from Sr Test Analyst/ Test Lead at offshore.
- Post changes seek sign off from the BA (~SME Role).
- Create / update the Requirements traceability matrix with test scenarios.
- Identify test cases for automation and seek sign off from customer.
- Partner with the Sr Test Analyst to design test data requests/requirement and share the same with the test lead.
- Design SQL scripts.
- Seek review inputs on the test scenarios.
- Seek sign off on test cases and upload them in QC.
- Gather information from the stakeholders on ETL data mapping documents, ETL design documents and create SQL scripts basis review of the documents, Design automated script to execute the test cases.

**Test Development**:

- Based on signed off test scenarios, identify test data.
- Create test cases based on the understanding of the requirements.
- If using Quality Centre (Test Management Tool), ensure follow up on the processes and rules to be followed during developments.
- If using Excel, the test cases are written in such a manner that they can be uploaded on to QC for ease in reuse.
- Create/Update the RTM if applicable and Query log with test cases and test data.
- Modify the existing regression scenarios based on the impact of changes.

**Test Execution/Functional Testing**:

- Conduct smoke testing to ensure system readiness for testing.
- Execute automation test scripts/manual test cases post the same.
- Record and maintain testing evidences and track execution status of assigned test cases.
- Share findings with the Senior Test Analyst.
- Identify defects and log failures.
- Track defects (defect log as generated from the QC tool) to closure.
- Participate in the defect triages to gather evidence for defect identification on periodic basis for defect prioritization and fix.
- Retest the defect and update the status.
- Conduct acceptance testing, if required.
- Track # of test cases executed as part of the daily tracker to ensure productivity.
- Provide deployment and post production support if required.
- Provide inputs to Sr Test Analyst on the test cases execution for test summary report.
- Identify the test suite for execution, if required.
- Track defect metrics to ensure testing effectiveness as generated by QC tool.

**Production Support QA / Production Validation**:

- Partner with the Sr Test Analyst to identify the known issues and track it in the known issue tracker.
- Conduct training for the new users if required.
- Participate in knowledge transition from incumbent or development stakeholders.
- Conduct regression testing to approve production fix release etc.

**Delivery Management**:

- Provide inputs on the test execution metrics to the Test Lead.

**Knowledge Management**:
**Must Have Skills**
- BigData Validation
- ANSI SQL

**Good To Have Skills**
- Hive
- Apache Hadoop

**Technical Skills**

**SNo**

**Primary Skill**

**Proficiency Level **

**Rqrd./Dsrd.**
- 1- BigData Validation- PL1- Required- 2- Hive- PL2- Desired- 3- Apache Hadoop- PL1- Desired- 4- ANSI SQL- PL2- Required- **Proficiency Legends**

**Proficiency Level**

**Generic Reference**
- PL1- The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.- PL2-
-