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)