N

Nationwide

Sells insurance, annuities and retirement plans

Specialist - Software Engineer, Ibm Ace & Etl

Backend EngineeringUpdated on Nov 13
Full-time$95.5k - $177.5k /yrHybrid

About the Job

Requirements

  • Four or more years of software engineering, application integration, middleware, 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 Extract, Transform, and Load 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.
  • Completion of undergraduate studies in computer science, management information systems, or other related degrees; technology experience or non-traditional technology certificates may be substituted for an undergraduate degree.
  • Proficiency in one or more programming languages such as Java, C++, Python, and JavaScript.
  • Strong knowledge of the software development lifecycle.
  • Candidates must be based within a commutable distance of Columbus, Ohio; Des Moines, Iowa; or Scottsdale, Arizona.
  • The role does not qualify for employer-sponsored work authorization, and Nationwide does not participate in the STEM OPT Extension program.

Responsibilities

  • Design, enhance, deploy, and support IBM ACE integration flows that connect applications, services, databases, and external partners.
  • Build message flows using MQ, HTTP, REST, SOAP, Compute, Flow Order, Failure, Catch, and other ACE 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 microservices and API-led integrations that are scalable, resilient, reusable, and aligned with enterprise integration standards.
  • Configure and troubleshoot MQ Input and MQ Output nodes, including transactionality, MQ order properties, MQ transaction mode properties, and message delivery behavior.
  • Apply and troubleshoot Compute node mode properties, including Compute mode transaction mode properties, to control message propagation and transaction boundaries.
  • Design robust Failure Terminal and Catch Terminal handling patterns for recoverable errors, technical exceptions, business exceptions, retries, alerts, and operational support.
  • Analyze message parsing behavior across common formats and configure flows to correctly parse, validate, route, and transform message payloads.
  • Apply data mapping and transformation techniques across XML, JSON, copybooks, service payloads, database records, and downstream file layouts.
  • Develop ESQL using built-in ESQL functions, reusable procedures, shared logic, and effective exception-handling patterns.
  • Call Java methods from ESQL when Java-based capabilities are appropriate for specialized processing, reusable utilities, or integration with existing components.
  • Design and troubleshoot SOAP nodes, WSDL-based services, REST APIs, HTTP nodes, and service orchestration patterns.
  • Integrate ACE with Oracle and other data sources through ODBC connectivity, SQL queries, stored procedures, and database-driven processing.
  • Use Global Cache patterns to share and retrieve data across message flows while considering consistency, performance, expiration, and operational behavior.
  • Apply Message ID and Correlation ID concepts when tracing requests, matching responses, supporting asynchronous processing, and diagnosing message flow behavior.
  • Apply multiple message propagation concepts to produce, route, and manage more than one output message from a single input message when business scenarios require it.
  • Use TRY-CATCH and Flow Order node scenarios to sequence processing, isolate failures, coordinate parallel or ordered actions, and create predictable recovery paths.
  • Develop and maintain integrations through Apigee, including API exposure, policy enforcement, security, traffic management, analytics, and lifecycle support.
  • Develop Informatica ETL mappings and workflows that extract data from source systems, transform it using business rules and data-quality logic, and load it 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 to produce accurate and traceable data.
  • Monitor ETL sessions and workflows, troubleshoot rejected records and data-quality issues, manage dependencies, and support reruns and recovery with appropriate 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 the delivery lifecycle to protect data and technology solutions from threats and vulnerabilities.
  • Use DevSecOps practices, tooling, and techniques.
  • Manage medium to large project priorities, deadlines, and deliverables proactively.
  • Provide technical guidance to others.
  • Perform other responsibilities as assigned.

Desired Qualifications

  • 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.

About the Company

Nationwide

Sells insurance, annuities and retirement plans

Nationwide is an insurance and financial services group serving individuals, families and businesses across the United States. Its property and casualty arm covers cars, homes and commercial risks, earning premiums and paying claims. Its Nationwide Financial arm sells annuities, life insurance and retirement plans, earning fees and investment spreads on the savings it manages. Investment returns on the premiums and assets it holds add to its underwriting results across both businesses. The company began in 1926 as Farm Bureau Mutual Automobile Insurance Company, formed by Ohio farmers seeking fairer auto rates, and is headquartered in Columbus, Ohio.

Company size
10,001+
Company stage
Not listed
Total funding
$1.4B
Headquarters
Columbus, OH
Founded
1926

Recently Posted Jobs

Explore more opportunities at Nationwide

See more jobs