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 environments
- 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)
🏢 ExaThought
📍 Karnataka