Databricks Tester (Data Validation)

Stefanini; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

Stefanini is seeking a Databricks Tester with 3-5 years of experience to validate data pipelines and Databricks Delta tables. You will ensure data accuracy, completeness, and consistency, executing SQL queries and working with Data Engineers to resolve issues.

The role involves end-to-end testing of data pipelines, regression and integration testing, and active participation in Agile ceremonies. Strong SQL, Databricks, and JIRA skills are essential for success.

Qualifications

• 3–5 years of experience in Data Testing, ETL Testing, or Data Validation.
• Hands-on experience with Databricks and Delta Lake.
• Strong proficiency in SQL for data validation and reconciliation.
• Experience validating ETL/ELT pipelines and data transformations.
• Knowledge of Spark SQL and Databricks notebooks.
• Experience with JIRA for defect tracking and test management.
• Understanding of data warehousing concepts and relational databases.
• Experience working in Agile/Scrum environments.
• Strong analytical, troubleshooting, and communication skills.

Responsibilities

• Validate data in Databricks Delta tables across Bronze, Silver, and Gold layers.
• Perform source-to-target data validation and reconciliation.
• Verify data transformations, business rules, and aggregation logic.
• Execute SQL queries to validate data accuracy, completeness, consistency, and integrity.
• Validate schemas, data types, null values, duplicate records, and primary key constraints.
• Perform regression, integration, and end-to-end testing for data pipelines.
• Create, execute, and maintain test cases and test scenarios based on business requirements.
• Log, track, and manage defects using JIRA, and work closely with Data Engineers to resolve issues.
• Participate in Agile ceremonies, including sprint planning, daily stand-ups, and retrospectives.
• Prepare test execution reports and communicate testing status to stakeholders.

Skills

Data Testing

ETL Testing

Data Validation

Databricks

Delta Lake

SQL

Spark SQL

JIRA

Agile/Scrum

Data Warehousing

Tools

Azure Databricks

Azure DevOps

Git

Databricks Notebooks

Job description

Key Responsibilities

Job Summary

We are looking for a Databricks Tester with 3-5 years of experience in data testing and validation. The ideal candidate should have hands‑on experience validating data pipelines and Databricks Delta tables, ensuring data accuracy, completeness, and consistency. The role requires strong SQL skills, experience with Databricks, and proficiency in defect management using JIRA.

Key Responsibilities

• Validate data in Databricks Delta tables across Bronze, Silver, and Gold layers.
• Perform source-to-target data validation and reconciliation.
• Verify data transformations, business rules, and aggregation logic.
• Execute SQL queries to validate data accuracy, completeness, consistency, and integrity.
• Validate schemas, data types, null values, duplicate records, and primary key constraints.
• Perform regression, integration, and end‑to‑end testing for data pipelines.
• Create, execute, and maintain test cases and test scenarios based on business requirements.
• Log, track, and manage defects using JIRA, and work closely with Data Engineers to resolve issues.
• Participate in Agile ceremonies, including sprint planning, daily stand‑ups, and retrospectives.
• Prepare test execution reports and communicate testing status to stakeholders.Role & responsibilities

Preferred candidate profile

Required Skills

• 3-5 years of experience in Data Testing, ETL Testing, or Data Validation.
• Hands‑on experience with Databricks and Delta Lake.
• Strong proficiency in SQL for data validation and reconciliation.
• Experience validating ETL/ELT pipelines and data transformations.
• Knowledge of Spark SQL and Databricks notebooks.
• Experience with JIRA for defect tracking and test management.
• Understanding of data warehousing concepts and relational databases.
• Experience working in Agile/Scrum environments.
• Strong analytical, troubleshooting, and communication skills.

Preferred Skills

• Basic knowledge of PySpark and Python
• Experience with Azure Databricks.
• Experience with ETL testing.
• Exposure to Azure DevOps or Git for version control.
• Familiarity with data quality frameworks and test automation tools.

Core Validation Activities

• Source-to-target reconciliation
• Row count and record count validation
• Schema and data type validation
• Null, duplicate, and uniqueness checks
• Business rule validation
• Incremental and full load validation
• Delta table validation
• End‑to‑end data pipeline testing
• Defect logging and tracking using JIRA