Reference 26000CD9

Responsibilities

Design, development and testing of components / modules in TPS involving Oracle SQL, PL/SQL, Unix and Java technologies
Perform detailed analysis of business requirements, propose functional solutions, provide effort estimations, support testing cycles, assist in UAT, handle post-production support, and ensure optimal system performance.
Lead transformation initiatives aligned with Northstar/MDLH strategy, collaborating with systems such as DISTRIB, TOP, and multiple source/consumer applications to analyze and propose migration from TPS to target platform (TOP/Data Lake).
Apply strong analytical skills across multiple data domains (e.g., OTC, Listed instruments, Positions, etc.) with a solid understanding of financial instruments.
Support TPS application decommissioning and transition to the target Data Lake architecture involving 60+ source and consumer systems, contributing to analysis, coordination, and execution.
Understand functional requirements and raise clarifications with BAs and others concerned




Should be able to estimate from high level requirement and do an independent estimate from detailed functional specification
Capability to provide technical design and implement on complex requirement
Understand Agile practices (daily scrum, iteration planning, retrospective, test driven, model storming) and follow the same Meticulously review the design, test cases and code
Coding, Unit Testing and Integration Testing
Required

Profile required

Around 4-8 years of experience in IT industry, preferably banking domain
Should possess strong hands-on experience on SQL and PL/SQL
Should have positive knowledge on UNIX
Proven Experience on Partitions, Indexing and code refactoring.
Excellent in-depth knowledge in Cursors, Indexes, Stored Procedures, Functions, Packages, Triggers, Exception Handling.
Good knowledge in Collections, Records, Bulk Collect, Views
Knowledge on Dynamic SQL
Should possess good Troubleshooting skills
Can delive

📌 Lead SE (Bengaluru)
🏢 Societe Generale Global Solution Centre
📍 Bengaluru