Oracle PL/SQL / Databricks / WebFocus Architect

Title: Oracle PL/SQL / Databricks / WebFocus Architect

Location: MI (Day 1 Onsite)

Job Description:

We are looking for a Oracle PL/SQL / WebFocus/ Databricks Architect – with 10+ years of experience, strong P&C Insurance domain expertise, and hands-on experience with Oracle PL/SQL / Databricks / WebFocus.

(Oracle ODI, PL/SQL, WebFOCUS, Insurance Data Warehouse & Databricks Modernization)

Key Responsibilities

• Partner with business users, insurance stakeholders, and technology teams to leverage enterprise data assets for strategic decision-making, operational reporting, and regulatory compliance.
• Lead the design, enhancement, and modernization of large-scale Enterprise Data Warehouses, with primary expertise in Oracle-based data platforms using Oracle Data Integrator (ODI) and PL/SQL.
• Architect and maintain enterprise reporting and analytics solutions using WebFOCUS and other BI technologies, ensuring delivery of business-critical insights and operational dashboards.
• Drive data integration initiatives involving multiple source systems across Policy Administration, Underwriting, Claims, Billing, and Finance domains.
• Define data architecture standards, dimensional models, data governance frameworks, and enterprise reporting strategies supporting both legacy and modern analytics ecosystems.
• Collaborate with business stakeholders, enterprise architects, and development teams to deliver scalable data solutions aligned with organizational objectives.
• Lead assessment and modernization of legacy data warehouse environments, defining migration roadmaps toward cloud-native platforms such as Databricks and AWS.
• Design and implement data pipelines, ingestion frameworks, and analytical data models supporting batch and near real-time processing requirements.
• Provide architectural guidance for integrating traditional EDW environments with modern Lakehouse architectures built on Databricks.
• Act as a trusted advisor for enterprise reporting, analytics transformation, and insurance data management initiatives.
• Support enterprise data governance, data quality, master data management, and regulatory reporting requirements within the insurance industry.
• Mentor development teams on best practices in ODI development, PL/SQL optimization, data modeling, reporting architecture, and Databricks adoption.

Desired Skills & Experience

Core Experience

• 15+ years of experience in Enterprise Data Warehousing, Data Integration, Business Intelligence, and Analytics solutions.
• Minimum 5+ years of hands-on experience in the Property & Casualty (P&C) Insurance domain.
• Extensive experience delivering enterprise-scale data warehouse and reporting solutions in complex insurance environments.
• Experience supporting modernization initiatives that bridge traditional Oracle-based platforms with modern Databricks Lakehouse architectures.

Legacy Data Warehouse & Data Integration Expertise (Primary Focus)

Oracle Data Warehouse

• Deep expertise in Enterprise Data Warehouse architecture, dimensional modeling, data marts, and reporting data structures.
• Strong experience designing and maintaining large-scale Oracle Data Warehouses supporting business intelligence and analytics workloads.
• Expertise in Star Schema, Slowly Changing Dimensions (SCD), Fact & Dimension Modeling, and Data Vault concepts.

Oracle PL/SQL (Mandatory)

• Advanced expertise in Oracle PL/SQL development including:
• Complex Stored Procedures
• Packages
• Functions
• Triggers
• Bulk Processing
• Dynamic SQL
• Exception Handling
• Strong experience in:
• Query Optimization
• SQL Performance Tuning
• Execution Plan Analysis
• Partitioning
• Indexing Strategies
• Database Performance Management
• Hands-on experience with large-volume data processing and batch ETL workloads.

Oracle Data Integrator (ODI)

• Extensive hands-on experience with Oracle Data Integrator (ODI).
• Expertise in:
• Mappings
• Knowledge Modules (KM)
• Interfaces
• Load Plans
• Scenarios
• Data Quality Integrations
• Experience delivering enterprise-scale ETL/ELT solutions in highly regulated environments.

Business Intelligence & Reporting

WebFOCUS

• Strong hands-on experience developing WebFOCUS reporting and dashboard solutions.
• Expertise in:
• Operational Reporting
• Executive Dashboards
• Ad-hoc Reporting
• Regulatory Reporting
• Performance Analytics
• Experience gathering business requirements and translating them into scalable reporting solutions.

Additional BI Tools

• Exposure to Tableau, Power BI, Cognos, or similar reporting platforms.
• Strong understanding of KPI development, business metrics, and self-service analytics frameworks.

Modern Data Platform Skills (Secondary Focus)

Databricks & Lakehouse

• Experience with Databricks for modern data engineering and analytics workloads.
• Understanding of:
• Delta Lake
• Spark SQL
• PySpark
• Data Lakehouse Architecture
• Medallion Architecture
• Experience migrating legacy EDW workloads to Databricks-based platforms.
• Ability to integrate Oracle-based data warehouses with cloud-native analytics ecosystems.

AWS Cloud

• Exposure to AWS services including:
• S3
• Glue
• Redshift
• Lambda
• EMR
• Athena
• Understanding of cloud migration strategies and hybrid data architectures.

Data Engineering & Integration

• Strong knowledge of enterprise ETL/ELT frameworks and data integration patterns.
• Experience integrating structured and semi-structured data across multiple source systems.
• Exposure to event-driven and streaming architectures using Kafka or Confluent Kafka.
• Familiarity with data quality frameworks, metadata management, and data lineage principles.

Insurance Domain Expertise (Mandatory)

Strong understanding of Property & Casualty Insurance business functions including:

Policy Administration

• Policy Lifecycle Management
• New Business
• Renewals
• Endorsements

Underwriting

• Risk Assessment
• Rating
• Pricing Models
• Underwriting Analytics

Claims Management

• First Notice of Loss (FNOL)
• Claims Processing
• Reserve Management
• Claims Analytics

Billing & Payments

• Premium Processing
• Collections
• Receivables Management

Leadership & Consulting Skills

• Strong stakeholder management skills across business and technology organizations.
• Proven experience leading enterprise data warehouse and analytics programs.
• Ability to conduct architecture reviews, solution design workshops, and modernization assessments.
• Strong communication skills with executives, business users, and development teams.
• Experience mentoring technical teams in Oracle, ODI, PL/SQL, WebFOCUS, and Databricks technologies.
• Demonstrated ability to define technology roadmaps and drive enterprise-wide data transformation initiatives.

About ValueMomentum:

ValueMomentum is a leading solutions provider for the global property and casualty insurance industry, supported by deep domain and technology capabilities. We help insurers stay ahead with sustained growth and high performance for enhancing stakeholder value and fostering resilient societies. Trusted by over 100 insurers, ValueMomentum is one of the largest services providers exclusively focused on property and casualty. ValueMomentum is headquartered in Piscataway, NJ, with state-of-the-art delivery centers in Piscataway, NJ; Hyderabad, Pune, and Coimbatore in India; Toronto in Canada; and London in the United Kingdom.

ValueMomentum is an Equal Opportunity Employer committed to fostering a diverse and inclusive workplace. We make all employment decisions based on qualifications, merit, and business needs, without regard to race, color, religion, sex, gender identity or expression, sexual orientation, national origin, age, disability, protected veteran status, genetic information, or any other characteristic protected by applicable federal, state, or local law.

We are also committed to providing reasonable accommodation for qualified individuals with disabilities and applicants throughout the recruitment process, in accordance with applicable laws.