Upload Button Icon Add office photos

Filter interviews by

BNP Paribas SQL Developer Interview Questions, Process, and Tips for Experienced

Updated 4 Jun 2022

1 BNP Paribas SQL Developer Interview Experience for Experienced

11 questions found

Sort by: Popular

SQL Developer Interview Questions

user image Anonymous

posted on 4 Jun 2022

I applied via Approached by Company and was interviewed in Dec 2021.

5 Interview Rounds

1

Technical Round (3 Questions)

  • Q1. Basics of SQL, types of joins, cursors, triggers
  • Q2. Functions and Procedures and differences between them
  • Q3. Performance tuning of SQL query
2

Technical Round (4 Questions)

  • Q1. Similar questions to TR1, but this time with more depth and at advanced level
  • Q2. Given sample data on two tables, write down the result sets of all types joins.
  • Q3. Write down a procedure to return a certain series (99, 96, 93, ...., 6, 3)
  • Q4. Extract execution plan of a SQL query
3

One-on-one Round (2 Questions)

  • Q1. Basic questions on project structure, development approach
  • Q2. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
4

Behavioral Round (1 Question)

  • Q1. Casual meeting wrt expectations from project, work culture, etc.
5

HR Round (1 Question)

  • Q1. CTC, location negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Theoretical knowledge is not preferred. Whatever is present in the resume, make sure you have hands-on experience in that.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
 Average
Difficulty level
 Hard
Duration
 Less than 2 weeks
Result
 -

I applied via Indeed and was interviewed in Apr 2023.

2 Interview Rounds

1

One-on-one Round (1 Question)

  • Q1. Round 1 1.Basic JS question 2.Tricky indepth question who answer you would have to logically conclude/ educative guess Eg: 3. Why class are in React immutable b...read more
2

Coding Test Round

1.Complex coding round.
2.Explain any independent project you have done

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed before Sep 2022.

3 Interview Rounds

1

Resume Shortlist Round

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
2

Coding Test Round

It was aptitude and coding round basically quesstions were in arrrays and linkedlist

3

Technical Round (1 Question)

  • Q1. Oops questions in java

Interview Preparation Tips

Interview preparation tips for other job seekers - didn't clear it

I was interviewed in Nov 2020.

2 Interview Rounds

1

Video Call Round (2 Questions)

Round duration - 50 minutes
Round difficulty - Hard

Timing (10 am- 10:50 am)
For this round I had slightly more time than the last, due to the fact that the weekend fell in between.The interviewer was very very cool and helping this time, something which I kept at the last in my list of probable things that can happen during an interview. Duration of this round was around 50 minutes.

This time I had to face three technical questions and one general question on Finance banks.

  • Q1. Pair Sum You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to return the list of all pairs of elements s...read more
  • Q2. Validate BST Given a binary tree with N number of nodes, check if that input tree is BST (Binary Search Tree) or not. If yes, return true, return false otherwis...read more
2

HR Round (1 Question)

Round duration - 35 minutes
Round difficulty - Medium

There was only one interviewer for this round. He continuously interacted with me and was giving me some good situational problems that were not very easy to answer. Basically those were open-minded questions which can be answered oth ways and that's why I found it quiet hard as per my nature but at the end things went well for me.

  • Q1. Puzzle A noticeable aspect in this puzzles is the fact that there’s a circular misplacement, which implies if apple is wrongly labelled as Apple, Apple can’t be...read more

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from Malaviya National Institute of Technology Jaipur. I applied for the job as SDE - Intern in BangaloreEligibility criteriaResume shortlistingMorgan Stanley interview preparation:Topics to prepare for the interview - Data Structures, hashmap, linked list, Pointers, OOPS, System Design, Algorithms, Dynamic Programming, array, 2-pointer problemsTime required to prepare for the interview - 12 monthsInterview preparation tips for other job seekers

Tip 1 : Practice on gfg and coding ninjas.
Tip 2 : Compete on codechef and codeforces.
Tip 3 : Learn DSA and practice regularly.

Application resume tips for other job seekers

Tip 1 : Not more than 1 page
Tip 2 : Have atleast 3 projects with some achievement in coding contest and your coding handle should be mentioned like codechef, codeforces etc
Tip 3 : Try to keep only those things in resume in which you find yourself comfortable with

Final outcome of the interviewSelected

Skills evaluated in this interview

BNP Paribas Interview FAQs

How many rounds are there in BNP Paribas SQL Developer interview for experienced candidates?
BNP Paribas interview process for experienced candidates usually has 5 rounds. The most common rounds in the BNP Paribas interview process for experienced candidates are Technical, HR and One-on-one Round.
How to prepare for BNP Paribas SQL Developer interview for experienced candidates?
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 Analytical, Financial Services, Retail Banking, Oracle and PLSQL.
What are the top questions asked in BNP Paribas SQL Developer interview for experienced candidates?

Some of the top questions asked at the BNP Paribas SQL Developer interview for experienced candidates -

  1. How is a change request in application serviced by development team (business a...read more
  2. Write down a procedure to return a certain series (99, 96, 93, ...., 6,...read more
  3. Given sample data on two tables, write down the result sets of all types joi...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
HDFC Bank Interview Questions
3.9
 • 2k Interviews
Axis Bank Interview Questions
3.8
 • 1.4k Interviews
IndusInd Bank Interview Questions
3.6
 • 570 Interviews
Wells Fargo Interview Questions
3.9
 • 540 Interviews
HSBC Group Interview Questions
4.0
 • 475 Interviews
Yes Bank Interview Questions
3.8
 • 404 Interviews
American Express Interview Questions
4.2
 • 351 Interviews
View all
Senior Associate
2k salaries
unlock blur

₹3.6 L/yr - ₹14.2 L/yr

Assistant Manager
1.3k salaries
unlock blur

₹5.8 L/yr - ₹24 L/yr

Associate 1
990 salaries
unlock blur

₹2.4 L/yr - ₹9.3 L/yr

Associate
790 salaries
unlock blur

₹2 L/yr - ₹7.9 L/yr

Manager
445 salaries
unlock blur

₹8 L/yr - ₹30 L/yr

Explore more salaries
Compare BNP Paribas with

HSBC Group

4.0
Compare

Citibank

3.9
Compare

Standard Chartered

3.8
Compare

ICICI Bank

4.0
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview