Senior Oracle PL/SQL Developer - Data Warehouse & Performance Tuning

About the Position

As a Senior Oracle PL/SQL Developer specializing in Data Warehouse & Performance Tuning, you'll operate at the core of our data infrastructure, creating efficient data pipelines and warehouse solutions that transform complex datasets into actionable business insights. You'll collaborate with a distributed team of database specialists, business analysts, and IT professionals to deliver high-performance, scalable database solutions meeting the intricate requirements of modern financial institutions.

Responsibilities

• Design, develop, and optimize complex PL/SQL stored procedures, functions, packages, and triggers for enterprise-grade data warehouse implementations.
• Implement and maintain sophisticated ETL processes using Oracle ODI, Informatica, or equivalent tools to ensure data quality and integrity across disparate systems.
• Create efficient data models and database schemas aligned with business requirements and stringent performance standards.
• Troubleshoot and resolve database performance bottlenecks, optimizing queries and database structures for maximum efficiency.
• Collaborate with cross-functional teams to translate business requirements into precise technical specifications.
• Document database designs, data flows, and technical processes according to organizational standards.
• Participate in code reviews and implement industry best practices for database development.
• Contribute to the continuous evolution of data warehouse architecture and processes.
• Monitor database performance metrics and implement proactive maintenance procedures.
• Ensure data security and compliance with financial industry regulations (including GDPR, PCI DSS, and SOX).

Requirements

• At least 2 years of demonstrable experience as a Data Warehouse Developer or Architect.
• Strong proficiency in Oracle PL/SQL development (Oracle Database 19c or newer).
• Hands-on experience with ETL tools, particularly Oracle ODI and Informatica PowerCenter.
• Working knowledge of CASE-tools for database modeling and design.
• Previous experience in banking or finance sector projects is essential.
• Experience with data migration, transformation, and integration in enterprise environments.
• Familiarity with dimensional modeling concepts (star and snowflake schemas).
• Solid understanding of database performance tuning and query optimization techniques.
• Experience with version control systems and database change management processes.
• Ability to write efficient SQL queries and interpret execution plans.

Core Skills

• Oracle SQL
• Tableau
• ETL
• GDPR
• Power BI

We Offer

• Opportunity to work remotely
• Full-time position with a competitive salary
• Collaborative and innovative work environment
• Professional growth and development opportunities

About the Company

[Company description if present]