This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Oracle PLSQL Database Data Engineer – Assistant Vice President is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.
Job Responsibility:
Participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team
Contribute to applications systems analysis and programming activities
Requirements:
8+ years of relevant experience
Very good understanding in Oracle architecture
Strong exposure to Python, Spark, Agentic workflows - Devin, Copilot
Extensively worked on PL/SQL Packages, Procedures, Functions, Triggers, Views, MViews, External tables, partitions and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle
Must have experience in advance PL/SQL, Hints, Cursors to process huge volumes of data, bulk collect for performance improvement process
Must have experience Data Modeling and Warehousing concepts such as Star Schema, OLAP, OLTP, Snowflake schema, Fact Tables for Measurements, Dimension Tables for Descriptive Context, Periodic Snapshot Fact Tables, Junk Dimensions etc.
Hands on experience on SCD Type 1,Type 2,Type 3,Type 4,Type 5,Type 6
Must have very good understanding of Snapshot tables, staging tables, History tables, Audit tables, Granularity, Single Granularity for Facts, Dimension Granularity and Hierarchies, Date Dimension, Degenerate Dimensions, Surrogate Keys, Generalization and Normalization of data, Ragged Hierarchies etc.
Highly proficient in writing complex yet efficient SQL
Knowledge of any data modeling tool
Ability to understand data very quickly
Worked on migration projects
Ability to prioritize and manage schedules under tight, fixed deadlines
Strong writing, communication, time-management, decision-making, and basic task organization skills
Should be able to own and manage the database deliverables.
Should be able to maintain the data dictionaries for large databases
Experience in systems analysis and programming of software applications
Experience in managing and implementing successful projects
Working knowledge of consulting/project management techniques/methods
Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
Bachelor's degree/University degree or equivalent experience