Description
You will serve as a Data Engineer supporting the proprietary Oracle Application.
Responsibilities
- Develop and maintain database components within the Oracle application lifecycle.
- Write and optimize high-performance SQL queries across large datasets.
- Implement ETL functions using external tables, UTL_FILE, and SQL Loader.
- Develop and manage stored procedures, functions, and triggers using PL/SQL.
- Utilize LINUX shell scripting for operational tasks.
Required Skills
- 8+ years of professional experience.
- Deep coding experience in Oracle PL/SQL (packages, procedures, functions, triggers).
- Expertise in creating and analyzing high-performance SQL queries.
- Proficiency with ETL processes, Big Data concepts, and SQL.
- Experience with Cloud environments, specifically AWS.
- Familiarity with Python.
- Knowledge of Oracle Scheduler integration and Dynamic SQL/BULK Collection.
- Experience with Git tools (e.g., GitLab, SourceTree).
- Database development using tools like Quest Toad for Oracle.