Role Overview
Employee Hub is hiring a mid-level ETL/ELT Test Engineer (Data Testing). This is a full-time hybrid role, based in Karnataka. Part of Employee Hub's Qa hiring. Full responsibilities, required qualifications, and the apply link are listed in the description below.
Resume Keywords to Include
Make sure these keywords appear in your resume to improve ATS scoring
Job Description
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
Frequently Asked Questions
How do I apply for the ETL/ELT Test Engineer (Data Testing) position at Employee Hub?
Use the Apply button above to submit your application directly to Employee Hub. Most applications take less than 5 minutes if your resume and contact details are ready, and you'll be routed to the employer's official application system to finish.
Is the ETL/ELT Test Engineer (Data Testing) role at Employee Hub remote or in-office?
This is a hybrid role based in Karnataka. Expect a mix of in-office and remote days, with the specific cadence set by the hiring manager.
What does a ETL/ELT Test Engineer (Data Testing) at Employee Hub earn?
Employee Hub has not disclosed a salary range in this posting. Many employers share specifics later in the interview process; you can also ask during a recruiter screen if compensation transparency is important to you.
When was the ETL/ELT Test Engineer (Data Testing) role at Employee Hub posted?
This role was posted on April 3, 2026 (79 days ago). It's still listed as actively hiring; we re-confirm openings against the source system multiple times per day and remove closed roles.
AI-powered job search
Get every job scored to your resume
Upload your resume and get jobs ranked, your resume tailored, and employee contacts found automatically.
Get Started FreeNo credit card to start