Location Pune, Bangalore, Chennai

Mode Hybrid; (11 AM- 8 PM)

Experience Min. 4 - 7 Years

Notice Period Immediate to 15 days

Industry : IT

Required Skills :

Hands-on ETL/ELT testing with strong SQL (joins, CTEs, window functions), Python automation (Pytest), solid DWH/ETL concepts, Unix basics, and Agile-based test execution mindset.

Job Summary

We are looking for a highly skilled ETL/ELT Test Automation Engineer with strong hands-on experience in data testing and automation.

The ideal candidate should have expertise in validating complex data transformations, building scalable automation frameworks using Python, and working within Agile environments. This role demands a hands-on contributor who actively executes testing and builds robust automation solutions.

Key Responsibilities

- Perform end-to-end ETL/ELT testing, including

- Source-to-Target (S2T) reconciliation

- Data transformation validation

- Data reconciliation and regression testing strategy

- Develop and maintain automation frameworks using Python and Pytest for data validation

- Write advanced SQL queries for large datasets, including joins, CTEs, window functions, and aggregations

- Validate data pipelines and warehouse layers (staging, ODS, DWH) ensuring data quality and integrity

- Collaborate in Agile/Scrum teams, validate acceptance criteria, and support sprint deliverables

- Manage test cases, execution, and defects using tools like Jira/X-Ray

- Analyze logs, troubleshoot issues, and support operational validation using Unix/Linux commands

- Communicate data issues effectively to both technical and non-technical stakeholders

Mandatory Skills

- Strong hands-on experience in ETL/ELT Testing

- Advanced SQL expertise (joins, CTEs, window functions, performance tuning)

- Proficiency in Python Automation with Pytest

- Solid understanding of ETL architecture and Data Warehousing concepts

- Experience with test and defect management tools (Jira/X-Ray)

- Working experience in Agile/Scrum methodologies

- Strong hands-on approach to testing and automation

Must-Have Skills :

- Good knowledge of Unix/Linux commands (log analysis, job validation, navigation)

- Strong fundamentals in Python (OOPs, data structures, file & DB handling, debugging)

- Experience with Pandas/DataFrames and lambda functions

- Basic exposure to cloud platforms (AWS preferred; Boto3 is a plus)

- Excellent communication and documentation skills

Good to Have :

- Experience with Databricks and PySpark (lakehouse testing)

- Exposure to cloud data platforms like Snowflake, BigQuery, Redshift, Synapse

- Knowledge of RDBMS (PostgreSQL, SQL Server, Oracle)

- Familiarity with ETL tools such as Informatica, DataStage, SSIS, Talend, dbt, Airflow

- Experience with data quality tools (Great Expectations, Deequ)

- Understanding of metadata and data lineage concepts

- Exposure to CI/CD tools (Allure, JUnit XML, release management)

- Basic API testing knowledge (Postman, REST validation)