Oracle OIPA Engineer

Role Overview

The Oracle OIPA Engineer will be responsible for supporting Oracle Insurance Policy Administration (OIPA) for the RiverSource business.

The role requires close collaboration with business stakeholders analysts and technology teams to design and implement scalable compliant and high-quality technical solutions aligned with enterprise architecture standards.

The candidate will provide technical leadership throughout the full SDLC including design development testing governance and production support.

Key Responsibilities

Architecture & Design

• Create low-level design documents and detailed engineering specifications.

• Translate business functional and non-functional requirements into scalable technical solutions.

• Participate in design walkthroughs and architectural reviews.

• Evaluate application interdependencies and interface design.

Development & Code Quality

• Develop and maintain OIPA solutions adhering to coding standards.

• Write high-quality SQL (views stored procedures functions).

• Work extensively with XML configurations within OIPA.

• Participate in peer code reviews and governance reviews.

• Maintain integrity of existing program logic.

Testing & QA Support

• Unit test all code prior to QA release.

• Support QA in test case identification and test data preparation.

• Resolve issues identified during QA cycles.

Mentorship & Governance

• Mentor junior developers.

• Ensure adherence to development standards and architectural policies.

• Influence standards tools and development practices.

Production Support & Optimization

• Conduct root cause analysis for production issues.

• Improve system performance reliability and resource utilization.

• Track and remediate security or standards gaps.

• Recommend preventative improvements.

Required Qualifications

• Bachelors degree in CS Engineering or equivalent experience.

• 5-7 years of OIPA experience

• 5-7 years of SQL & XML experience

• 2-3 years cloud development experience (AWS preferred)

• Experience with:

  • AWS Services

  • CI/CD tools (Jenkins Ansible)

  • Git

  • SQL Server Management Studio

  • Visual Studio

• Strong SQL development skills (views stored procedures functions).

• Strong written and verbal communication skills.

• Experience working in geographically distributed teams.

Preferred Qualifications

• Full-stack AWS development experience

• UNIX/Linux shell scripting

• Container technologies (Docker EKS ECS)

• AI / MLOps exposure

• Strong analytical & business translation skills

• Experience designing within architectural constraints

• Ability to apply modern engineering principles and tools