Description

Design, develop, and optimize complex Oracle PL/SQL solutions for a data warehouse environment.

Responsibilities

• Develop and maintain high-performance Oracle PL/SQL code using 12c or 19c features.
• Implement job logging, exception handling, and performance tuning strategies.
• Analyze and resolve data discrepancies within the data warehouse.
• Troubleshoot production issues and optimize query performance for large-scale datasets.
• Collaborate with team members to deliver scalable database solutions.

Required Skills

• 15+ years of total software development experience.
• 12+ years of strong development experience using Oracle PL/SQL.
• Deep expertise with Oracle 12c or 19c database versions.
• Proven experience in a Data Warehouse environment (5+ years).
• Strong analytical skills for resolving data discrepancies.
• Proficiency in performance tuning and troubleshooting complex SQL queries.
• Experience with Analytical functions, Merge statements, WITH clauses, and Table partitioning.

Preferred Skills

• Effective communication and team collaboration skills.

Key Skills

Education

Not specified