Upload Button Icon Add office photos

BNP Paribas

Compare button icon Compare button icon Compare

Filter interviews by

BNP Paribas Plsql Developer Interview Questions and Answers

Updated 24 Oct 2024

BNP Paribas Plsql Developer Interview Experiences

2 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic questions about sql and PLSQL topics
  • Q2. Scenario based questions and write few sql queries
Round 2 - Technical 

(2 Questions)

  • Q1. Performance tuning related questions
  • Q2. Explain project details

Plsql Developer Interview Questions & Answers

user image Sriram Bhoopalan

posted on 13 Oct 2023

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Performance tunings?
  • Q2. Real time experience with query
  • Ans. 

    I have experience writing complex queries to retrieve specific data from databases in real-time.

    • Utilized subqueries and joins to extract data efficiently

    • Optimized queries for performance by using indexes and proper indexing techniques

    • Worked with large datasets and optimized queries to reduce response time

    • Used analytical functions like ROW_NUMBER() and RANK() to analyze data

  • Answered by AI

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q2. What is temp table and temp variable in plsql?
asked in TCS
Q3. A plsql programme to print 103,99,96...3?
asked in TCS
Q4. What is mutating table or mutating trigger?
asked in TCS
Q5. How do you find if two table having similer data

Interview questions from similar companies

I applied via Referral and was interviewed in Sep 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. How many years on Database design experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare all core concepts and if you have banking knowledge it will help

Interview Questionnaire 

2 Questions

  • Q1. Demonetization
  • Q2. Banking sector questions

Interview Preparation Tips

Round: Test
Experience: Basic aptitude test. East to clear.
Duration: 1 hour
Total Questions: 25

Skills: Reasoning Ability, Mathematical Logic, Logical Reasoning, General Knowledge
College Name: Sri Bhagawan Mahaveer Jain

I applied via Referral

Interview Questionnaire 

4 Questions

  • Q1. Brief introduction,,
  • Q2. Why markets?
  • Ans. 

    Markets offer dynamic and challenging environments that require constant adaptation and innovation.

    • Markets provide opportunities for growth and expansion

    • Competition in markets drives innovation and efficiency

    • Markets offer diverse career paths and opportunities for personal development

  • Answered by AI
  • Q3. 2-3 puzzles,
  • Q4. Economics questions

Interview Preparation Tips

Round: Technical Interview
Experience: No. of Interviews: 1
I think they were looking for Mathematical and analytical ability, Awareness about and aptitude for finance related stuff (news items, their analysis, my understanding etc.)

Tips: Being prepared: In markets there is no substitute to knowing your stuff. You can‟t faff your way through as the questions will be technical

Skills: Financial Markets, Aptitude, Analytical Skills, Mathematical Aptitude
College Name: IIM Bangalore

I applied via Naukri.com and was interviewed before Jun 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. It was more about the personal and case study which they asked me

Interview Preparation Tips

Interview preparation tips for other job seekers - To Start of with this company it's good one to start your career you have lot opportunities and benefits from this company.
I would suggest if got an opportunity with this firm go ahead

I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. General personality based question set
Round 3 - One-on-one 

(1 Question)

  • Q1. Range of interviews with seniors, all personality based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - in my experience, it was more about finding a personality fit as it was a starting associate position

Associate Interview Questions & Answers

JPMorgan Chase & Co. user image SHUBHAM VINAYAK KALE shubham

posted on 4 Dec 2016

