19 Nov
|
Ladders Up Hr Solutions
|
Noida
19 Nov
Ladders Up Hr Solutions
Noida
Module Lead - Oracle PL/SQL Engineering (Core Banking / BFSI)Software Engineering Group - Banking, Financial Services & Insurance (BFSI) PracticeTeam Size Led : 3 - 4 EngineersRole 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. (ref:hirist.tech)
📌 Module Lead - Oracle PL/SQL - BFSI Domain (Noida)
🏢 Ladders Up Hr Solutions
📍 Noida