Oracle PL/SQL Developer

Oracle SQL/PL Developer

Key Responsibilities

Business Term and Definition Engineering

Review strategic process inventory SPI PDFs business documents data dictionaries and metadata extracts to identify business terms and domain concepts

Define clear business definitions for terms used by SPI users

Identify synonyms abbreviations alternate names and commonly used phrases for each business term

Distinguish between similar or overloaded terms that may map to different database structures depending on business context

Maintain terminology consistency across the semantic layer and knowledge base repository

Oracle Metadata Analysis

Use Toad and Oracle metadata extracts to understand available schemas tables columns keys and relationships

Analyse physical data structures and determine which tables and columns support each business term

Identify candidate joins filters dimensions measures and identifiers needed to answer common SPI questions

Work with the Data Architect to validate table relationships materialized views and performance optimized access paths

Term to Data Mapping

Create mappings from business terms to Oracle tables columns views and materialized views

Ensure mappings are precise enough to support natural language to SQL generation

Identify gaps where business terms lack clear physical data mappings

Semantic Layer Buildout

Support creation of the Talk to SPI semantic layer by organizing terms entities attributes metrics relationships and rules

Document basic relationships between business entities and database entities

Define early stage business rules where required such as calculation logic filtering rules eligibility rules or default interpretation rules

Collaborate with the AI Context Engineer to publish validated mappings into the Knowledge Base Repository

Collaborate with the AI Platform Engineer to test whether published mappings are correctly consumed by the GenAI platform

Validation and Testing

Test sample natural language questions against expected table and column mappings

Validate whether generated SQL uses the correct SPI structures

Document mapping issues ambiguous terms missing metadata and required SME clarifications

Support iterative improvements based on testing SME feedback and GenAI query results

Primary Skill Oracle SQL PLSQL

Secondary Skill Data modelling and architecture

Tertiary Skill Python

Required Qualifications

Experience

4 years in data engineering metadata engineering semantic layer development data analysis or business data mapping

Hands-on experience working with Oracle database metadata

Experience connecting business terminology to physical database structures

Experience working with business documentation PDFs data dictionaries and technical metadata

Exposure to natural language to SQL semantic modelling or AI context engineering is strongly preferred

Programming Query Languages

Strong SQL especially Oracle SQL

Intermediate Python for metadata parsing document processing mapping automation and validation

Working knowledge of YAML JSON for structured semantic and mapping artifacts

Basic Markdown for documentation

Optional familiarity with regular expressions for text extraction and term matching

Systems Tools

Oracle Database

Toad for Oracle

Python libraries for metadata and document processing

Git or source control for managing mappings

Excel or CSV for early stage mapping inventories

Knowledge base repository or semantic layer repository

Desired Qualifications

Experience with enterprise process management systems POP ARISSDAR

Exposure to GenAI platforms and LLM based enterprise solutions

Knowledge of regulatory and compliance driven data environments

Experience with data catalog tools vector search graph database or RAG tooling