I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. Project/DDP based questions
  • Q2. Any coding done in curriculum, explain the most complex one
  • Ans. 

    Yes, I have coded in curriculum. The most complex one was a project on building a web application using React and Node.js.

    • Built a full-stack web application using React and Node.js

    • Implemented user authentication and authorization using JSON Web Tokens (JWT)

    • Used MongoDB as the database and Mongoose as the ODM

    • Implemented real-time updates using Socket.IO

    • Deployed the application on Heroku

    • Handled errors and implemented log

  • Answered by AI
  • Q3. What is 'Big data'? Why is it called 'Big'
  • Ans. 

    Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.

    • Big data is characterized by its volume, velocity, and variety

    • It is used in various industries such as healthcare, finance, and retail

    • Examples of big data include social media data, sensor data, and transactional data

    • It is called 'big' because it involves processing massive amounts of data

    • Big data requires ...

  • Answered by AI
  • Q4. Why do you want to switch to IT sector from your respective branch
  • Ans. 

    I am passionate about technology and eager to learn new skills in the IT sector.

    • I have always had a keen interest in technology and enjoy working with computers.

    • I believe the IT sector offers more opportunities for growth and advancement in my career.

    • I have seen the impact of technology on various industries and want to be a part of that innovation.

    • I have taken courses in programming and networking to prepare myself fo

  • Answered by AI
  • Q5. I did a course on compute simulation and had extra curricular in chess, so was asked to simulate a chess game
  • Q6. Two friends A & B meet after long time, A asks B about his family. B says he has 3 children, product of their ages is 36, and sum of their ages is equal to the (point towards a house on street) house numbe...
  • Q7. A rat has 3000 gm of rice, he has to travel a distance of 3000m, he eats 1gm rice/m, his maximum carrying capcity is 1000 gm,how should he travel the distance to reach with maximum rice left
  • Q8. A new software has 3 functions SelectSum(), log() and exp(). You have a table of 1000 data points, how will you find product of all points using only the above mentioned functions
  • Ans. 

    To find the product of all data points using SelectSum(), log(), and exp() functions.

    • Use the log() function to convert the product into a sum of logarithms

    • Apply the SelectSum() function to calculate the sum of logarithms

    • Finally, use the exp() function to convert the sum back into the product

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Aptitude part has easy questions, including number series, picture series, interest rate and some quant based questions.

The coding part is difficult.2-3 coding questions, Codes will be related to linked lists , trees or sorting.
Tips: Try to get maximum marks in aptitude, which should be fine with some practice . One of the code will be easy, so complete it and make a try for second
Duration: 1 hour
Total Questions: 30

Round: Puzzle Interview
Experience: very easy puzzles, I was able to solve all puzzles in first attempt
Tips: Be confident in your approach they are locking for approach more than result

Round: Technical Interview
Experience: I answered all resume based questions, he liked my choice of projects, though they were not exactly related to the profile. He liked me and said I would recommend you directly to HR round
Tips: Prepare in details about all points in resume, course work mentioned and projects, Based on performance in this interview, they decide to whether to take one more technical interview or send directly to HR

Skills: Behavioural Skills, Puzzle Solving Capability, Approaching A Problem, Basic Coding
College Name: IIT Madras

Skills evaluated in this interview

I appeared for an interview in Dec 2016.

Interview Questionnaire 

5 Questions

  • Q1. Write the algorithm for reversing the string
  • Ans. 

    The algorithm reverses a given string.

    • Iterate through the string from the last character to the first character.

    • Append each character to a new string or an array in reverse order.

    • Return the reversed string or array.

  • Answered by AI
  • Q2. Write an algorithm to select the number between min and maximum from a number series and that number shouldn't be a multiple of 10
  • Q3. This was puzzle: you have 2 eggs and 100 floors. Eggs will start break beyond a particular floor. You can throw eggs from any of the floor. How will you minimise the total number of throws.
  • Q4. Assume yourself as CEO of a company. You have vacancies and you are conducting interviews. 4 candidates (1. An IITian, 2. A woman, 3. Gay, 4.Physically handicapped) are equally capable and qualified have a...
  • Ans. 

    As the CEO, I would select the candidate based on their qualifications and skills, regardless of their background or personal characteristics.

    • I would focus on the qualifications, skills, and experience of each candidate.

    • I would consider their ability to contribute to the company's goals and objectives.

    • I would ensure a fair and unbiased selection process.

    • I would prioritize diversity and inclusion in the workplace.

    • I woul...

  • Answered by AI
  • Q5. My interview was just after demonetization. So question was, assume you are CEO of Paytm. What will be your key values and what will be your strategy to add more customers.

