Senior Data Quality Engineer with 16+ Years Experience

SONA MEHTA

Columbus, OH 614-***-**** **********@*****.*** linkedin.com/in/sona-mehta-aa989646

PROFESSIONAL SUMMARY

Senior Data Quality Engineer with 16+ years validating ETL pipelines, data warehouse migrations, and complex SQL transformations across insurance, healthcare, education, and federal data systems. Recent hands-on work in Databricks and Teradata, with deep expertise in source-to-target mapping, data integrity validation, and back-end test automation. Proven ability to author complex SQL scripts, design reusable validation patterns, and partner with data engineering to surface defects pre-release. ISTQB-certified Lead with a track record of reducing post-release data defects and accelerating release confidence.

TECHNICAL SKILLS

Data Platforms & ETL: Databricks, Teradata, SQL Server, Oracle, data warehouse validation, source-to-target mapping, ETL test design, schema validation

SQL & Scripting: Complex SQL (joins, CTEs, window functions, aggregations), Python, Java, UNIX shell scripting

Test Automation: Selenium WebDriver, Cucumber (BDD), TestNG, Rest Assured, Page Object Model

API & Services: Postman, Swagger, SOAPUI, REST, SOAP

CI/CD, Cloud & Tools: Jenkins, GitHub Actions, Azure DevOps, Git, Jira, Confluence, HP ALM, AWS (EC2, S3), Azure

Methods: Agile/Scrum, BDD, data quality frameworks, AI-assisted SQL generation

PROFESSIONAL EXPERIENCE

Senior ETL Test Lead Nationwide Insurance, Columbus, OH January 2025 – June 2026

•Led ETL test strategy and execution for policy and claims data pipelines across Databricks and Teradata, owning quality gates for downstream underwriting and actuarial reporting.

•Authored 200+ complex SQL validation scripts verifying source-to-target mappings, transformations, and aggregation logic, reducing post-release data defects ~35%.

•Designed reusable SQL validation patterns covering row counts, schema conformance, and referential integrity across staging, target, and historical data sets.

•Partnered with data engineering to triage data-integrity issues, translating business-reported anomalies into reproducible defects closed within a 24-hour SLA.

•Adopted AI-assisted SQL generation, cutting query authoring time ~60% and shifting team capacity toward edge-case discovery.

QA Automation Lead / Program Analyst Whole Point Systems (ICF) March 2022 – December 2024

•Owned back-end ETL and data validation for federal CPIC program management products, ensuring data integrity across investment and capital planning datasets.

•Engineered complex SQL queries for back-end test coverage and cross-system data reconciliation under federal compliance and OMB reporting requirements.

•Built API and data-pipeline automation with Postman, Rest Assured, and Python, validating contracts and payloads pre-release.

•Reduced regression cycle time by 40% through a Selenium/Cucumber/TestNG framework supporting both UI and back-end data flows.

QA Analyst / Test Lead NREMT October 2018 – February 2022

•Reconciled ETL jobs and cross-system data comparisons against Oracle and SQL Server for a Salesforce-based certification platform serving 250K+ EMS professionals.

•Spearheaded staging database validation through complex SQL scripts verifying ETL transformations and reporting data integrity.

•Established a structured test data management process that reduced data-related test failures 25%.

•Drove API automation with Postman and Rest Assured to validate backend service workflows across SAP integrations.

QA Analyst Pearson Education October 2016 – October 2018

•Verified data extraction, transformation, and load pipelines for Kentico CMS and BI reporting platforms serving K-12 customers.

•Increased automated regression coverage 40% via Selenium suite expansion, shortening release cycles.

QA Analyst TEKsystems / Duke Energy March 2015 – October 2016

•Executed backend SQL validation across integration points for outage management and IVR systems serving 7M+ utility customers, catching data discrepancies before downstream billing impact.

•Automated regression coverage across legacy and modernized customer-facing systems.

Earlier Experience 2009 – 2014: QA roles at Sedgwick CMS (claims ETL/SQL), Hewlett-Packard (DMV systems automation), and Care Works Technologies (healthcare claims). Details on request.

CERTIFICATIONS & EDUCATION

ISTQB Certified Tester (ASTQB) CompTIA Network+ MTA: Security Fundamentals, Windows Client & Server

B.S., Computer Information Systems — DeVry University, Columbus, OH

Contact this candidate