ETL Tester

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. Originally posted on Himalayas