Senior PL/SQL Developer - ODS
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
CodeNinja Inc. is seeking 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.
Key Skills for This Role
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
- Experience with ETL tools (ODI, Informatica) is a plus
- Exposure to BI/reporting tools consuming ODS data is a plus
- Knowledge of banking regulatory reporting requirements is a plus
Full Job Posting
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.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at CodeNinja Inc.
Senior IBM App Connect Developer - Middleware
Riyadh, KSA
CodeNinja is seeking a Senior IBM App Connect Developer to design and build enterprise integration solutions for a leading Saudi bank. The role requires deep IBM ACE/IIB expertise and prior banking-sector delivery experi
Senior Java Backend Developer (Spring Boot / Quarkus / API)
Riyadh, KSA
CodeNinja seeks a Senior Java Backend Developer with expertise in Spring Boot or Quarkus and IBM API Connect to build scalable microservices and APIs. The role involves designing, developing, and maintaining backend syst
Senior IBM Business Automation Workflow (BAW) Developer - BPMS
Riyadh, KSA
CodeNinja is seeking a Senior IBM BAW Developer for a 6-month onsite contract with a leading bank in Riyadh. The role involves designing and building enterprise business process automation solutions using IBM BAW/BPM, in
AI Solution Architect
Riyadh, KSA
We are seeking an AI Solution Architect to translate complex banking business needs into scalable, secure enterprise AI system blueprints. This role owns end-to-end technical delivery from design through production deplo
Technical IT Project Manager (Construction Software & Mobile Apps)
Riyadh, KSA
CodeNinja Inc. seeks a Technical IT Project Manager to lead development and deployment of construction software and mobile apps. The role requires 5+ years of IT project management experience in construction/PropTech, st
Full Stack Flutter Developer
Riyadh, KSA
CodeNinja Inc. seeks a Full-Stack Engineer with strong Flutter expertise to build cross-platform mobile apps and backend services for a construction industry startup. The role involves developing scalable features, integ
Senior Solution Architect
Riyadh, KSA
CodeNinja Inc. seeks an experienced Senior Solution Architect to lead enterprise-scale technology solution design and governance. The role involves translating business requirements into technical solutions, designing cl
Mid-Level BI Developer (Power BI & OFSAA)
Riyadh, KSA
CodeNinja Inc. is seeking a Mid-Level BI Developer with 5+ years of experience to design, develop, and maintain Power BI dashboards and reports for the OFSAA team in Riyadh. The role involves data modeling, SQL, and stak
Senior IBM App Connect Developer - Middleware
Riyadh, KSA
Senior Java Backend Developer (Spring Boot / Quarkus / API)
Riyadh, KSA
Senior IBM Business Automation Workflow (BAW) Developer - BPMS
Riyadh, KSA
AI Solution Architect
Riyadh, KSA
Technical IT Project Manager (Construction Software & Mobile Apps)
Riyadh, KSA
Full Stack Flutter Developer
Riyadh, KSA
Senior Solution Architect
Riyadh, KSA
Mid-Level BI Developer (Power BI & OFSAA)
Riyadh, KSA