QA Engineer / Only (W2)

We are looking for a QA engineer with below :

• 10 years of experience as QA Engineer working with Data engineering projects Onprem and cloud.
• Hands on experience in scripting & ability to write complex SQL queries to perform data analysis, QA Test scripts and Execution.
• Experience with and understanding of different ETL tools. Tools experience preferred : SAP-BODS, informatica IICS and AWS experience.
• Experience working with large data sets.
• Strong organizational skills and detail-oriented mindset.
• QA Automation in Data engineering side.
• 4 years of working experience with regulatory domains like CCAR, LFI, CECL, IFRS9, ALLL or equivalent.
• Coordinating and working along with Offshore resources.

Expectations from this role :

Create and Organize testing process based on project requirement and manage test activities within team, for the following

1. Test Estimates and Schedules-. Ensure Test Coverage

2. Produce test results, defect reports, test logs, and reports to evidence for testing

3. Publish RCA reports and preventive measures

4. Ensure Quality of Deliverables

5. Report project metrics and status

6. Ensure adherence of Engineering practices, processes and standards

7. Understand and contribute to test automation / performance testing

8. Work with DevOps team, when required; to understand testing framework and QA process for implementing continuous testing

Typical performance measures :

1. Test Script Creation and Execution Productivity

2. Defect Leakage Metrics (% of defect leaked, % of UAT defects and % of Production defects)

3. % of Test case reuse

4.Test execution Coverage

5. Defect Acceptance Ratio

6.Test Review efficiency

7. On-time delivery, Effort Variance

8. Test Automation Coverage

Performance Areas :

Supporting Organization :

Ensure utilization and quality of deliverables prepared by the team

Co-ordinate Test Environment and Test Data provisioning

Test Design, Development, Execution :

Participate in review, walkthrough, demo and obtain sign off by stakeholder

Prepare Test Summary Report for modules / features

Requirements Management :

Analyse, Prioritize, Identify Gaps; create workflow diagrams based on Requirements / User stories

Manage Project :

Participate in Test management

Preparing, Tracking and Reporting of Test progress based on schedule

Domain relevance :

Identify business processes, conduct risk analysis and ensure test coverage

Estimate :

Prepare Estimate, Schedule, Identify dependencies

Knowledge Management :

Consume, Contribute, Review (Best Practices, Lesson learned, Retrospective)

Test Design, Execution :

Test Plan preparation, Test Case / Script Creation, Test Execution

Risk Identification :

Identification of risk / issues and prepare Mitigation and Contingency plans

Test & Defect Management :

Conduct root cause and trend analysis of the defects

Test Planning :

Identify the test scenarios with understanding of systems, interfaces and application

Identify end-to-end business critical scenarios with less support Create and review the test scenarios and prepare RTM

Prepare estimates (time / effort) based on the requirements / User stories

Identify scope of testing

Client Management :

Define KPIs to the engagement and ensure adherence to these KPIs.

Stakeholder Connect :

Handle monthly / weekly governance calls and represent issues for the team

Skill Examples :

1. Ability to Create, Review and manage a test plan

2. Ability to prepare schedules based on estimates

3. Ability to track, report progress and take corrective measures on need basis

4. Ability to identify test scenarios and prepare RTM

5. Ability to analyze requirement / user stories and prioritize testing

6. Ability to carry out RCA

7. Ability to capture and report metrics

8. Ability to identify Test Data and Test Env. Specifications

Knowledge Examples :

1. Knowledge of Estimation techniques

2. Knowledge of Testing standards

3. Knowledge of identifying the scope of testing

4. Knowledge of RCA Techniques

5. Knowledge of Test design techniques

6. Knowledge of Test methodologies

7. Knowledge of scope identification and planning

8. Knowledge of Test automation tools and frameworks