Job description
Job Description:Job Description: Deputy manager QA
Unique Job Role
Deputy Manager -QA
Function
Digital
Reporting to
Manager – QA
Business
All
Grade
L5
Date
16-Nov-2023
Job Details
Responsible for developing and maintaining QA processes and documentation.
This includes writing test plans, and test cases, and documenting testing on individual tickets.
This also includes developing automated tests and qa tools to help facilitate testing.
Should have expertise in AWS platforms (RedShift, S3, Lambda APIs), RDBMS concepts, data warehousing, and agile concepts and have strong hands-on experience in SQL.
External Interfaces
Internal Interfaces
• Qualitest
• Empower sys / Aliment
• Tableau India Pvt Ltd
• Alpharithm
• CRG
• AWS
• SAP
• IBM
• Google
• Technical consultants of BI
• Functional consultants / Business Analysts
• Business users
• Testing Team
• Development Team
Job Requirements
Education
· Engineering/MCA Graduation
Relevant Experience
· 5+ Years
Behavioural Skills
• Good Communication & Interpersonal skills
• Excellent Analytical skills- Problem solving/troubleshooting.
• Excellent Team player-Able to complete projects independently as well as within a team environment.
• Creatively think outside the box to identify potential problems and increase coverage for testing framework.
Knowledge
• Strong Technical knowledge of SQL .
• Knowledge on Data Warehousing, and dimensional modelling.
Would be added advantage.
• Good Knowledge on ETL testing concepts would be an added advantage.
• Good experience in client/server testing, Functional testing, Regression testing, Re-testing, Smoke testing, Integration testing, User acceptance testing,
• Good knowledge Web-based application testing and mobile application testing is added advantage.
• Understand client requirements & functional specifications.
• Strong experience in SDLC (Software Development Life Cycle) and
• Knowledge of QA testing methodologies, concepts, processes, and documentation.
• Knowledge of API testing and DB testing along with performance testing would be an added advantage .
Process Contributions
Process Contribution
Process Outcome
Performance Measure
Collaboration with stake holders
Participate in user/Project requirements.
Collecting the required information’s.
Understanding the SLA for the performance of Dashboard performance/Jobs in ETL/ API response.
Understanding the reference reports which are currently used by Business users
1.
Understand the Overall Objective Identifying the risks anticipated
2.
Devising the right Test strategy
3.
Arriving the lead-time and effort estimates for Testing.
4.
List the reference reports from source which needs to be used for validation purpose
1.
Delivery as per the agreed SLA
2.
UAT acceptance percentage
3.
UAT signoff from the user/Functional Team
4.
User feedback on Numbers mismatch
Digital: Improvements
1.
Automation/Agile testing review
2.
Defect reduction based on Analysis
3.
Important areas/process which needs focus to improve Robustness
4.
Optimisation of performance in ETL jobs/view Queries/Dashboard
5.
Integrity of Outputs in terms of Completeness, Accuracy, Consistency
· Modification of Process
· Identifying the RCA for Issue
· Arriving in usage of the right quality Techniques and Analysis Methodology
· Identifying high defect contributors.
· Identifying the ETL job/ queries/ Dashboards where performance are bad or inconsistent or not acceptable
· Reduction in Testing Lead times
· Number of Repetitive defects eliminated.
· Number of processes optimized made robust.
· Number of Improvements done
Digital: Testing & Communication
1.
Testing methodologies /Templates and acceptance criteria for various streams such as ETL/ EDW/Dashboards/Downstream
2.
Traceability Matrix and the Test criteria design ( to connect user requirement to the all related data flow – ETL/EDW/Dashboards or Downstream
3.
Adequacy of functional spec and technical spec to ensure required information is available for testing
4.
Test data for adequacy and reliability Testing
5.
Version Management Process
6.
PII data
7.
Prepare of Testing Results
8.
Prepare defect Analysis Report
9.
Prepare on Improvement Report
10.
Prepare Validation Reports
· Test plan, Test scenarios, Test cases, Test scripts
· Mapping document of traceability.
· Test documents
· Adequacy of documentation
· Source of Test data and criteria for selection of Test data.
· Procedure and approval of code/configuration movement across landscape.
· Having the SOP defining the checks and controls to handle PII data
· Testing results/status wrt Project
· Summary Report on Defect status/RCA/Action taken/plan and areas of concern if any
· Monthly report on Improvements carried out
· Validation reports for data integrity and variance in production deployed dashboards wrt reference reports
· FTA %
· Number of issues identified during UAT/Production
· CSS
· Alignment to Policy/SOP for PII
· On time circulation of Reports as per the agreed frequency
Digital: Validate (Regular Production Jobs)
1.
Validation plan and Methodology to ensure the regular outputs (BAU) in Production is error/defect free
2.
Validate the queries in ETL/EDW/Dashboards to ensure the output will provide the desired results
· Testing results match users/reference reports
· Code walkthrough and feedback to Technical/Functional Team
· User feedback on inconsistency of Numbers
Required Skill Profession
Operations Specialties Managers