Module Lead - Oracle PL/SQL - BFSI Domain
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
Sign in to read and join the discussion.