Nationwide

6 days ago

Specialist, Data Engineer Test Lead - ETL, Python, Perl

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 5 hours agoStatus: Live

Job Summary

Lead test planning, execution, and data validation for initiatives supporting the NF Actuarial Datamart. Partner with developers, analysts, and business stakeholders to define testing scenarios, investigate upstream/downstream data issues, write and run SQL for troubleshooting, and manage defects through the full lifecycle. Support and enhance test automation (including Ruby where applicable) and work with Informatica ETL/data movement workflows to ensure releases are production ready in a hybrid Columbus team.

Location: Columbus

Workplace: Hybrid

Employment Type: Full time

Job Function: Administration & Executive Assistance

Seniority: Mid level

Key Responsibilities

•Lead testing efforts for NF Actuarial Datamart initiatives, including test planning, scenario development, execution, and validation.
•Perform detailed data validation across source, transformation, and target layers to confirm expected results.
•Write and execute SQL queries to investigate data conditions, validate results, and support root cause analysis.
•Analyze data issues with development teams to determine cause, impact, and resolution approach; manage defects end-to-end.
•Support and enhance test automation efforts and work with Informatica-based processes and data movement workflows for quality improvements and production-ready releases.

Pay and Benefits

Salary: USD 95,500 - 177,500 annually

Perks:Health InsuranceDentalVisionLife InsuranceShort DisabilityLong DisabilityPaid Leave401kPension

Key Requirements

•5+ years of experience in testing or quality assurance with 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 data validation experience analyzing upstream and downstream data issues.
•Ability to write SQL queries for testing, troubleshooting, and validation; ability to manage defects and support issue triage.

Experience:5+ yearsETLData validationData warehousingData integrationDatamart

Education:Bachelor's

Skills:Analytical skillsOrganizational skillsCommunication skillsProblem-solvingCollaboration

Tech Stack:InformaticaPythonPerlRubyOracleSQL ServerSnowflakeSQLETLTest automationJIRAJenkinsConfluenceGitCI/CDSparkUNIX Shell scriptingRNLPAPI

Eligibility

Work Authorization:Authorization required. Sponsorship not provided.

Company Brief

Nationwide

Nationwide is a mutual insurance and financial services company offering auto, home, life insurance, retirement planning, investments, and banking products for individuals and businesses across the United States.

Industry: Insurance

Company Size: Enterprise (1,001+ employees)

Revenue: USD 1B+

Growth: Established Company

Headquarters: Columbus, United States

Founded: 1926

Glassdoor: 3.6

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

Nationwide

6 days ago

Specialist, Data Engineer Test Lead - ETL, Python, Perl

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 5 hours agoStatus: Live

Job Summary

Location: Columbus

Workplace: Hybrid

Employment Type: Full time

Job Function: Administration & Executive Assistance

Seniority: Mid level

Key Responsibilities

•Lead testing efforts for NF Actuarial Datamart initiatives, including test planning, scenario development, execution, and validation.
•Perform detailed data validation across source, transformation, and target layers to confirm expected results.
•Write and execute SQL queries to investigate data conditions, validate results, and support root cause analysis.
•Analyze data issues with development teams to determine cause, impact, and resolution approach; manage defects end-to-end.
•Support and enhance test automation efforts and work with Informatica-based processes and data movement workflows for quality improvements and production-ready releases.

Pay and Benefits

Salary: USD 95,500 - 177,500 annually

Perks:Health InsuranceDentalVisionLife InsuranceShort DisabilityLong DisabilityPaid Leave401kPension

Key Requirements

•5+ years of experience in testing or quality assurance with 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 data validation experience analyzing upstream and downstream data issues.
•Ability to write SQL queries for testing, troubleshooting, and validation; ability to manage defects and support issue triage.

Experience:5+ yearsETLData validationData warehousingData integrationDatamart

Education:Bachelor's

Skills:Analytical skillsOrganizational skillsCommunication skillsProblem-solvingCollaboration

Tech Stack:InformaticaPythonPerlRubyOracleSQL ServerSnowflakeSQLETLTest automationJIRAJenkinsConfluenceGitCI/CDSparkUNIX Shell scriptingRNLPAPI

Eligibility

Work Authorization:Authorization required. Sponsorship not provided.

Company Brief

Nationwide

Industry: Insurance

Company Size: Enterprise (1,001+ employees)

Revenue: USD 1B+

Growth: Established Company

Headquarters: Columbus, United States

Founded: 1926

Glassdoor: 3.6

Website LinkedIn