ETL Tester

Ascendion; Maharashtra; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Ascendion is seeking an experienced ETL Tester to validate data integration, ETL pipelines and data warehouse solutions in Pune or Gurgaon. You will ensure data accuracy, completeness, and consistency across source and target systems while collaborating with ETL developers and data engineers.

The role requires 4+ years of ETL testing experience, strong SQL skills, and Databricks exposure. You will design test plans, execute tests, perform data reconciliation, and support UAT and production

Qualifications

• 4+ years of ETL testing experience.
• Strong SQL skills for backend validation.
• Experience with data warehouses and ETL pipelines.
• Familiarity with Databricks a plus.

Responsibilities

• Design, develop and execute ETL test plans and cases.
• Validate data extraction, transformation and loading processes.
• Perform source-to-target data validation and reconciliation.
• Write complex SQL queries for data verification.
• Collaborate with ETL developers and data engineers to resolve defects.
• Prepare test summary reports and support UAT/production validation.

Skills

ETL testing

SQL

Data validation

Databricks

Education

Bachelor's degree in CS/IS

Tools

Databricks

Defect tracking tools

Job description

About Ascendion

Ascendion is a leader in AI-Native platform driven software engineering company that underwrites outcomes, helping businesses innovate faster, smarter, and with greater impact. We partner with Global 2000 clients across North America, UK, Europe, and APAC to solve complex challenges in data, experience design, software product engineering, and workforce transformation. Powered by expert engineers, thousands of AI agents, and our Engineering to the Power of AI™ (EngineeringAI) method, we deliver measurable outcomes that build trust, unlock value, and accelerate growth. Learn more at ascendion.com

About Ascendion

Ascendion is a leader in AI-Native platform driven software engineering company that underwrites outcomes, helping businesses innovate faster, smarter, and with greater impact. We partner with Global 2000 clients across North America, UK, Europe, and APAC to solve complex challenges in data, experience design, software product engineering, and workforce transformation. Powered by expert engineers, thousands of AI agents, and our Engineering to the Power of AI™ (EngineeringAI) method, we deliver measurable outcomes that build trust, unlock value, and accelerate growth. Learn more at ascendion.com

Ascendion | Engineering to elevate life

We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:

• Build the coolest tech for world's leading brands
• Solve complex problems – and learn new skills
• Experience the power of transforming digital engineering for Fortune 500 clients
• Master your craft with leading training programs and hands-on experience

Experience a community of change makers!

Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

About The Role

We are looking for an experienced ETL Tester with 4+ years of expertise in validating data integration, ETL pipelines, and data warehouse solutions. The ideal candidate will be responsible for ensuring data accuracy, completeness, and consistency across source and target systems while working closely with ETL developers, business analysts, and data engineers.

Job Title: ETL DATABRICKS TESTER

Key Responsibilities

• Design, develop, and execute ETL test plans, test cases, and test scripts.
• Validate ETL workflows for data extraction, transformation, and loading.
• Perform source-to-target data validation and reconciliation.
• Verify data quality, integrity, consistency, and completeness across systems.
• Write and execute complex SQL queries for backend database validation.
• Test data warehouse, data mart, and reporting solutions.
• Execute Functional, Integration, Regression, Smoke, and System Testing.
• Validate business rules, data transformations, and mapping documents.
• Identify, log, track, and verify defects using defect management tools.
• Collaborate with ETL developers, data engineers, and business stakeholders to resolve issues.
• Validate scheduled ETL jobs and monitor execution logs.
• Participate in requirement analysis, test estimation, and test planning activities.
• Prepare test summary reports and maintain testing documentation.
• Support User Acceptance Testing (UAT) and production validation.
• Ensure adherence to quality standards and best testing practices throughout the project lifecycle.

Minimum Qualifications

Desired Qualifications (Optional):

Location:

PUNE/ GURGAON

Want to change the world? Let us know.

Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let's talk!