ETL Tester - SQL & Data Validation tester

ARPITA BANT

ETL Tester

EMAIL: ***********@*****.*** PHONE: +91-810******* LinkedIn : https://www.linkedin.com/in/arpita-bant-33a6a0196 Summary:

Detail-oriented ETL Tester with 4+ years of experience in validating data warehouse and ETL Process. Strong expertise in SQL–based data validation, Source-to-target mapping, data reconciliation, and defect tracking to ensure high data accuracy and integrity across the enterprise system.

Work Experience:

ETL Tester

Company Name: VOYA INDIA

Duration: Jul 2022 – Present

Performed end-to-end ETL testing to validate data extraction, transformation and loading processes across multiple source and target systems, executed SQL-based data validation and source-to-target mapping checks to ensure accurate implementation of business rules.

Identified critical defects early, performed root cause analysis, and tracked issues using an ALM tool for timely resolution.

Validated full load and incremental load scenarios, including Insert, update and delete scenarios.

Collaborated with ETL developers and business analysts to understand requirements and ensure accurate data delivery.

Automated basic checks and column-level data validation using Python/Pyspark dataFrames, reducing manual effort and execution time. Designed and executed automated data validation scripts to compare large datasets (about 10M+ records) efficiently in Databricks.

Developed reusable PySpark frameworks for source vs target data comparison across Oracle, MSSQL, Databricks, DB2 and Snowflake databases and created Databricks pipelines to integrate multiple workflows.

Supported UAT and production validations to ensure data accuracy in reports and downstream systems. Education:

Degree: Bachelor's Of Engineering, (Electronics and Communications) College: KLE Institute of Technology, Hubli, KA (2017-2021) Skills:

o Database : Databricks, Oracle, MSSQL, Snowflake, DB2 o Technical Skills : SQL (Basic & Advanced), ETL Concepts, Python, PySpark, MDM (Master Data Management), Agile o Tools : ALM, EBX, Postman, ADF

Projects:

1. Name: My Voyage

Duration: Sep 2022 – Jan 2025

Description : My Voyage is a mobile application offering personalized guidance and data-driven insights to help with your workplace benefits and savings

Roles and Responsibilities:

Created detailed ETL test case for complex transformations, logics and lookups and also built an automated testcase generation script.

Validated Slowly changing dimensions (SCD Type 1 & SCD Type 2) behavior where applicable.

Analyzed business requirement documents and functional specifications to derive ETL test scenarios and coverage.

Executed partition-level validation for large datasets to improve performance and accuracy.

Verified job dependencies, scheduling logic and rerun scenarios for failed ETL jobs.

Identified and reported critical defects at an early stage, allowing quick resolution and ensuring data accuracy.

Data accuracy and testing time were reduced by about 70% by automating, ensuring ensuing trusted analytics and reporting.

Supported Production releases with no Critical issues and with data accuracy for about 10M+ records. 2. Name: CIM- Customer Identity Management

Duration: Feb 2025 – Present

Description: On-Boarding of customer data and generating Golden entries by master data management MDM process for the customers, ensuring the security across multiple sources. Roles and Responsibilities:

Ensured data accuracy and consistency during person data onboarding by testing ETL workflows across multiple layers

Ensured high-quality master data by validating golden records using the EBX MDM tool.

Validated source-to-target mappings, transformation logic and business rules for both Individual and organizational master data using the EBX.

Designed and implemented Databricks Pipelines to integrate automation scripts across multiple ETL layers, enabling single-run end-to-end data validation.

Key Achievements:

Production Support: Successfully supported 10+ production releases with zero critical defects, ensuring high data accuracy and stability.

Testing Efficiency: Automated 90% of regression testing using Databricks pipeline workflows, significantly improving data validation accuracy and reducing testing time.

Recognition: Awarded the “Championship Award – 2025” for the CIM project in recognition of a drastic reduction in suspect records and improved data quality.

Area of Interest:

Data analysis

Python Automation

Power BI

Contact this candidate