Upload Button Icon Add office photos

Filter interviews by

BNP Paribas Interview Questions, Process, and Tips

Updated 21 Jan 2025

Top BNP Paribas Interview Questions and Answers

View all 113 questions

BNP Paribas Interview Experiences

Popular Designations

176 interviews found

I applied via Approached by Company and was interviewed in Dec 2021. There were 5 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Basics of SQL, types of joins, cursors, triggers
  • Q2. Functions and Procedures and differences between them
  • Ans. 

    Functions and procedures are both stored database objects used to perform specific tasks in SQL.

    • Functions return a value while procedures do not.

    • Functions can be used in SQL statements, whereas procedures cannot.

    • Functions can have input parameters and return a single value, while procedures can have input and output parameters.

    • Functions are typically used for calculations or data manipulation, while procedures are used...

  • Answered by AI
  • Q3. Performance tuning of SQL query
  • Ans. 

    Performance tuning of SQL query

    • Identify slow queries using profiling tools

    • Optimize query structure and use indexes

    • Reduce data retrieval by filtering and limiting results

    • Avoid using subqueries and nested queries

    • Use appropriate data types and avoid unnecessary conversions

  • Answered by AI
Round 2 - Technical 

(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.
  • Ans. 

    The result sets of all types of joins in SQL

    • Inner Join: Returns only the matching rows from both tables

    • Left Join: Returns all the rows from the left table and the matching rows from the right table

    • Right Join: Returns all the rows from the right table and the matching rows from the left table

    • Full Outer Join: Returns all the rows from both tables, including the unmatched rows

    • Cross Join: Returns the Cartesian product of b

  • Answered by AI
  • Q3. Write down a procedure to return a certain series (99, 96, 93, ...., 6, 3)
  • Ans. 

    Procedure to return a series (99, 96, 93, ...., 6, 3)

    • Create a temporary table with a single column

    • Use a loop to insert values into the temporary table

    • Return the values from the temporary table in descending order

  • Answered by AI
  • Q4. Extract execution plan of a SQL query
  • Ans. 

    To extract execution plan of a SQL query, use EXPLAIN or SHOW PLAN command.

    • Use EXPLAIN or SHOW PLAN command before the SQL query

    • EXPLAIN command shows the execution plan in a tabular format

    • SHOW PLAN command shows the execution plan in a graphical format

    • Execution plan helps in optimizing the query for better performance

  • Answered by AI
Round 3 - One-on-one 

(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.)
  • Ans. 

    A change request in an application is serviced by the development team through various stages such as business analysis, code analysis, discussion with BA, and requirement freeze.

    • The development team starts by analyzing the change request to understand its impact on the application.

    • They perform business analysis to determine the feasibility and potential risks of implementing the change.

    • Code analysis is conducted to as...

  • Answered by AI
Round 4 - Behavioral 

(1 Question)

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

(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

Top BNP Paribas SQL Developer Interview Questions and Answers

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
View answer (4)

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
View answer (4)

Senior Financial Analyst under SLAB settlements Interview Questions & Answers

user image Anonymous

posted on 4 Mar 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2022. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. 1. Pritiya employment 2. Trade life cycle 3. What you know about stock lending
  • Q2. 1.what is derivatives 2. What do you understand about SLAB
  • Ans. 

    Derivatives are financial contracts that derive their value from an underlying asset or benchmark.

    • Derivatives can be used for hedging or speculation

    • Examples of derivatives include futures, options, and swaps

    • SLAB stands for Structured Legal Assistance Box, a type of settlement used in legal cases

    • SLAB settlements involve the creation of a trust to manage the settlement funds and distribute payments to claimants

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and if u don't know tell them I'm not sure...
Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2022. There were 4 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 - Coding Test 

Hacker rank situational problem with TI

Round 3 - One-on-one 

(1 Question)

  • Q1. Managerial Round with some TI questions as well
Round 4 - HR 

(2 Questions)

  • Q1. Formality round. Just a sanity check of legal clearance.
  • Q2. They informed about the work policy and working model

Interview Preparation Tips

Interview preparation tips for other job seekers - Be normal amd honest. And just with minimalistic preparation you might end up with an offer in hand

Senior Software Engineer Interview Questions asked at other Companies

Q1. Find Nth PrimeYou are given a number 'N'. Your task is to find Nth prime number. A prime number is a number greater than 1 that is not a product of two smaller natural numbers. Prime numbers have only two factors – 1 and the number itself. ... read more
View answer (6)

What people are saying about BNP Paribas

View All
successfulwalnut
Verified Icon
9h (edited)
works at
BNP Paribas
Below openings are listed
If anyone interested referrel do let me know BNP paribas ( chennai location only )
FeedCard Image
Got a question about BNP Paribas?
Ask anonymously on communities.

Senior Associate Interview Questions & Answers

user image Nandhini Kannan

posted on 5 Jan 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jan 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Self intro and About previously worked process briefly
Round 2 - Technical 

(1 Question)

  • Q1. All about processing and management skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well about your previous work and know about your future company. Be clear on your point and don't give any answer in flow.

Top BNP Paribas Senior Associate Interview Questions and Answers

Q1. Job card parameters Cond parameter Define gdg and vsams Abends Sorting Joins
View answer (1)

Senior Associate Interview Questions asked at other Companies

Q1. On an average, how many invoices can you process in a day?
View answer (10)

BNP Paribas interview questions for popular designations

 Senior Associate

 (19)

 Associate

 (13)

 Associate 1

 (8)

 Intern

 (8)

 Assistant Manager

 (7)

 Senior Software Engineer

 (6)

 Business Analyst

 (4)

 Senior Financial Analyst

 (3)

I applied via Naukri.com

Round 1 - Technical 

(1 Question)

  • Q1. Entity framework Constructors Oops Managerial
Round 2 - HR 

(1 Question)

  • Q1. Why leaving current company

Interview Preparation Tips

Interview preparation tips for other job seekers - Only 1 hour round for technical and managerial. Clear basics and some basic programming skills will be tested by solving 1 or 2 problem statement

Senior Software Engineer Interview Questions asked at other Companies

Q1. Find Nth PrimeYou are given a number 'N'. Your task is to find Nth prime number. A prime number is a number greater than 1 that is not a product of two smaller natural numbers. Prime numbers have only two factors – 1 and the number itself. ... read more
View answer (6)

Get interview-ready with Top BNP Paribas Interview Questions

Round 1 - Technical 

(3 Questions)

  • Q1. Whats is BNP Paribas
  • Ans. 

    BNP Paribas is a French multinational bank and financial services company.

    • Founded in 2000 through the merger of Banque Nationale de Paris and Paribas

    • Headquartered in Paris, France

    • Offers a range of financial services including retail banking, investment banking, and asset management

    • Operates in over 70 countries worldwide

    • One of the largest banks in the world by total assets

  • Answered by AI
  • Q2. What are the outine protocol and explain BGP, EIGRP and ISIS.
  • Ans. 

    BGP, EIGRP, and ISIS are routing protocols used in networking.

    • BGP (Border Gateway Protocol) is used for routing between different autonomous systems.

    • EIGRP (Enhanced Interior Gateway Routing Protocol) is a Cisco proprietary protocol used for routing within a single autonomous system.

    • ISIS (Intermediate System to Intermediate System) is a protocol used for routing within a single autonomous system, similar to EIGRP.

    • BGP us...

  • Answered by AI
  • Q3. What is VPN and VLAN
  • Ans. 

    VPN is a secure connection between two networks while VLAN is a logical grouping of devices on a network.

    • VPN stands for Virtual Private Network and is used to securely connect two networks over the internet.

    • VPN uses encryption to protect data transmitted over the network.

    • VLAN stands for Virtual Local Area Network and is used to logically group devices on a network.

    • VLANs can be used to separate traffic on a network for ...

  • Answered by AI
Round 2 - One-on-one 

(4 Questions)

  • Q1. What is OSI and TCP/IP model
  • Ans. 

    OSI and TCP/IP models are reference models used to describe how data is transmitted over a network.

    • OSI model has 7 layers, while TCP/IP model has 4 layers

    • OSI model is theoretical, while TCP/IP model is practical

    • OSI model is used for teaching and understanding networking concepts, while TCP/IP model is used for actual implementation

    • Examples of layers in OSI model: Physical, Data Link, Network, Transport, Session, Presen...

  • Answered by AI
  • Q2. What is MPLS, MP-VPN, MPLS-TE.
  • Ans. 

    MPLS is a protocol for efficient data transfer, MP-VPN is a VPN service using MPLS, and MPLS-TE is a traffic engineering extension of MPLS.

    • MPLS stands for Multiprotocol Label Switching and is used to efficiently route data packets through a network.

    • MP-VPN is a VPN service that uses MPLS to securely connect multiple sites or users to a private network.

    • MPLS-TE is an extension of MPLS that allows for more precise traffic ...

  • Answered by AI
  • Q3. What is MTU and how to find the MTU size for CE/PE
  • Ans. 

    MTU stands for Maximum Transmission Unit. It is the largest size of data packet that can be transmitted over a network.

    • MTU is measured in bytes.

    • The default MTU size for Ethernet is 1500 bytes.

    • To find the MTU size for CE/PE, you can use the ping command with the -f option to set the Do Not Fragment (DNF) bit and gradually increase the packet size until you receive a 'packet needs to be fragmented but DF set' message.

    • Ano...

  • Answered by AI
  • Q4. What are BGP attributes and how can we identify
  • Ans. 

    BGP attributes are characteristics used to determine the best path for routing traffic between networks.

    • BGP attributes include: AS Path, Next Hop, Local Preference, Multi-Exit Discriminator (MED), Weight, and Origin.

    • AS Path identifies the sequence of autonomous systems that the route has passed through.

    • Next Hop identifies the IP address of the next router in the path.

    • Local Preference is used to indicate the preferred p...

  • Answered by AI

Skills evaluated in this interview

Top BNP Paribas Network Engineer Interview Questions and Answers

Q1. What are the outine protocol and explain BGP, EIGRP and ISIS.
View answer (1)

Network Engineer Interview Questions asked at other Companies

Q1. TCP/IP layers, why is transport needed for communication? What is Subnet mask and how does it help in data communication. Why is Vlan needed? Based on what information does a switch and router send a packet or frame? Types of arp, What is p... read more
View answer (2)

Jobs at BNP Paribas

View all
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Capital Market questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Technicals are the main. Focus on your subject matter, things should go well.

Top BNP Paribas Senior Associate Interview Questions and Answers

Q1. Job card parameters Cond parameter Define gdg and vsams Abends Sorting Joins
View answer (1)

Senior Associate Interview Questions asked at other Companies

Q1. On an average, how many invoices can you process in a day?
View answer (10)

I applied via Naukri.com and was interviewed in Oct 2021. There were 5 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Questions on Cobol programming
  • Q2. Different variable defining levels Calling subroutines Static and dynamic calls Runninf SQL query in cobol program Tsq tdq Search and search all Comp variables Abends and how to handle them
Round 2 - Technical 

(2 Questions)

  • Q1. Question on cics and db2
  • Q2. DB2 update and delete queries Dml and ddl operations Isolation levels Error codes Cics tables Map and mapset parameters How to define files and new programs Abends
Round 3 - Technical 

(2 Questions)

  • Q1. JCL questions interview round
  • Q2. Job card parameters Cond parameter Define gdg and vsams Abends Sorting Joins
  • Ans. 

    The interview question covers job card parameters, cond parameter, gdg and vsams, abends, sorting, and joins.

    • Job card parameters are used to specify job information such as job name, job class, and accounting information.

    • COND parameter is used to conditionally execute job steps based on the return code of previous steps.

    • GDG (Generation Data Group) is a group of related datasets that are created and managed together.

    • VSA...

  • Answered by AI
Round 4 - Behavioral 

(1 Question)

  • Q1. Agile methodologies Jira knowledge Service now knowledge
Round 5 - HR 

(2 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare the error and abend codes thoroughly
How to identify and resolve them

Top BNP Paribas Senior Associate Interview Questions and Answers

Q1. Job card parameters Cond parameter Define gdg and vsams Abends Sorting Joins
View answer (1)

Senior Associate Interview Questions asked at other Companies

Q1. On an average, how many invoices can you process in a day?
View answer (10)

Team Manager Interview Questions & Answers

user image Anonymous

posted on 22 Apr 2024

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

I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Risk management
Round 2 - Technical 

(1 Question)

  • Q1. Risk management
Round 3 - HR 

(1 Question)

  • Q1. Basic discussion by hr

Team Manager Interview Questions asked at other Companies

Q1. To maintain SIEM solution which are the daily activities that you will perform?
View answer (4)
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Oct 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Assignment 

Questions asked regarding the stock pitch made.

Round 3 - One-on-one 

(2 Questions)

  • Q1. In general questions wrt work done till now by head of research
  • Q2. Multiple questions wrt stocks covered
Round 4 - HR 

(1 Question)

  • Q1. Questions wrt salary and expectations
Round 5 - HR 

(2 Questions)

  • Q1. How will the job look like in BNP
  • Q2. Overall BNP Paribas functions and structure
  • Ans. 

    BNP Paribas is a global banking and financial services company with a complex organizational structure.

    • BNP Paribas operates in over 70 countries worldwide

    • The company is divided into three main business lines: Retail Banking, Corporate & Institutional Banking, and Investment Solutions

    • BNP Paribas has a strong presence in Europe, the Americas, and Asia-Pacific regions

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Have core knowledge of markets

Top BNP Paribas Senior Associate Interview Questions and Answers

Q1. Job card parameters Cond parameter Define gdg and vsams Abends Sorting Joins
View answer (1)

Senior Associate Interview Questions asked at other Companies

Q1. On an average, how many invoices can you process in a day?
View answer (10)

BNP Paribas Interview FAQs

How many rounds are there in BNP Paribas interview?
BNP Paribas interview process usually has 2-3 rounds. The most common rounds in the BNP Paribas interview process are Technical, HR and One-on-one Round.
How to prepare for BNP Paribas 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, Analytical, Reconciliation, Retail Banking and Operations.
What are the top questions asked in BNP Paribas interview?

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

  1. How is a change request in application serviced by development team (business a...read more
  2. What are derivatives, capital market, money market?. What is the formula for NA...read more
  3. if we dont specify anything in group by aggregator what will hap...read more
How long is the BNP Paribas interview process?

The duration of BNP Paribas interview process can vary, but typically it takes about 2-4 weeks to complete.

Tell us how to improve this page.

BNP Paribas Interview Process

based on 154 interviews

Interview experience

4.1
  
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
 • 591 Interviews
HSBC Group Interview Questions
4.0
 • 490 Interviews
Yes Bank Interview Questions
3.7
 • 414 Interviews
RBL Bank Interview Questions
3.6
 • 169 Interviews
View all

BNP Paribas Reviews and Ratings

based on 1.5k reviews

3.8/5

Rating in categories

3.5

Skill development

3.8

Work-life balance

3.4

Salary

4.1

Job security

3.7

Company culture

3.1

Promotions

3.5

Work satisfaction

Explore 1.5k Reviews and Ratings
Python Developer

Bangalore / Bengaluru

4-8 Yrs

Not Disclosed

Java Full Stack Developer

Bangalore / Bengaluru

4-9 Yrs

Not Disclosed

Java Fullstack Developer

Bangalore / Bengaluru

4-9 Yrs

Not Disclosed

Explore more jobs
Senior Associate
2k salaries
unlock blur

₹3.6 L/yr - ₹14 L/yr

Assistant Manager
1.3k salaries
unlock blur

₹5.8 L/yr - ₹24 L/yr

Associate 1
1k 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
457 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