Specialist, Software Engineer (Informatica)

If you’re passionate about innovation and love working in an environment where you can constantly improve and adopt new technologies to drive business results, then Nationwide’s Information 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.

This position is part of the P&C/Agency Data Solutions BSA, which manages Licensing and Appointments for Personal Lines, Commercial Lines, Farm, Specialty Insurance, and Commercial Agriculture.

The ideal candidate will have experience with the following:

ETL Tools: Informatica PowerCenter 10.5.2/10.2.0

Databases: Oracle19C/12C/11g, IBM DB2, Microsoft SQL Server

Operating Systems: Linux, Unix, Windows

Programming:  ETL Technology, Docker, Kubernetes, DevOps, DevSecOps, SQL, DB2 SQL, TSQL, Perl Scripting, UNIX Shell Scripting, Power BI, Ruby

Data Modelling: Conceptual Modelling, Logical Modelling, Physical Data Modelling, ER Modelling, Dimensional Modelling - Confirmed Dimension, Junk Dimension, Slowly Changing Dimension, Degenerated Dimension, Dimension Tables and Fact Tables

Tools: Harness, Concourse, UCD (Urban Code Deployment), GitHub, Ruby Mine Automation Tool, Ruby, Jira, UAC (Universal Automation Center)

Other Tools: DBeaver, Squirell SQL Client, SQL Navigator, SQL for DB2, Toad for Oracle, SQL Developer, MS Office, JIRA, Advanced Query Tool, IBM Developer for Z Systems, Power BI

Software Development Methodology: Agile, Waterfall.

Compensation Grade: F5

#LI-AC1

Job Description Summary

If you’re enthusiastic about delivering secure technology solutions to support a company providing extraordinary care to its customers, then Nationwide Technology is the place for you. Nationwide's industry-leading technology workforce embraces an agile work environment and a collaborative culture to deliver outstanding solutions and results. If that sounds like something you aspire to, we want to hear from you!

As a Software Engineer, you will focus primarily on providing high quality, efficient technology solutions to business partners by crafting new software applications or modifying and/or supporting existing packaged or custom-built applications. In this capacity, you’ll analyze, code, configure, test, debug, document and maintain applications.

Job Description

Key Responsibilities:

• Analyzes, solutions, develops, tests, debugs, documents and deploys software according to standards in an agile environment.

• Applies secure software and systems engineering practices throughout the delivery lifecycle to ensure our data and technology solutions are protected from threats and vulnerabilities.

• Uses DevSecOps practices, tooling and techniques.

• Drives continuous improvement and learning through ongoing training, practice and innovation.

• Manages medium to large project priorities, deadlines and deliverables proactively.

May perform other responsibilities as assigned.

Reporting Relationships: Reports to a Technology Manager/Director. 

Typical Skills and Experiences:

Education: Completion of undergraduate studies in computer science, management information systems, or other related degree. Technology experience or non-traditional technology certificates can be substituted for an undergraduate degree. 

Experience: Four or more years of analysis and technology experience.

Knowledge, Abilities and Skills: Proficiency in one or more programming language such as Java, C++, Python, JavaScript. Strong knowledge of software development lifecycle. Proven ability to tackle complex business and development problems. Ability to thrive in a team environment. Insurance/financial services industry knowledge a plus.

Other criteria, including leadership skills, competencies and experiences may take precedence. 

Staffing exceptions to the above must be approved by the hiring manager’s leader and