Title: Senior ETL Tester
Location: Mumbai/Hyderabad/Bengaluru
Exp: 8+ Years
Remote
Primary Skills:
Strong experience in Data QA / ETL Testing (6+ years preferred).
Hands-on experience with modern cloud data warehouses, such as:
Snowflake
BigQuery
Redshift
Azure Synapse
Microsoft Fabric
Excellent SQL skills (must-have):
Complex joins, window functions, aggregations
Query optimization and performance tuning
Experience testing ETL/ELT pipelines (e.g., using Airflow, DBT, Informatica, etc.).
Strong understanding of:
Data warehousing concepts (Star/Snowflake schemas)
Data lakes and lakehouse architectures
Experience with API and backend testing is a plus.
Familiarity with test automation tools or scripting (Python preferred).
Exposure to CI/CD pipelines and DevOps practices is desirable.
Job Description:
Design and execute end-to-end data validation strategies for ETL/ELT pipelines.
Validate data accuracy, completeness, and integrity across cloud data warehouses.
Develop and optimize complex SQL queries for data validation and analysis.
Perform functional, regression, and integration testing for data workflows.
Collaborate with data engineers, analysts, and product teams to understand business rules and data transformations.
Build and maintain automated test frameworks for data validation.
Ensure adherence to data quality standards and governance policies.
Identify defects, track issues, and ensure timely resolution.
Mentor junior QA engineers and drive QA best practices.
Datavail is an enterprise IT services company specializing in cloud, data, and application expertise. The company helps organizations transition from traditional IT environments to modern, AI-enabled enterprises by delivering outcomes in uptime, speed, modernization, cost efficiency, and AI readiness. Datavail offers comprehensive services across analytics, AI/ML, database management, cloud migration and strategy, application management, and Oracle applications implementation. The company is an AWS Advanced Tier Services Partner and focuses on deploying AI responsibly with governance and measurable ROI, serving industries including insurance and packaged goods.
