Oracle OIPA Engineer
Oracle Insurance Policy Administration (OIPA), SQL and XML, AWS Services, CICD Pipeline
Location: Minneapolis, MN / Charlotte, NC - onsite
Be responsible for the Oracle Insurance Policy Administration for the RiverSource 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.
Required Qualifications
• Bachelors degree or equivalent in Computer Science, Engineering, or related field; or equivalent work experience.
• 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.