QA Engineer (SQL Testing)

Wissen Infotech; Bengaluru; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

Wissen Infotech in Bengaluru is seeking an experienced QA/Data Testing professional to develop and maintain documentation for KPI solution packages and design robust SQL-based testing to ensure data accuracy across KPI calculations and reporting dimensions.

The role emphasizes ETL testing, data validation, and working in an Agile environment, with a remote onboarding preference and alignment to IST working hours (1:30 PM to 9:30 PM).

Qualifications

• 8+ years of QA and data testing experience.
• Hands-on SQL and database testing expertise.
• Experience creating detailed test plans, scenarios, and cases.
• Strong data validation, ETL testing, and KPI/reporting validation knowledge.
• Ability to translate complex business rules into test scenarios.
• Experience working in Agile environments.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Develop and maintain documentation for KPI solution packages including business rules and data mappings.
• Design and run robust testing with optimized SQL to validate KPI calculations and data accuracy.
• Scale testing beyond single-condition validation with end-to-end methodologies.
• Identify and automate test scenarios alongside QA activities.
• Collaborate with developers and stakeholders to review requirements, align tests, and improve coverage.
• Perform root cause analysis of data discrepancies and work with cross-functional teams.
• Support onboarding and mentoring of QA resources as project scope grows.

Skills

SQL

Data testing

Test planning

Data validation

ETL testing

KPI reporting

Agile

Analytical skills

Communication

Tools

Snowflake

Python

Automation testing

Job description

Key Responsibilities

• Develop and maintain comprehensive documentation for KPI Solution Packages (SPs), including:
  • Business rules
  • Data mappings
  • Column-level definitions and logic
• Design and execute robust testing approaches using optimized SQL queries to validate:
  • KPI calculations and metrics
  • Data accuracy across all records
  • Different period types and reporting dimensions
  • Various data break scenarios
• Move beyond single-condition validation and establish scalable, end-to-end testing methodologies.
• Identify and automate suitable test scenarios in parallel with ongoing QA activities.
• Collaborate closely with developers and stakeholders to:
  • Review testing requirements
  • Align test plans
  • Improve functional and data validation coverage
• Perform root cause analysis of data discrepancies and work with cross-functional teams to resolve issues.
• Support onboarding and mentoring of additional QA resources as project scope expands.

Required Skills

• 8+ years of relevant experience in Quality Assurance and Data Testing
• Strong hands-on experience with SQL and database testing
• Experience creating and executing detailed test plans, test scenarios, and test cases
• Strong knowledge of data validation, ETL testing, and KPI/reporting validation
• Ability to analyze complex business rules and translate them into test scenarios
• Experience working in Agile development environments
• Excellent analytical, problem-solving, and communication skills

Preferred Skills

• Experience with Snowflake and Python
• Exposure to automation testing frameworks and scripting

Additional Information

• Remote opportunity with immediate onboarding preference.
• Candidates should be comfortable working during 1:30 PM to 9:30 PM IST.