Lead Quality Assurance Engineer

Team: Quality Assurance

Location: Pune, Maharashtra

Commitment: Full-time

Workplace Type: onsite

Key Responsibilities

Analytics Testing

• Perform hands-on testing of Tableau Superset dashboards, reports, and analytics capabilities.
• Validate dashboard data against underlying databases, data warehouses, and source systems.
• Validate Tableau Superset filters, parameters, calculated fields, dimensions, measures, aggregations, and drill-down functionality.
• Verify that reports accurately represent underlying business data and reporting requirements.
• Validate dashboards across different datasets and business scenarios.
• Identify and troubleshoot discrepancies between Tableau Superset reports and underlying data.

KPI & Data Validation

• Understand business KPIs, metrics, calculations, and reporting definitions.
• Independently translate KPI definitions and business rules into SQL validation queries.
• Write complex SQL queries to validate metrics displayed in reports and dashboards.
• Validate calculations including counts, sums, averages, percentages, ratios, trends, and period-over-period metrics.
• Perform data reconciliation between source systems, data warehouses, and reporting layers.
• Validate data for accuracy, completeness, consistency, uniqueness, and integrity.
• Work closely with Product and Analytics teams to ensure KPI definitions and acceptance criteria are clear, measurable, and testable.

ETL / ELT & Data Pipeline Validation

• Perform end-to-end ETL/ELT testing and data validation.
• Validate data across source → staging → transformation → warehouse → reporting layers.
• Validate source-to-target mappings and transformation/business rules.
• Verify full loads, incremental loads, historical data loads, and data refresh processes.
• Validate handling of null values, duplicates, missing records, incorrect mappings, and data-type issues.
• Perform reconciliation of large datasets across different stages of the data pipeline.
• Troubleshoot data discrepancies and identify the stage at which data quality issues are introduced.
• Validate data pipeline failure, retry, and recovery scenarios.

Test Automation & Quality Engineering

• Design and implement comprehensive test strategies for analytics, reporting, data pipelines, APIs, and application functionality.
• Develop and maintain automated tests for data validation, API testing, and regression testing.
• Automate repetitive SQL and data-validation scenarios.
• Build reusable automation frameworks and quality-validation utilities.
• Integrate automated tests and quality checks into CI/CD pipelines.
• Continuously improve regression coverage and reduce dependency on manual testing.
• Perform root-cause analysis for production and customer-reported issues.
• Drive a quality engineering and defect-prevention mindset throughout the development lifecycle.

AI-Assisted Quality Engineering

• Use AI-assisted engineering tools as part of day-to-day work.
• Leverage AI to accelerate:
  • Test-case and test-scenario creation
  • Automation script development
  • API test creation
  • Test-data generation
  • Log analysis and troubleshooting
  • Identify opportunities to introduce AI-driven automation into existing Quality Engineering processes.
  • Continuously evaluate new AI tools and techniques that can improve quality, test coverage, and engineering productivity.