Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Ladders UP HR solutions

NewBe an early applicant

Module Lead - Oracle PL/SQL - BFSI Domain

Posted Updated

Description

Module Lead - Oracle PL/SQL Engineering (Core Banking / BFSI)

Software Engineering Group - Banking, Financial Services & Insurance (BFSI) Practice

Team Size Led : 3 - 4 Engineers

Role Summary :

We're hiring a Module Lead to own the design, build, and performance of Oracle-based backend components that power core banking and financial-services applications. You'll write and tune production PL/SQL - packages, procedures, triggers, and bulk-processing jobs - that move real money and real transactions, and you'll lead 3 - 4 engineers through the full delivery cycle from requirement breakdown to go-live support.

What you'll actually be doing :

- Solution design : translating functional requirements from Business Analysts into a technical design - data model impact, package/procedure boundaries, and rollback strategy.

- Core development : developing and maintaining PL/SQL packages, stored procedures, functions, and triggers for transaction processing, batch settlement, and end-of-day (EOD) jobs.

- Performance tuning : reading execution plans, fixing bad joins and missing indexes, and using AWR/ADDM output to bring long-running batch jobs back inside their SLA window.

- Quality gates : writing and reviewing unit tests (utPLSQL or equivalent), enforcing coding standards in code reviews, and signing off before promotion to UAT/production.

- Deployment & support : planning cutover windows, running data migration/reconciliation scripts, and providing L2/L3 support immediately after go-live.

- Team leadership : owning day-to-day technical direction for 3 - 4 engineers - splitting work into a realistic WBS, unblocking them on schema or logic issues, and reviewing their code.

- Client interface : sitting in client calls to explain technical trade-offs in plain language, and giving realistic effort estimates.

Technical Skills - Must Have :

- Oracle PL/SQL : Packages, stored procedures, functions, triggers, cursors, collections, bulk collect/FORALL, exception handling (4 yrs)

- SQL : Complex joins, analytic/window functions, DML/DDL/DCL, query rewriting for performance (4 yrs)

- Performance Tuning : Reading execution plans, indexing strategy, partitioning, AWR/ADDM/SQL Trace (3 yrs)

- Dev & Debug Tooling : TOAD, PL/SQL Developer, Oracle SQL Developer (4 yrs)

- Batch & Scheduling : Exposure to job schedulers (Control-M / Autosys / DBMS_SCHEDULER) (2 yrs)

- Version Control : Git or SVN for branching, merging, and release packaging (2 yrs)

- BFSI systems : prior work on a core banking platform (e.g., Finacle, Flexcube, T24) or a payments/settlement engine.

- ETL / data movement : exposure to Informatica, ODI, or shell-scripted ETL.

- Scripting : comfortable in Unix/Linux for log tracing, cron-adjacent scheduling, and file-based interfaces.

- Delivery method : has worked a delivery under Agile/Scrum - sprint planning, estimation in story points.

Qualifications :

- B.E. / B.Tech / MCA or equivalent.

- 4 - 8 years hands-on Oracle PL/SQL development, with at least one full project life-cycle.

- Prior experience in Banking & Financial Services is strongly preferred.

- Comfortable presenting technical decisions directly to client stakeholders.

Skills

Apply

See also