Big Data Test Engineer (ETL/DWH Testing)_Immediate

Kezan Consulting; Gurugram District; Hybrid; INR 1,500,000 - 2,200,000; Full time

Job summary

Kezan Consulting in Gurugram (Hybrid) seeks a seasoned Data Quality Engineer to design and run ETL and data warehouse tests. You will validate data across source and target systems, write advanced SQL queries for reconciliation, and develop Python scripts for automation.

Collaboration with data engineers and developers is essential to resolve data quality issues. Candidates should have 5+ years in testing, UNIX/Linux fluency, REST API testing, and experience with cloud platforms (AWS/Azure/GCP).

Qualifications

• 5+ years of experience in ETL and data testing
• Hands-on with Data Warehouse testing and data validation
• Proficient in Python for test automation
• Strong SQL (advanced) and data reconciliation
• Experience with UNIX/Linux environments
• Experience with REST API testing and automation
• Familiarity with Jira and Git for defect tracking and version control
• Exposure to cloud data services (AWS/Azure/GCP) preferred
• Knowledge of ETL tooling like Informatica, Talend, SSIS, ADF, or Glue
• Ability to design, implement and execute end-to-end test plans for data platforms

Responsibilities

• Design and execute test cases for ETL pipelines and Data Warehouse solutions.
• Validate data accuracy, completeness, and integrity across source and target systems.
• Write complex SQL queries for data validation and reconciliation.
• Develop Python scripts for test automation and data verification.
• Perform functional, regression, integration, and end-to-end testing.
• Collaborate with Data Engineers and Developers to resolve data quality issues.
• Work with ETL tools and databases like Snowflake, Oracle, SQL Server, PostgreSQL, or Redshift.

Skills

ETL Testing

Data Warehouse Testing

Python

SQL Advanced

Database Testing

Data Validation

BI/Analytics Testing

UNIX/Linux

REST API Testing

Test Automation

Jira

Git

Cloud Platforms

Tools

Informatica

Talend

SSIS

ADF

AWS Glue

Job description

Experience: 5+ Years
Location: Gurugram (Hybrid)

Required Skills:

• ETL Testing
• Data Warehouse (DWH) Testing
• Python
• SQL (Advanced)
• Database Testing
• Data Validation & Reconciliation
• BI/Data Analytics Testing
• UNIX/Linux
• REST API Testing
• Test Automation (PyTest/Robot Framework Good to Have)
• Jira, Git
• Cloud Platforms (AWS/Azure/GCP Good to Have)

Responsibilities:

• Design and execute test cases for ETL pipelines and Data Warehouse solutions.
• Validate data accuracy, completeness, and integrity across source and target systems.
• Write complex SQL queries for data validation and reconciliation.
• Develop Python scripts for test automation and data verification.
• Perform functional, regression, integration, and end-to-end testing.
• Collaborate with Data Engineers and Developers to resolve data quality issues.
• Work with ETL tools such as Informatica, Talend, SSIS, ADF, or AWS Glue and databases like Snowflake, Oracle, SQL Server, PostgreSQL, or Redshift.