Oracle PL/SQL Developer

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, Job Description: Key Responsibilities Business Term and Definition Engineering Review strategic process inventory SPI PDFs business documents data dictionaries and metadata ex…

• 13 hours ago
• Apply easily +

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