Specialist, Software Engineer - ETL Informatica and ACE (App Connect Enterprise

If you’re passionate about being part of a dynamic organization that enables a Fortune 100 company with nearly $70 billion in annual sales to drive innovation and adopt new technologies that deliver business results, then Nationwide’s Technology team could be the place for you! At Nationwide®, “on your side” goes beyond just words. Our customers are at the center of everything we do and we’re looking for associates who are passionate about delivering extraordinary care.

• Design, enhance, and support ACE integrations that connect Policy Center and other services through secure APIs, message routing, and payload transformation.
• Build and maintain ACE flows that obtain authentication tokens, invoke REST services, construct request payloads, apply field mappings, and return transformed responses to upstream applications.
• Support CL ETL Batch processing that consumes Policy Center transaction data from IDS Oracle after IIB/ACE processing and creates downstream extracts and statistical records.
• Deliver and support integrations and data feeds for business and regulatory consumers including Billing, Commissions, General Ledger, ISO/TICO, HSB, ISO/Verisk, WC PICS/Unit Stat, print, inforce, ECIF, AMI, SaRA, and PAM.
• Provide production support, issue analysis, and ongoing optimization for integration jobs, runtime behavior, and data processing outcomes.

• Own and enhance ACE integration solutions, including instance-level application support, updates, and alignment with enterprise integration standards.
• Analyze business and system requirements and translate them into API contracts, request/response mappings, transformation logic, and integration error handling.
• Develop and troubleshoot data mappings between Policy Center XML or service payloads and downstream schemas used by internal services, print, vendor feeds, and reporting outputs.
• Support ETL workflows that extract, transform, and publish data for line‑of‑business processing, statistical records, and operational file exchanges.
• Work with Oracle-based IDS data structures, job control metadata, and environment‑specific parameters used to monitor, troubleshoot, and rerun processing flows.
• Support job scheduling and operational processing in a UNIX environment using established batch frameworks and Perl-based job control patterns.
• Partner with product, testing, and downstream business or technical teams to ensure integrations are reliable, supportable, and aligned to policy transaction needs.

• Strong integration engineering background with hands‑on experience in IBM App Connect Enterprise or comparable middleware/integration platforms, including message routing, protocol connectivity, and data transformation.
• Experience with API and service integrations, including token‑based authentication, REST request construction, header management, endpoint invocation, response parsing, and upstream response mapping.
• Strong data mapping and transformation skills across XML, JSON, and downstream record or file layouts.
• Experience working with batch data pipelines, file‑based integrations, and downstream data feeds for operational or reporting consumers.
• Working knowledge of Oracle data environments, SQL‑based troubleshooting, and environment‑specific configuration or access patterns for development through production support.
• Understanding of deployment, security, and configuration concepts for integration runtimes.
• Experience supporting production incidents, job failures, data issues, and operational reruns in complex enterprise environments.

• Experience with Commercial Lines Policy Center integrations and transaction data flows into downstream platforms.
• Familiarity with IDS Oracle structures and CLS ETL Batch processing patterns.
• Experience supporting vendor, bureau, or regulatory feeds such as ISO, Verisk, NCCI/CDX, HSB, or premium audit/reporting processes.
• Experience with UNIX‑based batch operations, scheduling tools, and scripting for file handling, job control, or audit/reporting support.

The strongest candidate will be a technically deep integration engineer who is…