Interview Preparation Tips

Round: Test
Experience: Aptitude part was pretty straightforward. Make sure you don't loose too much time on one question. Most of the questions were very easy. Number series, men working hours, probability and simple math calculations are enough to crack the test.
Coding part will definitely have one easy question (mostly will be on sorting algos). Basic coding knowledge is enough for this part.
Tips: Aptitude : Speed is the key. Since questions are easy, one who gets more than others will be shortlistled for the Interviews.
Coding: Make sure you solve atleast 1 problem correctly. And then try to attempt others.
Duration: 1 hour
Total Questions: 28

Round: Behavioural Interview
Experience: They also asked basic interview hr questions. Be prepared with your stories. If One of your story can make you look out of the stand, it will definitely work for this round. Strengths, weakness and where do you see yourself after 5 years.
Tips: Be confident. And be ready to defend your answers.

Skills: Math Puzzles, Algorithms And Data Structures, HR Skills, Inter Person Communication Skills
College Name: IIT Madras

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Dec 2016. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Tested DSA and Aptitude
  • Q2. Checked design aspect questions
  • Q3. What do you know about company
  • Ans. 

    Company is a global technology company known for its innovative products and services.

    • Founded in 1976 by Steve Jobs, Steve Wozniak, and Ronald Wayne.

    • Known for products such as iPhone, iPad, Mac computers, and Apple Watch.

    • Offers services like Apple Music, iCloud, and Apple Pay.

    • Has a strong focus on design and user experience.

  • Answered by AI

Interview Preparation Tips

College Name: IIT Madras

BNP Paribas Interview FAQs

How many rounds are there in BNP Paribas Plsql Developer interview?
BNP Paribas interview process usually has 2 rounds. The most common rounds in the BNP Paribas interview process are Technical and Resume Shortlist.
How to prepare for BNP Paribas Plsql Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at BNP Paribas. The most common topics and skills that interviewers at BNP Paribas expect are Financial Services, Performance Tuning, PLSQL, Retail Banking and Data Management.
What are the top questions asked in BNP Paribas Plsql Developer interview?

Some of the top questions asked at the BNP Paribas Plsql Developer interview -

  1. Real time experience with qu...read more
  2. Basic questions about sql and PLSQL top...read more
  3. Scenario based questions and write few sql quer...read more

Tell us how to improve this page.

BNP Paribas Plsql Developer Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 570 Interviews
Citicorp Interview Questions
3.7
 • 568 Interviews
HSBC Group Interview Questions
3.9
 • 487 Interviews
American Express Interview Questions
4.2
 • 364 Interviews
BNY Interview Questions
3.9
 • 346 Interviews
UBS Interview Questions
3.9
 • 336 Interviews
Morgan Stanley Interview Questions
3.7
 • 291 Interviews
View all
BNP Paribas Plsql Developer Salary
based on 8 salaries
₹4.5 L/yr - ₹16 L/yr
60% more than the average Plsql Developer Salary in India
View more details
Senior Associate
2.1k salaries
unlock blur

₹3.6 L/yr - ₹14.5 L/yr

Assistant Manager
1.4k salaries
unlock blur

₹5.9 L/yr - ₹24 L/yr

Associate 1
999 salaries
unlock blur

₹2.5 L/yr - ₹10 L/yr

Associate
830 salaries
unlock blur

₹2 L/yr - ₹8 L/yr

Manager
483 salaries
unlock blur

₹8 L/yr - ₹30 L/yr

Explore more salaries
Compare BNP Paribas with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

HSBC Group

3.9
Compare

Cholamandalam Investment & Finance

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview