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.
About UsDatavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. About the Team
Skills Required
- 8+ years experience
- Strong experience in Data QA / ETL Testing
- Hands-on experience with Snowflake
- Hands-on experience with BigQuery
- Hands-on experience with Redshift
- Hands-on experience with Azure Synapse
- Hands-on experience with Microsoft Fabric
- Excellent SQL skills (complex joins, window functions, aggregations, query optimization)
- Experience testing ETL/ELT pipelines (Airflow, DBT, Informatica, etc.)
- Strong understanding of data warehousing concepts (star/snowflake schemas)
- Knowledge of data lakes and lakehouse architectures
- API and backend testing experience
- Test automation / scripting experience (Python preferred)
- Exposure to CI/CD pipelines and DevOps practices
What We Do
A premiere data services company serving clients in North America, Datavail has 1,000 data professionals, data engineers, developers, project managers, consultants, and business experts, supported by industry-leading automation and intellectual property. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes. At Datavail, we look for more than smarts, experience and proficiency. On top of those requirements, we seek people who mesh with our corporate values. We seek brilliance without bravado and know-how without a know-it-all attitude. We hold low ego in high regard, embrace problem-solving as a passion and welcome every day as a new opportunity to learn. We’re flexible and hard working. We’re committed to our clients and colleagues. We help our people grow so they can help our clients grow. That makes us grow so we can help even more customers leverage organizational data for business value. Our Core Values: 1. We desire to serve. 2. We embody flexibility for availability 3. We exemplify low ego. 4. We work hard. 5. We strive for continuous improvement. 6. We are growth-oriented.
