Position Purpose

The opening is for a PL/SQL Developer who can analyze, design, and develop for the upcoming changes to the existing as well as new asset within division.

This role is technology oriented, which includes defining development methodologies, hands on development for new projects/evolutions, support, providing technical solutions and performing POC for new relevant frameworks available in market.

Knowledge and experience in the Wealth Management (Private Banking) domain is a good to have. (Credit and Risk functions).

Responsibilities

Direct Responsibilities

·        Write technical specifications (DB and UNIX).

·        Propose technical solutions and improvements proactively, based on pros and cons after analysis of the various options complying to BNPP standards and guidelines.

·        Development of Oracle Stored procedures, Unix scripts, BI4 Reports

·        Prepare technical deliveries and support implementation by integration teams.

·        Contribute to key, strategic and support projects

o   Work with the Business Analyst and Solution architects to understand the business requirements and translate them to technical solutions in the application.

o   Perform quality Unit, Integration tests (Test & Business Driven Development is preferred.)

o   Assist test team in performance & endurance testing.

o   Contribute / review technical specifications.

o   Prepare technical deliveries and support implementation by integration teams following the processes and tools of the bank.

o   Contribute to key and strategic projects.

o   Follow scrum agile ceremonies with discipline and responsibility

Contributing Responsibilities

• Provide guidance to team members and work
• Participate to recruitment, onboard and train new comers
• Perform quality reporting and controls in line with BNP PARIBAS standards & security

Technical & Behavioral Competencies

·        Expert in PL/SQL, Oracle database and Unix Shell Scripting

·        Strong PL/SQL skill – ability to write efficient, complex queries against very large data sets and complex business requirements

·        Analyze existing packages and able to debug

·        Oracle Pl/SQL, SAP BI4, PowerBuilder

·        Performance Tuning and Query optimization

·        Demonstrates analytical and problem-solving skills

·        Experience in preparing technical and functional test cases

·        Able to work independently

Behavioral Competencies:

•  Strong critical thinker with problem solving aptitude. 

•  Excellent written and oral communication skills.

•  Responsible, autonomous and provide regular updates to the lead

•  Strong quality mindset

Specific Qualifications (if required)

·        Experience in Unix commands

Good to have

•      Knowledge on Credit Risk

o     Financial Instruments

o     Rating for Financial Instruments and Rating Agencies

o     Derivative products: FX Forwards, FX Options, Equity Options

o     WM products like Credit Lines, Loans etc.,

o     Regulatory

•      Knowledge on Financial Instruments:

o     Different types of instruments

o     Referential data

o     Prices, Ratings, Exchange rates, Money Market rates

o     Underlying assets, Indices

•      Knowledge on Agile/Scrum Practices