Job Closed
This listing is no longer active.
Helping people thrive in a connected world.
Lead IT QA Analyst
Location
India
Posted
59 days ago
Salary
0
Seniority
Senior
Job Description
Lead IT QA Analyst
Assurant
• Validate enterprise BI solutions aligned to Kimball dimensional modeling • Work with business teams to confirm business rules, acceptance criteria, KPIs, and reconciliation logic for BI/analytics outputs • Perform end to end QA across ingestion → transformation → semantic layer → reporting/consumption • Analyze TPA client files and record variances • Define QA standards, guidelines, and best practices for analytics engineering and reporting teams • Use AI tools to build test cases, test data and testing plans wherever applicable • Create and maintain test frameworks for: Data correctness, Business rule validation, Regression testing, Data reconciliation • Automate QA activities wherever possible to reduce manual effort and improve release velocity • Validate Databricks pipelines and SQL transformations • Perform QA of ETL/ELT patterns and validate SQL Server objects • Execute performance testing and recommend strategies to improve platform performance • Provide support for production execution and delivery of BI/analytics solutions • Maintain accurate and complete QA documentation and ensure adherence to corporate policies • Mentor team members on QA methods, automation, and data validation patterns
Job Requirements
- Validate enterprise BI solutions aligned to Kimball dimensional modeling (facts, dimensions, conformed dimensions, SCD handling)
- Work with business teams to confirm business rules, acceptance criteria, KPIs, and reconciliation logic for BI/analytics outputs
- Perform end to end QA across ingestion → transformation → semantic layer → reporting/consumption
- Analyze TPA client files and record variances
- Define QA standards, guidelines, and best practices for analytics engineering and reporting teams
- Use AI tools to build test cases, test data and testing plans wherever applicable
- Create and maintain test frameworks for: Data correctness (row counts, aggregates, null handling, duplicates), Business rule validation (KPI logic, exclusions, thresholds), Regression testing (pipeline and reporting changes), Data reconciliation (source to target, cross system checks)
- Automate QA activities wherever possible to reduce manual effort and improve release velocity
- Validate Databricks pipelines (Delta tables, notebooks, jobs, workflows) and SQL transformations (Spark SQL / T-SQL)
- Perform QA of ETL/ELT patterns including incremental loads, CDC patterns, and partitioning strategies
- Validate SQL Server objects such as stored procedures, views, tables, indexing strategies, and job schedules where applicable
- Execute performance testing for Databricks jobs and SQL Server queries (query tuning, indexing suggestions, cluster sizing guidance)
- Recommend strategies to improve platform performance, cost efficiency, and workload stability
- Provide support for production execution and delivery of BI/analytics solutions
- Support platform upgrades and migrations (Databricks runtime upgrades, cluster policies, SQL Server version changes) in dev/test, including QA sign off and documentation
- Maintain accurate and complete QA documentation: test plans, test evidence, defect logs, reconciliation results
- Ensure adherence to corporate policies, governance, and established practices
- Mentor team members on QA methods, automation, and data validation patterns
Benefits
- N/A
Related Guides
Related Categories
Related Job Pages
More QA Engineer Jobs
Agreement Type: 3-6 Month Contract Location: Remote (UAE Hours) Whiteshield is a global advisory firm helping governments navigate big, world-shaping challenges - from economic transformation to education, employment, and innovation. We work at the intersection of policy, data, and technology, building products that don’t just inform decisions, but improve lives. If you’re motivated by impact and purpose - Whiteshield is for you. WHAT YOU’LL OWN • Develop, maintain, and execute test cases for functional, regression, integration, UAT, and automation testing. • Perform thorough manual and automation testing on web applications covering UI, functional, responsiveness, and end-to-end scenarios. • Contribute towards Designing, implementing and maintaining automation scripts for regression and smoke testing using industry-standard tools (e.g., Selenium, Playwright). • Document test results, report bugs, and track them to closure using JIRA. • Collaborate with product and engineering teams to clarify requirements, identify edge cases, and ensure optimal test coverage. • Contribute to test planning, estimation, and execution in alignment with Agile/Scrum workflows. • Participate in release validation, post-release testing, and continuous integration pipelines.
Agreement Type: 3-6 Month Contract Location: Remote (UAE Hours) Whiteshield is a global advisory firm helping governments navigate big, world-shaping challenges - from economic transformation to education, employment, and innovation. We work at the intersection of policy, data, and technology, building products that don’t just inform decisions, but improve lives. If you’re motivated by impact and purpose - Whiteshield is for you. WHAT YOU’LL OWN • Develop, maintain, and execute test cases for functional, regression, integration, UAT, and automation testing. • Perform thorough manual and automation testing on web applications covering UI, functional, responsiveness, and end-to-end scenarios. • Contribute towards Designing, implementing and maintaining automation scripts for regression and smoke testing using industry-standard tools (e.g., Selenium, Playwright). • Document test results, report bugs, and track them to closure using JIRA. • Collaborate with product and engineering teams to clarify requirements, identify edge cases, and ensure optimal test coverage. • Contribute to test planning, estimation, and execution in alignment with Agile/Scrum workflows. • Participate in release validation, post-release testing, and continuous integration pipelines.
Agreement Type: 3-6 Month Contract Location: Remote (UAE Hours) Whiteshield is a global advisory firm helping governments navigate big, world-shaping challenges - from economic transformation to education, employment, and innovation. We work at the intersection of policy, data, and technology, building products that don’t just inform decisions, but improve lives. If you’re motivated by impact and purpose - Whiteshield is for you. WHAT YOU’LL OWN • Develop, maintain, and execute test cases for functional, regression, integration, UAT, and automation testing. • Perform thorough manual and automation testing on web applications covering UI, functional, responsiveness, and end-to-end scenarios. • Contribute towards Designing, implementing and maintaining automation scripts for regression and smoke testing using industry-standard tools (e.g., Selenium, Playwright). • Document test results, report bugs, and track them to closure using JIRA. • Collaborate with product and engineering teams to clarify requirements, identify edge cases, and ensure optimal test coverage. • Contribute to test planning, estimation, and execution in alignment with Agile/Scrum workflows. • Participate in release validation, post-release testing, and continuous integration pipelines.
Agreement Type: 3-6 Month Contract Location: Remote (UAE Hours) Whiteshield is a global advisory firm helping governments navigate big, world-shaping challenges - from economic transformation to education, employment, and innovation. We work at the intersection of policy, data, and technology, building products that don’t just inform decisions, but improve lives. If you’re motivated by impact and purpose - Whiteshield is for you. WHAT YOU’LL OWN • Develop, maintain, and execute test cases for functional, regression, integration, UAT, and automation testing. • Perform thorough manual and automation testing on web applications covering UI, functional, responsiveness, and end-to-end scenarios. • Contribute towards Designing, implementing and maintaining automation scripts for regression and smoke testing using industry-standard tools (e.g., Selenium, Playwright). • Document test results, report bugs, and track them to closure using JIRA. • Collaborate with product and engineering teams to clarify requirements, identify edge cases, and ensure optimal test coverage. • Contribute to test planning, estimation, and execution in alignment with Agile/Scrum workflows. • Participate in release validation, post-release testing, and continuous integration pipelines.
