Job Description:
Job Description
Business Title - Lead QA (ETL Tester)
Years of Experience - Min 6 and max up to 9 Years

Job Description
The purpose of this role is to ensure the developed software meets the client requirements and the business’ quality standards within the project release cycle and established processes. To lead QA technical initiatives in order to optimize the test approach and tools.

Key Responsibilities
• Lead and execute DWH, Database, ETL, and Data Validation testing across end-to-end data pipelines.
• Analyze business and technical requirements and translate them into comprehensive test scenarios, test cases, test conditions, and test data.
• Prepare detailed test plans, test strategies, test estimates, test procedures, and expected results.
• Develop and execute complex SQL queries to validate data accuracy, completeness, consistency, transformation logic, and reconciliation.
• Perform source-to-target data validation and verify data mappings, transformations, aggregations, joins, and business rules.
• Design and execute positive, negative,



boundary, exception, and data-volume test scenarios to ensure complete test coverage.
• Perform ETL testing by validating data extraction, transformation, loading, error handling, and data integrity.
• Conduct functional, integration, system, regression, data quality, performance/load, and UAT testing as required.
• Validate data across multiple databases, data sources, staging areas, DWH layers, and reporting/analytics systems.
• Investigate data mismatches and failures using SQL and other debugging techniques, identify root causes, and document findings clearly.
• Log, prioritize, track, and manage defects through JIRA and ensure timely closure with development and technical teams.
• Perform defect retesting and regression testing after fixes and ensure issues are validated across all applicable test cycles.
• Identify data quality issues and process failures and recommend appropriate remediation stra

📌 Senior ETL Tester/ Database Tester (Pune)
🏢 dentsu
📍 Pune