Oracle PL/SQL Developer

Westlake, TX, US • Posted 4 hours ago • Updated 4 hours ago
Full Time
No Travel Required
On-site
$90,000 - $110,000/yr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • PL/SQL
  • Oracle
  • Performance Tuning
  • Stored Procedures
  • Modeling
  • Extract, Transform, Load
  • Data Warehouse
  • Business Intelligence
  • Data Engineering
  • Data Integration
  • Relational Databases

Summary

Oracle PL/SQL Developer

Introduction:

This position involves working as an Oracle PL/SQL Developer within our team. The role requires expertise in writing complex SQL queries using Oracle, as well as strong knowledge of Oracle PL/SQL, ETL tools, scripting, data warehousing, data integration, and business intelligence.

Responsibilities:

  • Write complex SQL queries using Oracle
  • Develop and maintain Oracle PL/SQL stored procedures, functions, packages, and triggers
  • Utilize ETL tools like Informatica for data extraction, transformation, and loading
  • Create scripts and automate processes using Unix, Python in a Data Engineering environment
  • Implement performance tuning techniques for Oracle databases
  • Apply data warehousing patterns and dimensional modeling techniques using Oracle
  • Build scalable data integration patterns for cloud-based and on-prem environments
  • Utilize batch scheduling tools like Control-M, Autosys for job scheduling
  • Work with business intelligence and analytics tools such as OBIEE/OAS
  • Use GitHUB for Source Code Management (SCM) in a Data Engineering Practice

Requirements:

Required Skills:

  • Expert-level knowledge of writing complex SQL queries using Oracle
  • Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, Packages, Triggers)
  • Strong working experience in ETL tools like Informatica
  • Working experience in scripting and automation using Unix, Python
  • Extensive experience with Relational Databases like Oracle including performance tuning
  • Strong knowledge of Data warehousing patterns and Dimensional Modeling techniques using Oracle
  • Experience building scalable patterns for data integration in cloud-based and on-prem environments
  • Working knowledge of Batch scheduling tools like Control-M, Autosys
  • Experience with business intelligence and analytics tools such as OBIEE/OAS
  • Working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10115393
  • Position Id: 9079604
  • Posted 4 hours ago
Contact the job poster
SS

Sreevalsan Sreekumaran

Senior Consultant-HR @ Virtusa Corporation
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Westlake, Texas

Today

Easy Apply

Full-time

Depends on Experience

Westlake, Texas

Today

Easy Apply

Full-time

Depends on Experience

Dallas, Texas

Today

Easy Apply

Full-time

105000 - 115000

Westlake, Texas

6d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs