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 experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via AmbitionBox and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What challenge you faced in the professional environment and how you resolved it?
  • Q2. How your prior work experience relates to this role requirement?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Coding Test 

The assessment consisted of two moderate-level questions related to data structures and algorithms, focusing on strings and 2D arrays, within a time frame of 45 minutes. In the web development section, there were 15 questions each from React and Angular.

Round 2 - Technical 

(2 Questions)

  • Q1. What is object-oriented programming (OOP), and can you explain the concepts of shallow copy and deep copy? Additionally, what technology stack would you choose for a project, and what are the reasons behin...
  • Ans. 

    OOP is a programming paradigm based on the concept of objects, with shallow copy creating a new object with references to the original, and deep copy creating a new object with copies of the original's values.

    • OOP is a programming paradigm that focuses on objects and classes.

    • Shallow copy creates a new object that references the original object's data.

    • Deep copy creates a new object with copies of the original object's da...

  • Answered by AI
  • Q2. What are the features of the project?
  • Ans. 

    The project features include real-time data processing, machine learning algorithms, and user-friendly interface.

    • Real-time data processing for instant updates

    • Machine learning algorithms for predictive analysis

    • User-friendly interface for easy navigation

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice data structures and algorithms regularly, participate in contests, and review your projects consistently.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Wht is tuple and how it is dif from list
  • Ans. 

    A tuple is an immutable collection of elements, while a list is a mutable collection in Python.

    • Tuples are created using parentheses (), while lists are created using square brackets []

    • Tuples are immutable, meaning their elements cannot be changed once defined

    • Lists are mutable, allowing for elements to be added, removed, or modified

    • Tuples are typically used for fixed collections of items, while lists are used for dynami

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Coin change problem
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. .net related questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Functional knowledge
Round 3 - HR 

(1 Question)

  • Q1. Discussion of salary and position
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell about a time where you had competing demands from stakeholders.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Amrita Institute of Advanced Computing, Coimbatore and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - Coding Test 

HireVue, a few coding and some aptitude

Round 2 - Technical 

(2 Questions)

  • Q1. Questions about Devops
  • Q2. Questions about project
Round 3 - HR 

(3 Questions)

  • Q1. Why do you want to work here
  • Ans. 

    I am passionate about software development and believe this company offers a great learning opportunity.

    • I admire the company's innovative projects and cutting-edge technologies.

    • I am impressed by the company's positive reputation in the industry.

    • I am excited about the opportunity to work with a talented team of developers.

    • I believe this internship will provide me with valuable experience and skills for my future career.

  • Answered by AI
  • Q2. What do you think about your college
  • Ans. 

    I think highly of my college as it provided me with a strong foundation in software development.

    • My college has a reputable computer science program with experienced faculty members.

    • The curriculum included hands-on projects and internships to enhance practical skills.

    • I was able to participate in coding competitions and hackathons organized by the college.

    • The college also offered networking opportunities with industry pr...

  • Answered by AI
  • Q3. Where do you see yourself in 5years
  • Ans. 

    In 5 years, I see myself as a senior software developer leading a team and working on impactful projects.

    • Continuing to enhance my technical skills and knowledge through continuous learning and training

    • Taking on more leadership responsibilities and mentoring junior developers

    • Contributing to the success of the company by delivering high-quality software solutions

    • Exploring new technologies and trends in the software devel...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with your resume and DSA.

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

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
HDFC Bank Interview Questions
3.9
 • 2.1k Interviews
Axis Bank Interview Questions
3.8
 • 1.5k Interviews
IndusInd Bank Interview Questions
3.5
 • 597 Interviews
Wells Fargo Interview Questions
3.9
 • 567 Interviews
Citicorp Interview Questions
3.7
 • 566 Interviews
HSBC Group Interview Questions
4.0
 • 490 Interviews
Yes Bank Interview Questions
3.7
 • 428 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.3k salaries
unlock blur

₹5.9 L/yr - ₹24 L/yr

Associate 1
994 salaries
unlock blur

₹2.5 L/yr - ₹9.5 L/yr

Associate
809 salaries
unlock blur

₹2 L/yr - ₹8 L/yr

Senior Software Engineer
459 salaries
unlock blur

₹7.5 L/yr - ₹28 L/yr

Explore more salaries
Compare BNP Paribas with

HSBC Group

4.0
Compare

Standard Chartered

3.8
Compare

ICICI Bank

4.0
Compare

HDFC Bank

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