ETL Tester

Datametica

3 - 6 years

5 - 12 Lacs

pune

Posted:21 hours ago| Platform:

Apply

Skills Required

dwh testing etl testing cloud testing data warehouse testing data testing database testing etl sql

Work Mode

Work from Office

Job Type

Full Time

Job Description

We are looking for an ETL Tester to ensure accuracy, reliability, and quality across enterprise data pipelines. The role involves validating ETL/ELT processes, performing data quality checks, and supporting analytics and BI initiatives.

Key Responsibilities

Perform end-to-end ETL testing for data pipelines in data warehouse/lake environments.
Validate data extraction, transformation, and loading processes across source and target systems.
Write and execute complex SQL queries for data validation and reconciliation.
Verify business rules and transformations implemented in ETL/ELT tools or orchestration frameworks (Airflow, Spark, Hive).
Conduct source-to-target mapping validation and maintain test cases and documentation.
Automate data validation tests using Python, PyTest, or frameworks like Great Expectations or dbt tests.
Support CI/CD testing using Jenkins or similar tools.
Collaborate with developers, data engineers, and analysts to troubleshoot and resolve defects.
Validate dashboards and reports in BI tools (Tableau, Power BI, Looker).

Required Skills

Strong experience in ETL/Data Warehouse testing.
Advanced SQL skills (joins, aggregations, analytical functions).
Experience with modern data platforms (cloud DW, data lakes, distributed compute engines).
Hands-on experience with Python for automation.
Understanding of data quality, reconciliation, and validation techniques.
Experience in Agile environments and use of JIRA or similar tools.

Preferred Qualifications

Experience with Airflow, Oozie, or workflow orchestration tools.
Familiarity with dbt or other transformation/testing frameworks.
Exposure to BI/reporting tools (Tableau, Power BI, Looker).
Basic understanding of data modeling and data warehouse/lake architecture.

More Jobs at Datametica

Talent Acquisition Executive

Pune

1.0 - 3.0 yrs

INR 1 - 3 Lacs

Sr. SQL DBA

Hyderabad, Pune, Bengaluru

6.0 - 11.0 yrs

INR 15 - 25 Lacs

AI/ML Lead

Pune

7.0 - 10.0 yrs

INR 15 - 30 Lacs

Senior Data Engineer

Pune, Bengaluru

5.0 - 10.0 yrs

INR 8 - 18 Lacs

Solution Architect (AI/ML Specialization)

Pune

10.0 - 18.0 yrs

INR 45 - 65 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.