Senior PL/SQL Developer - ODS

Codeninja; Riyadh; On-site; SAR 300,000 - 420,000; Full time

Job summary

CodeNinja is seeking a Senior PL/SQL Developer to join a leading Saudi bank's technology team. You will design and maintain high-performance data solutions for the Operational Data Store (ODS), working on complex data pipelines feeding core banking systems into the ODS.

The ideal candidate has 7+ years of Oracle PL/SQL development experience, strong Oracle DB tuning skills, and hands-on experience with banking data environments.

Qualifications

• 7+ years Oracle PL/SQL development experience.
• Experience with Oracle Database 11g/12c/19c, including performance tuning.
• Strong understanding of data warehousing/ODS concepts, ETL processes, and data modeling.
• Experience working with large-scale banking data (core banking, AML, or similar).
• Proficiency in shell scripting (Unix/Linux) for job scheduling and automation.
• Strong analytical skills with high attention to data accuracy and completeness.

Responsibilities

• Design, develop, and optimize complex PL/SQL packages, stored procedures, functions, and triggers.
• Build and maintain ETL/data-load routines feeding the ODS from core banking and source systems.
• Perform SQL and PL/SQL performance tuning, query optimization, and execution-plan analysis.
• Design data models and support data mapping, transformation, and reconciliation activities.
• Ensure data quality, integrity, and consistency across ODS and downstream reporting systems.
• Collaborate with business and technical teams to gather data requirements and translate them into database solutions.
• Troubleshoot and resolve production data issues within agreed SLAs.
• Prepare technical documentation, data dictionaries, and unit/system test cases.

Skills

Oracle PL/SQL

Performance tuning

Unix/Linux shell scripting

Data warehousing

ETL processes

Banking data

Analytical skills

Tools

ODI

Informatica

Job description

About CodeNinja

CodeNinja is a full-stack AI and engineering delivery firm helping Saudi enterprises, software acquirers, and government entities modernize systems and operationalize intelligence across mission-critical workflows. Through embedded engineering teams, AI labs, and global capability centers, CodeNinja delivers autonomous workflows, AI-native infrastructure, and bespoke models aligned with Saudi Arabia's Vision 2030. Trusted by 240+ organizations across the region, CodeNinja partners with leading financial services, government, energy, and logistics institutions to build engineering capability that stays owned by the client, not the vendor.

About the Role

We are looking for a Senior PL/SQL Developer to join a leading Saudi bank's technology team, designing and maintaining high-performance data solutions for the Operational Data Store (ODS) environment. This is a hands-on, delivery-focused role suited to a developer with strong Oracle PL/SQL depth and prior exposure to banking or financial-services data environments, who can work independently on complex data pipelines feeding core banking systems into the ODS.

Key Responsibilities

• Design, develop, and optimize complex PL/SQL packages, stored procedures, functions, and triggers.
• Build and maintain ETL/data-load routines feeding the ODS from core banking and source systems.
• Perform SQL and PL/SQL performance tuning, query optimization, and execution-plan analysis.
• Design data models and support data mapping, transformation, and reconciliation activities.
• Ensure data quality, integrity, and consistency across ODS and downstream reporting systems.
• Collaborate with business and technical teams to gather data requirements and translate them into database solutions.
• Troubleshoot and resolve production data issues within agreed SLAs.
• Prepare technical documentation, data dictionaries, and unit/system test cases.

Requirements

• 7+ years of hands-on Oracle PL/SQL development experience.
• Strong experience with Oracle Database (11g/12c/19c), including performance tuning and indexing strategies.
• Solid understanding of data warehousing/ODS concepts, ETL processes, and data modeling.
• Experience working with large-scale banking data (core banking, CRM, AML, or similar).
• Proficiency in shell scripting (Unix/Linux) for job scheduling and automation.
• Strong analytical skills with high attention to data accuracy and completeness.

Must-Haves

• 7+ years Oracle PL/SQL development
• Prior banking/financial-services experience (mandatory)
• Oracle DB performance tuning expertise
• Unix/Linux shell scripting

Nice-to-Haves

• Experience with ETL tools (ODI, Informatica)
• Exposure to BI/reporting tools consuming ODS data
• Knowledge of banking regulatory reporting requirements

Why Join Us

• Work on a mission-critical data environment for a leading Saudi bank, with direct exposure to core banking, AML, and enterprise-scale ODS architecture.
• Be part of CodeNinja's embedded engineering model — deployed within client governance and workflows, not managing tickets at a distance.
• Competitive contract compensation with strong potential for extension based on performance and project scope.
• Opportunity to work alongside a team recognized among Clutch's 100 Fastest-Growing Technology Companies of 2026.

Disclaimer

This job description outlines the general nature and level of work to be performed. It is not an exhaustive list of all responsibilities, duties, and skills required. CodeNinja reserves the right to amend, add, or remove duties as business needs evolve. Final terms of engagement, including compensation and contract duration, are subject to client approval and mutual agreement between the candidate and CodeNinja.