ETL/ELT Test Engineer (Data Testing)

Job Title: ETL/ELT Test Engineer (Data Testing)

Experience: 4 – 8 Years

Location: Pune, Bangalore, Chennai

Work Mode: Hybrid

Work Timings: 11:00 AM – 8:00 PM IST

Job Summary

We are looking for a hands-on ETL/ELT Test Engineer with strong expertise in data validation, SQL, and Python automation. The ideal candidate should have solid experience in testing data pipelines, validating transformations, and building automated test frameworks in an Agile environment.

Key Responsibilities

✔ Perform end-to-end ETL/ELT testing including S2T reconciliation and transformation validation

✔ Validate data accuracy, completeness, and consistency across systems

✔ Design and execute regression test strategies for data pipelines

✔ Develop and maintain automation scripts using Python (Pytest)

✔ Write optimized SQL queries for large-scale data validation

✔ Analyze and troubleshoot data issues and support defect resolution

✔ Work closely with developers, data engineers, and business teams

✔ Participate in Agile ceremonies and ensure story-level validation

✔ Document test cases, results, and defects using Jira/X-Ray

Mandatory Skills

• Hands-on experience in ETL/ELT Testing
• Strong expertise in Advanced SQL (joins, CTEs, window functions, aggregations)
• Proficiency in Python Automation with Pytest
• Good understanding of ETL Architecture & Data Warehousing concepts
• Experience with Test & Defect Management tools (Jira/X-Ray)
• Exposure to Agile/Scrum methodology
• Strong hands-on execution mindset (testing + automation)

Must-Have Technical Skills

• Unix/Linux commands (navigation, logs, job validation)
• Python fundamentals (data structures, OOPs, file & DB handling, debugging)
• Pandas/DataFrames and lambda functions
• Basic cloud exposure (AWS preferred; Boto3 is a plus)
• Strong communication and documentation skills

Good to Have Skills

• Databricks and PySpark (lakehouse testing exposure)
• Cloud platforms: Snowflake, Databricks, BigQuery, Redshift, Synapse
• RDBMS: PostgreSQL, SQL Server, Oracle
• ETL tools: Informatica, DataStage, SSIS, Talend, dbt, Airflow
• Data quality tools: Great Expectations, Deequ
• CI/CD and reporting tools: Allure, JUnit XML
• API testing basics (Postman, REST validation)

Additional Requirements

✔ Strong analytical and problem-solving skills

✔ Ability to work in a fast-paced Agile environment

✔ Excellent collaboration and stakeholder communication

Job Types: Full-time, Permanent

Pay: ₹404,907.16 - ₹2,451,418.80 per year

Benefits

• Provident Fund

Application Question(s):

• Do you have 4–8 years of experience in ETL/ELT or Data Testing
• Are you comfortable working with Unix/Linux commands for log validation and job monitoring?
• Are you open to working in Pune, Bangalore, or Chennai?

Work Location: In person