Oracle Insurance Policy Administration (OIPA) with Annuity

Job Role: Oracle OIPA Consultant with Annuity

Location: Minneapolis, MN / Charlotte, NC

Duration: 12 months Contract

Oracle Insurance Policy Administration (OIPA), SQL and XML, AWS Services, CICD Pipeline

Annuity experience is REQUIRED

Be responsible for the Oracle Insurance Policy Administration for the business. Work closely with customers, business analysts, technology, and project teams to understand business requirements, drive the analysis and design of quality technical solutions that are aligned with business and technology strategies, and comply with the organization's architectural standards. Provide technical guidance to the development team through the full software life cycle.

Responsibilities

• Create low level design documents (including code samples/outlines) and detailed engineering specifications based on complex business, user, and non-functional (e.g., performance, reliability, balance, and controls) requirements. Write code that adheres to coding standards, procedures, and techniques. Maintain the integrity of existing program logic according to specifications.
• Actively participate in the code review process to ensure development work adheres to standards and specifications (including peer review and code review external to team).
• Ensure the quality of work completed by vendor partners.
• Write and/or revise system design documentation and operations documentation to include providing required input into operation support manuals.
• Unit test all code and programs prior to releasing them to quality assurance.
• Quickly resolve all unit test issues. Assist quality assurance in identifying test cases and creating/mining test data to enable a thorough test of all development deliverables.
• Respond to all inquiries and issues in a timely manner as developed code/program moves through the testing process.
• Provide mentoring and direction to more junior members of the application development team. Influence the shaping of standards and tools.
• Provide governance oversight to ensure project adherence to development strategy, standards, policies, tools, and procedures.
• Guide the development team to consistently apply appropriate development principles and standards during all phases.
• Work in partnership with the project team and business to fully understand project goals and requirements and use this knowledge to effectively plan and execute the development process.
• Participate in project design walkthroughs. Evaluate interrelationships between applications to determine whether a change in one part of the project would impact or cause undesirable results in related applications and design for effective interfaces between interrelated applications.
• Improve the health of system assets by identifying enhancements to improve performance, reliability, and resource consumption.
• Track exceptions to standards (e.g. security gaps) to ensure they are addressed in a planful and timely fashion.
• Evaluate and troubleshoot root-cause analysis for production issues and system failures; determine corrective action(s) and propose improvements to prevent their recurrence.
• Maintain up-to-date business domain knowledge and technical skills in software development technologies and methodologies.
• Provide input in the selection, implementation and use of development tools and best practices.
• Work effectively in a team environment to ensure that solution delivery is on time, within cost estimates and meets business needs. #LI_DNI

Required Qualifications

• 5-7 years of experience with Oracle Insurance Policy Administration (OIPA).
• 5-7 years of experience with SQL and XML.
• Strong knowledge of OIPA Rules Palette, Rules, Activity/Transaction configuration, Admin and Plan rules, different AS Tables, Plan/Product configuration, Segments & elements, Configurations, Security roles, Single policy fixes, Rules Palette usage and Policy lifecycle modeling for annuity products, API integrations, Java.
• Knowledge of Fixed, Indexed, Variable, and Registered Annuities, Surrender charges, Riders, Premium allocation, Annuity lifecycle events, Contract value, Fees & charges, Interest calculations, Payout options.
• 2-3 years of experience in developing applications targeting a major cloud (AWS, Azure or Google Cloud Platform).
• Proven knowledge of development tools such as Visual Studio, Git, SQL Server Management Studio, CICD/automation tools such as Jenkins, Ansible etc.
• Demonstrable experience in SQL development which includes but not limited to writing views, stored procedures, functions.
• Proven ability to write quality code by following best practices and guidelines.
• Strong problem-solving, multi-tasking and organizational skills.
• Good written and verbal communication skills.
• Demonstrable experience of working on a team that is geographically dispersed.

Preferred Qualifications

• Full-stack development experience using AWS Services
• Knowledge of UNIX/LINUX shell scripting
• Experience with Container technologies (Docker, EKS, ECS)
• Experience with AI/MLOps
• Proven ability to successfully translate client/business needs into software designs.
• Proven analytical and business skills to reconcile conflicting objectives and find/design acceptable compromises within existing limitations.
• Understand and apply both current technical solution elements (specific tools, components, and frameworks) and abstract elements (algorithms and architectures).
• Effectively apply technology/engineering knowledge-base to multiple and evolving programs and languages.

Education: At least a bachelor s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or a closely related field is required for the project