Data Engineer Test Lead

Nationwide

Confirmed live today High trust
Hybrid

Quick summary

Work type
Hybrid
Location
Columbus, OH
Employment
Full-time
Posted
49 days ago
Freshness
Confirmed live today

Market check

Salary context

How this pay compares to similar roles

Similar $157k
$116k $195k
below market most similar roles pay here above market

This listing doesn't post a salary. Most similar roles pay $126,800–$187,747.

Based on 240 similar postings.

Employer

About Nationwide

Nationwide is a Fortune 100 insurance and financial services company offering auto, home, life, and commercial insurance along with retirement savings, asset management, and banking products. Industry: Insurance & Financial Services

Nationwide currently has 45 open roles on FindRole.

Listed pay typically runs $118,000–$222,000 across 7 roles with salary data.

Most-posted roles

View all roles at Nationwide

At a glance

TL;DR · Data Engineer Test Lead

JOB TITLE: Specialist, Data Engineer Test Lead - ETL, Python, Perl The Specialist, Data Engineer Test Lead - ETL, Python, Perl leads test planning, execution, and data validation for the NF Actuarial Datamart. Working within the Technology team, this role involves partnering with developers and analysts to define testing scenarios, manage defects, and provide walk-up support. Key responsibilities include performing detailed data validation across source, transformation, and target layers, writing SQL queries for root cause analysis, and enhancing test automation. The position requires proficiency in Informatica, Python, Perl, Ruby, Oracle, SQL Server, and Snowflake. The role specifically addresses the technical challenge of ensuring high-quality data movement and application solutions within an actuarial data environment, focusing on data integrity, release validation, and the continuous improvement of automated testing practices to support production-ready data delivery.

What you'll do

  • Lead test planning, scenario development, and execution for NF Actuarial Datamart initiatives.
  • Perform detailed data validation across source, transformation, and target layers to confirm expected results.
  • Write and execute SQL queries to investigate data conditions and support root cause analysis.
  • Manage the full defect lifecycle, including documentation, prioritization, retesting, and closure.
  • Support and enhance test automation efforts using Ruby and Python.
  • Analyze data issues and partner with development teams to determine impact and resolution approaches.
  • Handle walk-up requests and provide timely support for testing questions and issue triage.
  • Validate Informatica-based processes and data movement workflows to ensure quality standards.

What we're looking for

  • 5+ years of experience in testing or quality assurance, with an emphasis on data validation and system/integration testing.
  • Experience with Ruby automation or automated testing frameworks.
  • Experience working with Informatica processes in an ETL or data integration environment.
  • Strong experience with data validation and analysis of upstream and downstream data issues.
  • Ability to write SQL queries for testing, troubleshooting, and validation purposes.
  • Exposure to Python and interest in expanding development-oriented technical skills.
  • Experience managing defects and supporting issue triage through resolution.
  • Work authorization.

More like this

Similar roles

Senior Data Engineer

Abbott

Madison, WI 87 days ago
Python SQL Scala Spark Snowflake Databricks ETL AWS S3 SQS GitLab JIRA Confluence Tableau RestAPI Parquet Avro Delta Lake NoSQL Agile Model Context Protocol (MCP)
4+ yrs exp

Data Engineer, Data and Automation

PNC

Strongsville, OH +1 33 days ago
Oracle SQL Informatica PowerCenter ETL Linux Unix Oracle Database SQL Data Warehouse Data Integration Data Mining Machine Learning Big Data Management Business Intelligence Data Architecture Data Validation Data Lineage
3+ yrs exp

ETL Data Engineer

Booz Allen Hamilton

McLean, VA 19 days ago $62,000–$141,000
ETL SQL Relational Databases Data Modeling Oracle AWS Azure APIs Data Quality Scripting Unstructured Datastores Metadata Stores

Data Engineer

PNC

Miamisburg, OH +4 88 days ago
MySQL Oracle Oracle Exadata Oracle Data Guard Oracle Golden Gate SQL OLTP Data Architecture High Availability Disaster Recovery Query Tuning Data Migration Machine Learning Big Data Management Business Intelligence
3+ yrs exp

Specialist Software Engineer, IBM ACE & ETL

Nationwide

Columbus, OH +2 1 day ago $95,500–$177,500
IBM ACE Informatica ETL IBM MQ REST SOAP Apigee Microservices ESQL Java Oracle SQL ODBC XML JSON OAuth 2.0 CI/CD DevSecOps Kubernetes Python C++ JavaScript
4+ yrs exp Hybrid

Lead Data Engineer

Capital One Financial

Richmond, VA 49 days ago
Python Spark PySpark AWS Redshift Snowflake Java Scala Hadoop Kafka Hive EMR MapReduce DynamoDB Cassandra MySQL Agile NoSQL RDBMS
4+ yrs exp