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

As a Senior Oracle PL/SQL Developer, 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.

Key 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).

Required Skills & Experience

- 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.