PL/SQL Developer
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Title: Oracle PL/SQL / WebFocus Developer
Location: MI (Day 1 Onsite)
JobType: Contract Primary Skills : Oracle ODI, PL/SQL, WebFOCUS, Insurance Data Warehouse & Databricks Modernization, P&CKey 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
- PackagesFunctionsTriggersBulk Processing
- Dynamic SQLException Handling
- Strong experience in:
- Query OptimizationSQL Performance Tuning
- Execution Plan Analysis
- PartitioningIndexing 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
ScenariosData Quality Integrations
Experience delivering enterprise-scale ETL/ELT solutions in highly regulated environments.
Business Intelligence & Reporting
WebFOCUSStrong 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 LakeSpark SQLPySparkData 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:
- S3Glue
- RedshiftLambdaEMRAthenaUnderstanding 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
- RenewalsEndorsementsUnderwritingRisk Assessment
- RatingPricing Models
- Underwriting Analytics
- Claims Management
- First Notice of Loss (FNOL)
- Claims Processing
- Reserve Management
- Claims Analytics
- Billing & Payments
- Premium Processing
- CollectionsReceivables Management
Leadership & Consulting SkillsStrong 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.
Ideal Candidate Profile:
A seasoned Data Architect / Enterprise Data Warehouse Architect with deep expertise in Oracle PL/SQL, Oracle Data Integrator (ODI), WebFOCUS Reporting, and P&C Insurance Data Warehousing, complemented by hands-on exposure to Databricks Lakehouse, Spark, and AWS cloud technologies for legacy modernization and future-state analytics platforms.