Oracle SQL. PL/SQL, Oracle Performance tuning developer_Triton

Job Description

*Triton Development ITG FRESH Liquidity Specialized SolutionsAbout BNP Paribas Group: BNP Paribas Group is a leading European bank with a strong global footprint across 72 markets and more than 202,000 employees. The Group provides corporates, institutional and private investors with product and service solutions tailored to their specific needs. It offers a wide range of financial services covering corporate & institutional banking, wealth management, asset management, insurance, as well as retail banking and consumer financing through strategic partnerships .About BNP Paribas India Solutions:Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas Group, a leading bank in Europe with an international reach. With delivery centers located in Mumbai and Chennai, we are a 24x7 global delivery center. We partner various business lines of BNP Paribas such as Corporate and Institutional Banking, Wealth Management, Retail Banking through three verticals - Information Technology, Operations and Finance Shared Services.About Businessline/Function :The Intermediate Holding Company ( IHC ) program structured at the U.S. level across poles of activities of BNP Paribas provides guidance, supports the analysis, impact assessment and drives adjustments of the U.S. platform s operating model due to the drastic changes introduced by the Enhanced Prudential Standards ( EPS ) for Foreign Banking Organizations ( FBOs ) finalized by the Federal Reserve in February 2014, implementing Section 165 of U.S. Dodd-Frank Act.The Team is part of the Information Technology Group which works simultaneously on a wide range of projects arising from business, strategic initiatives, regulatory changes and reengineering of existing applications to improve functionality and efficiency.Job Title:Oracle SQL. PL/SQL, Oracle Performance tuning developerDate:13-Nov-2020Department:ITG - FRESHLocation:MumbaiBusiness Line / Function:Liquidity Specialized SolutionsReports to:(Direct)Grade:(if applicable)(Functional)Number of Direct Reports:Directorship / Registration:NAPosition PurposeThe role will focus on the Funding and Liquidity IT workstream.Where possible the solution will leverage existing architecture and infrastructure of other systems, but remains a separate segregated system, albeit closely linked to other internal tools.The tool has a strong link to the BNP Paribas group as well since it provides the data for Liquidity regulatory reporting. Triton is built upon an Oracle 12c SQL database (using PL/SQL for business and reporting logic) and reuses a bespoke C#/WinForms reporting front-end. In addition, automated high-level reporting dashboards are produced on a daily basisResponsibilitiesThis role will be primarily Oracle SQL focused but will also require and encourage a significant amount of functional learning around Liquidity and Balance Sheet topics. The role will be responsible for helping in the designing, implementing and supporting the requirements from the sponsors, ensuring consistency with the existing architecture. The candidate will also design and implement new business logic / reports as SQL inside stored procedures within the existing system / reporting framework, as well as enhancing and maintaining existing functionality.This role offers an excellent opportunity to work on a very high-profile regulatory project delivering critical reporting to senior management. Working on this project involves gaining a strong understanding of topics such as balance sheet, liquidity and funding across all product classes from a global perspective.The ability to work very quickly and efficiently but still deliver structured and maintainable solutions is also very important. Knowledge of investment banking products within financial institutions is a definite advantage, as is familiarity with balance sheet and liquidity topics. Applicants should be numerate, enthusiastic, willing to learn about the business and able to communicate clearly.Technical & Behavioral CompetenciesExcellent knowledge of Oracle SQL, PL/SQL (ideally Oracle 10g/11g/12c) Expertise with writing and optimizing stored procedures and query performance Python scripting knowledge is highly recommended Strong design Strong analysis and problem-solving skills Strong interest in financial topics Very high level of motivation Strong communication skills Specific Qualifications (if required) BE/BTech Degree , * Skills Referential aBehavioural Skills:Ability to collaborate / TeamworkAttention to detail / rigorCommunication skills - oral & writtenClient focusedTransversal Skills:Ability to develop others & improve their skillsAnalytical AbilityAbility to inspire others & generate peoples commitmentChoose an item.Choose an item.Education Level: Bachelor Degree or equivalent Experience Level At least 5 years Other/Specific Qualifications (if required)

Keyskills :
oracle sqlsql databasenew businessbalance sheetretail bankingwealth managementstored proceduresanalytical abilityconsumer financingcommunication skillsstrategic initiatives