About BNP Paribas India Solutions:
Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, European Union’s leading bank with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 10000 employees, to provide support and develop best-in-class solutions.
About BNP Paribas Group:
BNP Paribas is the European Union’s leading bank and key player in international banking. It operates in 65 countries and has nearly 185,000 employees, including more than 145,000 in Europe. The Group has key positions in its three main fields of activity: Commercial, Personal Banking & Services for the Group’s commercial & personal banking and several specialised businesses including BNP Paribas Personal Finance and Arval; Investment & Protection Services for savings, investment, and protection solutions; and Corporate & Institutional Banking, focused on corporate and institutional clients. Based on its strong diversified and integrated model, the Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporates and institutional clients) to realize their projects through solutions spanning financing, investment, savings and protection insurance. In Europe, BNP Paribas has four domestic markets: Belgium, France, Italy, and Luxembourg. The Group is rolling out its integrated commercial & personal banking model across several Mediterranean countries, Turkey, and Eastern Europe. As a key player in international banking, the Group has leading platforms and business lines in Europe, a strong presence in the Americas as well as a solid and fast-growing business in Asia-Pacific. BNP Paribas has implemented a Corporate Social Responsibility approach in all its activities, enabling it to contribute to the construction of a sustainable future, while ensuring the Group's performance and stability
Commitment to Diversity and Inclusion
At BNP Paribas, we passionately embrace diversity and are committed to fostering an inclusive workplace where all employees are valued, respected and can bring their authentic selves to work. We prohibit Discrimination and Harassment of any kind and our policies promote equal employment opportunity for all employees and applicants, irrespective of, but not limited to their gender, gender identity, sex, sexual orientation, ethnicity, race, colour, national origin, age, religion, social status, mental or physical disabilities, veteran status etc. As a global Bank, we truly believe that inclusion and diversity of our teams is key to our success in serving our clients and the communities we operate in.
About Business line/Function:
Securities services department of CIB
Job Title:
PLSQL Developer
Date:
14-Nov-2024
Department:
Securities Services
Location:
Chennai
Business Line / Function:
Banking Services
Reports to:
(Direct)
Project Manager (Direct)
Grade:
(if applicable)
(Functional)
Number of Direct Reports:
Directorship / Registration:
NA
Position Purpose
The PLSQL developer will be responsible to:
- Design and Develop the code using Oracle SQL and PLSQL technologies for the requirement given
- Deliver and Deploy the unit tested code into the IST , UAT Environments
- To optimize the code for maintenance and performance of the application
- Provides training and knowledge sharing with the development team
-
Responsibilities
Direct Responsibilities
Oracle Developer will be performing:
- Consistent work experience of 9-12 years in Oracle SQL and PL/SQL development.
- Develop schemas, tables, indexes, sequences, constraints, functions, and procedures, Packages, Collections, Users and Roles.
- Understand business requirements and accordingly develop database models.
- Provide optimal design solutions to improve system quality and efficiency.
- Follow best practices for database design.
- Perform capacity analysis and oversee database tuning.
- Maintain technical documentations for reference purposes.
- Write complex codes and queries and participate in code reviews.
- Perform design review, modify codes and test upgrades.
- Work closely with other developers to improve applications and establish best practices.
- An ability to understand front-end users requirements(Java) and a problem-solving attitude
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
- Provide training and knowledge sharing with the development team.
- Maintains all databases required for development, testing, Pre-Production and production usage.
- Takes care of the Database design and implementation.
- Implement and maintain database security (create and maintain users and roles, assign privileges).
- Performance tuning and monitoring, proactively propose solutions.
- Perform Data anonymization
Direct Responsibilities
Oracle Developer will be performing:
- Consistent work experience of 9-12 years in Oracle SQL and PL/SQL development.
- Develop schemas, tables, indexes, sequences, constraints, functions, and procedures, Packages, Collections, Users and Roles.
- Understand business requirements and accordingly develop database models.
- Provide optimal design solutions to improve system quality and efficiency.
- Follow best practices for database design.
- Perform capacity analysis and oversee database tuning.
- Maintain technical documentations for reference purposes.
- Write complex codes and queries and participate in code reviews.
- Perform design review, modify codes and test upgrades.
- Work closely with other developers to improve applications and establish best practices.
- An ability to understand front-end users requirements(Java) and a problem-solving attitude
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
- Provide training and knowledge sharing with the development team.
- Maintains all databases required for development, testing, Pre-Production and production usage.
- Takes care of the Database design and implementation.
- Implement and maintain database security (create and maintain users and roles, assign privileges).
- Performance tuning and monitoring, proactively propose solutions.
- Perform Data anonymization
Contributing Responsibilities
· Work in duet with our offshore and in-site technical team to coordinate the database initiatives.
· Perform detailed technical analysis with impacts (technical/functionally) and prepare Technical specification document.
· Mentor and carry out database peer code reviews of development team.
· Bug fixing & performance optimization
· Keep the development team up-to-date about the best-practices and in-site feedbacks.
· Challenge the time-response performance and the maintainability of the treatments/queries.
· Maintains data standards and security measures and anonymize Production data and import in Development and Testing environments.
· Performance tuning and Monitoring of All databases and proactively propose solutions in case of issues.
Develop and unit test the code :
· Develop the Code to suffice the business requirements
· Unit test the code and bug fix all the defects arising out of the unit testing
· Properly check in the code to avoid issues arising out of configuration management
Deploy and Integrate test the application Developed :
· Deploy the developed code into the IST Environments and perform the Integration testing by working with the cross teams
· Fix all the defects arising out of IST and UAT Testing.
Keep the development team up-to-date about the best practices and feedbacks.
Technical & Behavioral Competencies
· Knowledge and/or experience of the financial services industry
· Good understanding of software development life cycle and Agile/Iterative methodology
· Technical competency in the following:
- Experience in SQL and PL/SQL development - Oracle Database
- Good understanding of ER Diagrams, Data Flows
- Good to have experience on DB design & modelling
- Hands-on on performance tuning tools
· Ability to perform technical analysis, design and identify impacts (functional/technical)
· Good Debugging Skills
Prior experience in High Volume / Mission critical Systems is a plus9
Specific Qualifications (if required)
Skills Referential
Behavioural Skills: (Please select up to 4 skills)
Ability to collaborate / Teamwork
Decision Making
Ability to deliver / Results driven
Ability to share / pass on knowledge
Transversal Skills: (Please select up to 5 skills)
Ability to anticipate business / strategic evolution
Analytical Ability
Ability to understand, explain and support change
Ability to develop and adapt a process
Ability to manage / facilitate a meeting, seminar, committee, training…
Education Level:
Bachelor Degree or equivalent
Experience Level
At least 10 years
Other/Specific Qualifications (if required)
9-12 years of experience as an Oracle PLSQL developer
