Specialist, Software Engineer - ETL Informatica and ACE

Nationwide

Confirmed live yesterday High trust
Hybrid

Quick summary

Work type
Hybrid
Location
Columbus, OHDes Moines, IAScottsdale, AZ
Salary
$95,500–$177,500 / yr
Posted
45 days ago
Freshness
Confirmed live yesterday

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $179k
This role $136k
$80k most similar roles pay here $241k

This role pays less than 81% of similar roles. Most pay $143,625–$214,000 — the shaded band above. At the midpoint, this role pays about $136k versus about $179k for comparable roles.

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 17 open roles on FindRole.

Listed pay typically runs $95,500–$177,500 across 17 roles with salary data.

Most-posted roles

View all roles at Nationwide

At a glance

TL;DR · Specialist, Software Engineer - ETL Informatica and ACE

Specialist, Software Engineer - ETL Informatica and ACE (App Connect Enterprise) joins the Commercial A-Team to develop integration applications for policy transaction processing, downstream data movement, and operational support across Commercial Lines. The role focuses on two primary domains: ACE and CL ETL Batch. You will design and maintain ACE integrations using secure APIs, message routing, and payload transformations while managing authentication tokens and REST services. Additionally, you will support ETL workflows that process PolicyCenter transaction data through IDS/Oracle-based systems to generate reports for various stakeholders. Key technical requirements include proficiency in IBM App Connect Enterprise, Oracle SQL, XML, JSON, and UNIX-based batch operations using Perl scripts. You will solve complex integration challenges by ensuring reliable data flows between internal services, vendor feeds, and regulatory reporting systems while troubleshooting production issues across diverse mapping schemas and infrastructure configurations.

What does a Software Engineer earn in Ohio?

Median $124144 from 46 postings across 13 companies.

See salary data

What you'll do

  • Design and maintain ACE integration flows to connect PolicyCenter with other services using secure APIs and message routing.
  • Build and manage data transformations between XML/JSON payloads and downstream schemas for reporting and vendor feeds.
  • Support CL ETL Batch processing to transform transaction data into files, reports, and statistical records.
  • Manage and troubleshoot Oracle-based IDS data structures and job control metadata in a UNIX environment.
  • Provide production support by analyzing issues, monitoring runtime behavior, and performing manual reruns of failed jobs.
  • Translate business requirements into technical specifications including API contracts, mapping logic, and error handling.
  • Ensure the reliability of data feeds for regulatory consumers such as ISO, Verisk, and other industry partners.
  • Utilize AI tools to improve engineering efficiency, troubleshooting accuracy, and documentation quality.

What we're looking for

  • Completion of an undergraduate degree in computer science, management information systems, or a related field is required, or equivalent experience/certifications.
  • Candidates must have at least four years of analysis and technology experience.
  • Proficiency in one or more programming languages such as Java, C++, Python, or JavaScript is required.
  • Experience with IBM App Connect Enterprise (ACE) or comparable middleware platforms for message routing and data transformation is required.
  • Expertise in API and service integrations including REST request construction, token-based authentication, and payload mapping is required.
  • Proficiency in SQL-based troubleshooting within Oracle data environments is required.
  • Experience with UNIX-based batch operations, scheduling tools, and Perl-based job control patterns is preferred.
  • Work authorization.

More like this

Similar roles

Specialist Software Engineer

Nationwide

Columbus, OH +2 45 days ago $95,500$177,500
IBM App Connect Enterprise IBM Integration Bus Java Python C++ JavaScript REST API DevSecOps Agile Middleware Field Mapping
4+ yrs exp Hybrid

Senior Software Engineer, ETL/Informatica/Workday

PNC

Pittsburgh, PA +1 37 days ago $86,250$143,750
Workday ETL JCL Mainframe SFTP HTTPS AS2 Dynatrace BigPanda SQL Oracle Jira ServiceNow Agile Scrum Kanban SDLC Data Modeling root-cause analysis
3+ yrs exp

Enterprise Solutions Specialist

Motorola Solutions

Chicago, IL +4 56 days ago $90,000$105,000
Land Mobile Radio IT Networking Broadband LTE Product Management Technical Sales Sales Engineering Radio Systems Control Center Software WAVE Broadband Apps
4+ yrs exp

ETL Application Support Analyst

Citi

Remote (Tampa, FL) 25 days ago $87,280$130,920
Ab Initio Oracle Unix Data Warehouse ETL Application Support Problem Management Security
4+ yrs exp Remote

Engineer, Enterprise Data Technology

Balyasny Asset Management

Warsaw, Poland 43 days ago
Python Rust .NET C# SQL PostgreSQL Snowflake NoSQL REST APIs Distributed Systems Git CI/CD Kafka Solace React Angular Machine Learning
3+ yrs exp