Roles and Responsibilities :
Design, develop, and execute comprehensive ETL tests to ensure data accuracy and integrity in the data warehouse.
Collaborate with cross-functional teams to identify requirements for current ETL processes and implement testing plans accordingly.
Develop complex SQL queries to troubleshoot issues related to data migration, transformation, and loading into the target system.
Analyze results of ETL runs to identify defects and provide recommendations for improvement.

Job Requirements
This role is primarily focused on ETL and data automation, not UI automation.
Selenium or similar tools are referenced to indicate an automation mindset; the core focus is data pipeline validation, not frontend UI testing.
Expected automation includes:
Advanced SQLbased automation (joins, aggregations, calculations, historical loads)




Sourcetotarget reconciliation and rowcount/data quality checks
Python or similar scripting for data comparison, regression checks, and orchestration
Automation across staging, warehouse, and downstream marts
Exposure to Azurebased cloud data settings
The candidate is expected to:
Design and develop ETL/data test automation
Maintain and enhance automation suites
Execute automated and manual ETL tests
Analyze results and perform root cause analysis
Clearly document defects and collaborate with stakeholders
Experience validating largescale datasets in data warehouses or analytical platforms
Familiarity with test management tools and defect tracking systems

-

📌 Senior Etl Tester Karnataka (India)
🏢 ExaThought
📍 India