PL/SQL Developer

Title: Oracle PL/SQL / WebFocus DeveloperLocation: MI (Day 1 Onsite)JobType: Contract Primary Skills : Oracle ODI, PL/SQL, WebFOCUS, Insurance Data Warehouse & Databricks Modernization, P&CKey ResponsibilitiesPartner 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 & ExperienceCore Experience15+ 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 WarehouseDeep 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 ProceduresPackagesFunctionsTriggersBulk ProcessingDynamic SQLException HandlingStrong experience in:Query OptimizationSQL Performance TuningExecution Plan AnalysisPartitioningIndexing StrategiesDatabase Performance ManagementHands-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:MappingsKnowledge Modules (KM)InterfacesLoad PlansScenariosData Quality IntegrationsExperience delivering enterprise-scale ETL/ELT solutions in highly regulated environments.Business Intelligence & ReportingWebFOCUSStrong hands-on experience developing WebFOCUS reporting and dashboard solutions.Expertise in:Operational ReportingExecutive DashboardsAd-hoc ReportingRegulatory ReportingPerformance AnalyticsExperience gathering business requirements and translating them into scalable reporting solutions.Additional BI ToolsExposure 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 & LakehouseExperience with Databricks for modern data engineering and analytics workloads.Understanding of:Delta LakeSpark SQLPySparkData Lakehouse ArchitectureMedallion ArchitectureExperience migrating legacy EDW workloads to Databricks-based platforms.Ability to integrate Oracle-based data warehouses with cloud-native analytics ecosystems.AWS CloudExposure to AWS services including:S3GlueRedshiftLambdaEMRAthenaUnderstanding of cloud migration strategies and hybrid data architectures.Data Engineering & IntegrationStrong 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 AdministrationPolicy Lifecycle ManagementNew BusinessRenewalsEndorsementsUnderwritingRisk AssessmentRatingPricing ModelsUnderwriting AnalyticsClaims ManagementFirst Notice of Loss (FNOL)Claims ProcessingReserve ManagementClaims AnalyticsBilling & PaymentsPremium ProcessingCollectionsReceivables ManagementLeadership & 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 ProfileA 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.