More jobs:
Job Description & How to Apply Below
Were seeking a hands-on PL/SQL developer with strong SQL/PLSQL fundamentals and real-world performance tuning skills to build and optimize data logic for our Loan Origination System (LOS) and Loan Management System (LMS) on Oracle RDS. Youll translate business rules into robust database code, design performant data models and views, and ensure reliable, accurate data flows across underwriting, sanction, disbursal, repayments, and GL.
Key Responsibilities
Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and materialized views for LOS/LMS use cases.
Write complex SQL with window/analytic functions, dynamic SQL, bulk operations (BULK COLLECT / FORALL), and .
Optimize queries using execution plans, , statistics management, indexing strategy, and hints where justified; fix high-latency reports/jobs.
Build and maintain data interfaces (APIs, staging tables, external tables/SQL-Loader-like patterns) to/from upstream/downstream systems.
Implement data quality checks, reconciliation logic (vouchers, receipts, GL postings), and auditable transformations.
Partner with product/credit/ops to translate LOS/LMS rules (eligibility, LTV, ROI/IRR, moratorium, EMI schedules, prepayment/foreclosure, DPD/NPA) into reliable database logic.
Work within Oracle RDS constraints (no OS access) : use snapshots/AWR (where available), parameter-aware tuning, and safe deploy/rollback strategies.
Maintain documentation : ER diagrams, data dictionaries, lineage, runbooks.
Uphold data governance : PII masking, RBAC, least-privilege, auditability, and regulatory compliance.
Must-Have Skills
4- 6 years professional experience with Oracle SQL & PL/SQL in high-volume transactional systems.
Strong in :
Query design &analytic functions
Performance tuning (cardinality, joins, partitions, index types, bind variables, PLAN stability)
PL/SQL patterns (packages, error handling, collections, bulk processing, pipelined functions)
, , ,
Hands-on with Oracle RDS (parameter groups, snapshots/backups, access controls, limitations vs on-prem).
Version control & CI basics (Git, code review, branching);
Jira/Confluence or similar.
Clear, concise communication with product/credit/ops.
(t.tech)
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
×