Expert-level Oracle PL/SQL

FEDRUS GLOBAL LLC; United States; On-site; USD 120,000 - 150,000; Full time

Job summary

FEDRUS GLOBAL LLC is seeking a skilled data engineer to design, develop, and support Oracle-based ETL pipelines and data warehouse processes. You will ensure reliable data delivery, validation, and reconciliation across multiple source systems while supporting deployments and production needs.

Applicants should excel in Oracle PL/SQL, SQL optimization, Linux scripting, and ETL/warehousing concepts, with strong collaboration and stakeholder communication skills in an Agile environment.

Qualifications

• Expert-level Oracle PL/SQL and Oracle Database engineering.
• Strong SQL performance tuning and query optimization.
• Proficient with Linux, Bash and Unix shell scripting.
• Experience in ETL, data warehousing and data modeling.
• Skilled in pipeline orchestration, job scheduling and dependencies.
• Proven Agile delivery and stakeholder communication.

Responsibilities

• Design, develop, and support Oracle-based ETL pipelines and data warehouses.
• Ensure reliable data integration, validation and reconciliation.
• Provide production support and manage deployments.
• Deliver timely data across multiple source systems.
• Collaborate with stakeholders to maintain agile delivery.

Skills

Agile delivery

Stakeholder communication

Tools

Oracle PL/SQL

Oracle Database

SQL performance tuning

Linux

Bash

Unix shell scripting

ETL

Data warehousing

Data modeling

Pipeline orchestration

Job scheduling

CI/CD for data pipelines

Git

Snowflake

DBT

Job description

Core Role Summary

Design, develop, and support Oracle-based ETL pipelines and data warehouse processes. Ensure reliable data integration, validation, reconciliation, production support, deployments, and timely data delivery across multiple source systems.

Must Have

• Expert-level Oracle PL/SQL
• Oracle Database Engineering
• SQL performance tuning and query optimization
• Linux, Bash, and Unix shell scripting
• ETL and data warehousing
• Data modeling and pipeline orchestration
• Job scheduling and dependency management
• Agile delivery and stakeholder communication

Nice to Have

• Oracle environment migration experience
• CI/CD for data pipelines
• On-prem and cloud data platforms
• Snowflake
• DBT
• Large banking or regulated environment experience
• Git