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.