Data Test Engineer - SQL, Python, ETL & Data Warehouse Testing

WNS Global Services Pvt Ltd; Bengaluru; On-site; INR 1,200,000 - 2,200,000; Full time

Benefits offered by this job

Free HMO coverage from Day 1

WNS Cares Foundation

Structured career path

Job summary

WNS Global Services Pvt Ltd is seeking a Data Test Engineer to validate data pipelines and reports on an enterprise finance data platform hosted on Azure, Databricks and Snowflake. The role focuses on ensuring correct data loading, transformation and reporting from source systems through Power BI.

The ideal candidate has 4–5 years in software or data testing, with at least 2 years in data warehouses or data platforms, and experience in test automation using Python and SQL.

Qualifications

• 4 to 5 years of experience in software or data testing.
• At least 2 years testing data warehouses or data platforms.
• Participation in finance domain testing is advantageous.

Responsibilities

• Write test plans and test cases for ingestion, transformation and reporting.
• Test data loads from source systems, including record counts, completeness and field-level checks.
• Test Databricks transformations against source-to-target mappings.
• Test Snowflake data products and access rules.
• Test Power BI reports, including figures, filters, security and performance.
• Automate repeatable data tests using Python and SQL.
• Run regression tests for each release through Azure DevOps.
• Log and track defects, and retest fixes.
• Support user acceptance testing with finance users.
• Report test progress and results.

Skills

SQL

Python for test automation

Data warehouse/ETL testing

Databricks/Snowflake

Power BI report testing

Azure DevOps Test Plans

Education

Degree in engineering or computer applications (B.E./B.Tech or MCA)

Tools

pytest

Great Expectations

DAX Studio

Job description

Data Test Engineer( SQL / Python for test automation /Data warehouse /ETL testing/Databricks /Azure DevOps Test Plans) AM

Company Description

WNS, part of Capgemini, is an Agentic AI-powered leader in intelligent operations and transformation, serving more than 700 clients across 10 industries, including Banking and Financial Services, Healthcare, Insurance, Shipping and Logistics, and Travel and Hospitality. We bring together deep domain excellence – WNS’ core differentiator – with AI-powered platforms and analytics to help businesses innovate, scale, adapt and build resilience in a world defined by disruption. Our purpose is clear: to enable lasting business value by designing intelligent, human-led solutions that deliver sustainable outcomes and a differentiated impact. With three global headquarters across four continents, operations in 13 countries, 65 delivery centers and more than 66,000 employees, WNS combines scale, expertise and execution to create meaningful, measurable impact.

Why Join Us?

We promise our employees to experience role clarity, coaching and mentoring, professional development and structured career path through our 5 people promises and keeping employee experience at the core. Experience the culture of Outperformance, engagement, celebration and enjoy wide variety of best in class benefits including free HMO coverage for self and dependent from Day 1 ; Also contribute to society through our WNS Cares Foundation , where you have the opportunity to support meaningful initiatives and make an impact in the community.

Job Description

Data Test Engineer We are looking for a Data Test Engineer with 4 to 5 years of experience to test data pipelines and reports on an enterprise finance data platform on Azure, Databricks and Snowflake. You will plan and run tests that confirm data is loaded, transformed and reported correctly, from source systems through to Power BI.

KEY RESPONSIBILITIES

• Write test plans and test cases for ingestion, transformation and reporting
• Test data loads from source systems, including record counts, completeness and field-level checks
• Test Databricks transformations against source-to-target mappings
• Test Snowflake data products and access rules
• Test Power BI reports, including figures, filters, security and performance
• Automate repeatable data tests using Python and SQL
• Run regression tests for each release through Azure DevOps
• Log and track defects, and retest fixes
• Support user acceptance testing with finance users
• Report test progress and results

TECHNICAL SKILLS

Must-have SQL Python for test automation Data warehouse and ETL testing Databricks or Snowflake Power BI report testing Azure DevOps Test Plans or Jira Good-to-have pytest Great Expectations Performance testing Power BI tools such as DAX Studio

DOMAIN KNOWLEDGE

Finance data and reconciliations Month-end close and tax processes

CERTIFICATIONS (GOOD TO HAVE)

ISTQB Certified Tester Foundation Level (CTFL) SnowPro Core

EXPERIENCE AND QUALIFICATIONS

4 to 5 years in software or data testing, with at least 2 years testing data warehouses or data platforms Tested finance or banking systems Degree in engineering or computer applications (B.E., B.Tech or MCA)

QUALIFICATIONS

Degree in engineering or computer applications (B.E., B.Tech or MCA)

EXPERIENCE LEVEL

Mid Level