Specialist, Software Engineer – IBM ACE & ETL

Nationwide Mutual Insurance•Columbus, OH

12h•Hybrid

About The Position

Nationwide is seeking a delivery-focused Specialist Software Engineer to strengthen and modernize the integrations that support Commercial Lines. The role designs, builds, tests, troubleshoots, deploys, and supports enterprise integration solutions spanning Informatica ETL, IBM App Connect Enterprise (ACE), IBM MQ, REST and SOAP services, databases, microservices, and API management platforms such as Apigee. The engineer works across real-time messaging, API orchestration, data transformation, and batch processing to move policy transaction data securely and reliably among PolicyCenter, internal applications, downstream platforms, vendors, and regulatory consumers. ACE and Informatica ETL are complementary parts of the Commercial Lines Integration Layer. ACE supports real-time application, messaging, API, and service integration; Informatica ETL extracts, transforms, and loads data across operational systems, analytical processes, files, vendors, and downstream consumers. The position develops expertise across both areas, covering message receipt and parsing, API and service orchestration, source-system extraction, business and data-quality transformations, loading curated outputs, and operational support across environments. The role also analyzes, codes, configures, tests, debugs, documents, deploys, and maintains applications in an agile environment. It applies secure software and systems engineering practices and DevSecOps techniques, manages medium to large project priorities and deliverables, contributes to continuous improvement, and provides technical guidance. The position reports to a Technology Manager/Director. This is a hybrid role requiring in-office presence two days per week in Columbus, Ohio; Des Moines, Iowa; or Scottsdale, Arizona. Candidates must live within commuting distance of one of these offices. The position does not qualify for employer-sponsored work authorization, and Nationwide does not participate in the STEM OPT Extension program. The position is exempt and not eligible for overtime; associates may have on-call responsibilities outside normal working hours and/or on weekends.

Requirements

Four or more years of software engineering, application integration, middleware, analysis, or related technology experience.
Hands-on experience with IBM App Connect Enterprise, IBM Integration Bus, Informatica, or comparable enterprise integration and ETL platforms.
Practical experience developing and troubleshooting message flows, ESQL, MQ integrations, REST APIs, SOAP services, HTTP nodes, Informatica mappings and workflows, and data transformations.
Understanding of the ETL lifecycle, including source-to-target mapping, transformation rules, data validation, error handling, rejected records, reconciliation, and target loading.
Strong understanding of messaging concepts, transaction boundaries, ordering, request/reply patterns, error handling, and message traceability.
Experience with OAuth 2.0, API authentication and authorization, microservices, and API management platforms such as Apigee.
Experience with XML, JSON, data mapping, SQL, Oracle, ODBC, or similar database connectivity technologies.
Ability to analyze complex integration problems across applications, queues, APIs, databases, runtimes, and downstream consumers.
Strong communication, documentation, testing, debugging, and collaboration skills.
Growth mindset and willingness to learn new integration patterns, tools, and technologies.
Proficiency in one or more programming languages such as Java, C++, Python, or JavaScript.
Strong knowledge of the software development lifecycle and proven ability to tackle complex business and development problems.
Ability to thrive in a team environment.
Undergraduate studies in computer science, management information systems, or a related degree; technology experience or non-traditional technology certificates may substitute for an undergraduate degree.
Must be based within commuting distance of the Columbus, Ohio; Des Moines, Iowa; or Scottsdale, Arizona office locations.
Must be able to work in-office two days per week under the hybrid arrangement.

Nice To Haves

Commercial Lines insurance, PolicyCenter, or related policy transaction-processing experience.
IBM ACE and IBM MQ administration, deployment, configuration, and production support.
Informatica ETL development, workflow and session management, source-to-target mapping, performance tuning, scheduling, monitoring, and recovery.
Apigee API proxy development, policy configuration, security, traffic management, and analytics.
UNIX-based batch operations, scheduling tools, scripting, and file handling.
Cloud, containers, Kubernetes, CI/CD, DevSecOps, or observability practices.
Experience supporting vendor, bureau, financial, print, reporting, or regulatory data feeds.
Insurance or financial services industry knowledge.

Responsibilities

Design, enhance, deploy, and support IBM ACE integration flows connecting applications, services, databases, and external partners.
Build ACE message flows using MQ, HTTP, REST, SOAP, Compute, Flow Order, Failure, Catch, and other nodes.
Implement secure API and service integrations, including OAuth 2.0 authentication and authorization, token acquisition, header management, endpoint invocation, response handling, and error processing.
Develop scalable, resilient, reusable microservices and API-led integrations aligned with enterprise integration standards.
Configure and troubleshoot MQ Input and MQ Output nodes, transactionality, MQ order and transaction-mode properties, and message delivery behavior.
Apply and troubleshoot Compute node mode and transaction-mode properties to control message propagation and transaction boundaries.
Design Failure Terminal and Catch Terminal patterns for recoverable errors, exceptions, retries, alerts, and operational support.
Analyze message parsing and configure flows to parse, validate, route, and transform payloads.
Map and transform XML, JSON, copybooks, service payloads, database records, and downstream file layouts.
Develop ESQL using built-in functions, reusable procedures, shared logic, and exception-handling patterns; call Java methods from ESQL when appropriate.
Design and troubleshoot SOAP nodes, WSDL-based services, REST APIs, HTTP nodes, and service orchestration patterns.
Integrate ACE with Oracle and other data sources using ODBC, SQL queries, stored procedures, and database-driven processing.
Use Global Cache patterns while considering consistency, performance, expiration, and operational behavior.
Apply Message ID and Correlation ID appropriately for tracing, request/response matching, asynchronous processing, and diagnosis.
Use message propagation, TRY-CATCH, and Flow Order patterns to manage multiple outputs, sequence actions, isolate failures, and create recovery paths.
Develop and maintain integrations through Apigee, including API exposure, policies, security, traffic management, analytics, and lifecycle support.
Develop Informatica ETL mappings and workflows to extract, transform, and load data into target tables, files, feeds, and downstream platforms.
Build and support ETL processes that move policy transaction data through Oracle and other source systems into operational, reporting, financial, vendor, and regulatory outputs.
Use Informatica transformations, lookups, joins, filters, aggregations, expressions, routers, parameters, reusable mapplets, and workflow controls.
Monitor ETL sessions and workflows, troubleshoot rejected records and data-quality issues, manage dependencies, and support reruns and recovery with restart and reconciliation practices.
Support production incidents, job failures, data issues, message reprocessing, operational reruns, and root-cause analysis across connected systems.
Partner with product owners, architects, analysts, testers, application teams, and downstream consumers to deliver dependable solutions.
Analyze solutions; develop, test, debug, document, and deploy software according to standards and best practices in an agile environment.
Apply secure software and systems engineering practices throughout delivery and use DevSecOps practices, tooling, and techniques.
Manage medium to large project priorities, deadlines, and deliverables proactively; provide technical guidance to others.
Drive continuous improvement and learning through training, practice, and innovation; perform other responsibilities as assigned.

Benefits

Medical, dental, and vision coverage.
Life insurance.
Short- and long-term disability coverage.
Paid time off; newly hired associates receive a minimum of 18 days per full calendar year, prorated quarterly based on hire date.
Nine paid holidays.
Eight hours of Lifetime paid time off.
Eight hours of Unity Day paid time off.
401(k) with company match.
Company-paid pension plan.
Business casual attire.