AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
BNP Paribas Interview Questions, Process, and Tips
Top BNP Paribas Interview Questions and Answers
- Q1. Job card parameters Cond parameter Define gdg and vsams Abends Sorting Joinsasked in Senior Associate interview
- Q2. What are the outine protocol and explain BGP, EIGRP and ISIS.asked in Network Engineer interview
- Q3. Entire process of Trade life cycleasked in Assistant Manager interview
BNP Paribas Interview Experiences
178 interviews found
Anonymous
I applied via Approached by Company and was interviewed in Dec 2021. There were 5 interview rounds.
(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...
- 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
(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
- 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
- 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
(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...
(1 Question)
- Q1. Casual meeting wrt expectations from project, work culture, etc.
(1 Question)
- Q1. CTC, location negotiation
Interview Preparation Tips
Skills evaluated in this interview
Top BNP Paribas SQL Developer Interview Questions and Answers
SQL Developer Interview Questions asked at other Companies
(5 Questions)
- Q1. Basic questions on python
- Q2. Difference between list tuple
- Ans.
Lists and tuples are both data structures in Python, but lists are mutable while tuples are immutable.
Lists are enclosed in square brackets [], while tuples are enclosed in parentheses ().
Lists can be modified after creation, while tuples cannot be modified (immutable).
Lists are typically used for collections of similar items, while tuples are used for fixed collections of items.
Example: list = [1, 2, 3] and tuple = (4
- Q3. Area of room 6D
- Ans.
The area of a room can be calculated by multiplying the length by the width.
Calculate the area by multiplying the length and width of the room.
For example, if the length of the room is 10 feet and the width is 12 feet, the area would be 120 square feet.
Make sure to use the same units for length and width when calculating the area.
- Q4. Most emberacing situation u faced in your life
- Ans.
Getting caught cheating on a test in high school
Was copying answers from a classmate during a test
Teacher caught me and called me out in front of the whole class
Felt embarrassed and learned my lesson about cheating
- Q5. Behavior questions like what will u do if this happens
Engineer Trainee Interview Questions asked at other Companies
Pratyush Prakash.
Selected
I applied via Approached by Company and was interviewed in Sep 2024. There were 5 interview rounds.
(2 Questions)
- Q1. Multi threading print odd even with 2 threads but output should be in sync
- Ans.
Use two threads to print odd and even numbers in sync
Create two threads, one for printing odd numbers and one for printing even numbers
Use synchronization mechanisms like mutex or semaphore to ensure output is in sync
Example: Thread 1 prints odd numbers (1, 3, 5, ...) and Thread 2 prints even numbers (2, 4, 6, ...)
- Q2. Largest common prefix in string array
- Ans.
Find the largest common prefix among an array of strings.
Iterate through the characters of the first string and compare with the corresponding characters of other strings.
Stop when a mismatch is found or when reaching the end of any string.
Return the prefix found so far.
(2 Questions)
- Q1. Saga pattern in microservice
- Ans.
Saga pattern is a design pattern used in microservices architecture to manage distributed transactions.
Saga pattern breaks down a transaction into a series of smaller, independent steps.
Each step in the saga is a separate transaction that can be rolled back if needed.
If one step fails, compensating transactions can be executed to undo the changes made by previous steps.
Saga pattern helps maintain data consistency in a ...
- Q2. API validation and security
(2 Questions)
- Q1. Micro service inter communication
- Q2. Hash map hash set implementation
- Ans.
Hash map and hash set are data structures that use hashing to store key-value pairs and unique values respectively.
Hash map uses key-value pairs where keys are hashed to find the corresponding value
Hash set stores unique values using hashing to quickly check for duplicates
Example: HashMap
set = new HashSet<>();
(3 Questions)
- Q1. Validation frame work .
- Q2. Design pattern , .
- Q3. Singleton pattern and how to break
- Ans.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Singleton pattern involves a private constructor, a static method to access the instance, and a static variable to hold the instance.
To break the singleton pattern, one can use reflection to access the private constructor and create multiple instances.
Another way to break the singleton pattern is by using serialization a
(2 Questions)
- Q1. Negotiation on package .
- Q2. Why to join here
- Ans.
I am excited about the innovative projects and collaborative team environment at this company.
Opportunity to work on cutting-edge projects
Collaborative team environment
Strong company culture and values
Room for growth and advancement
Positive reputation in the industry
Skills evaluated in this interview
Senior Engineer Interview Questions asked at other Companies
What people are saying about BNP Paribas
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Basic questions about sql and PLSQL topics
- Q2. Scenario based questions and write few sql queries
(2 Questions)
- Q1. Performance tuning related questions
- Q2. Explain project details
Plsql Developer Interview Questions asked at other Companies
BNP Paribas interview questions for popular designations
Karan Pardi
(2 Questions)
- Q1. Questions related to Database queries. e.g:- how to delete the duplicate record.
- Q2. Linux commands. e.g :- how to grep only numbers from a file
(2 Questions)
- Q1. Questions on change management
- Q2. Situation based questions
(2 Questions)
- Q1. Explain the trade life cycle
- Ans.
The trade life cycle refers to the stages involved in the processing of a trade from initiation to settlement.
Initiation: Trade is proposed and agreed upon by parties involved.
Execution: Trade is executed on the agreed terms.
Confirmation: Parties confirm the details of the trade.
Clearing: Trade details are matched and processed for settlement.
Settlement: Actual exchange of funds and securities takes place.
Post-trade: A...
- Q2. Prioritising of issues
- Ans.
Prioritising issues involves assessing urgency, impact, and resources available to address them.
Assess urgency of each issue based on impact on business operations
Consider impact on customers or stakeholders
Evaluate resources available to address each issue
Prioritise issues based on urgency, impact, and available resources
Communicate priorities to stakeholders and team members
(2 Questions)
- Q1. Why you left the previous organisation
- Q2. What do you expect from our company
Support Analyst Interview Questions asked at other Companies
Get interview-ready with Top BNP Paribas Interview Questions
I was interviewed in Oct 2024.
(4 Questions)
- Q1. Spring cloud gateway
- Q2. JWT Token structure and details
- Ans.
JWT token is a JSON web token used for authentication and contains three parts: header, payload, and signature.
JWT token consists of three parts: header, payload, and signature.
Header contains the type of token and the signing algorithm used.
Payload contains claims about the user and additional data.
Signature is used to verify that the sender of the JWT is who it says it is.
JWT tokens are encoded and can be easily deco...
- Q3. Java 11 features
- Q4. Stream related problems
Senior Java Developer Interview Questions asked at other Companies
Jobs at BNP Paribas
Selected
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
(4 Questions)
- Q1. Asked many questions regarding banking trade, fees management, transaction monitoring, Derivatives
- Q2. What do you know about derivatives?
- Ans.
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage.
Common types of derivatives include options, futures, forwards, and swaps.
For example, a call option gives the holder the right to buy an asset at a specified price within a certain time frame.
Derivatives are traded on exchanges or over-the-counter (OTC)
- Q3. Type of risk you handled in your current process
- Ans.
I handled operational risk in my current process.
Identifying potential risks in daily operations
Implementing controls to mitigate risks
Monitoring and evaluating the effectiveness of risk management strategies
- Q4. Scenario based question
Associate Interview Questions asked at other Companies
(2 Questions)
- Q1. Not applicable question
- Q2. Not applicable questions
(2 Questions)
- Q1. HR round was crucial as the third round
- Q2. HR round was crucial
Team Lead Interview Questions asked at other Companies
Basic accounting questions
(3 Questions)
- Q1. What is financial market
- Ans.
Financial market is a platform where buyers and sellers trade financial securities, commodities, and other fungible items.
Financial markets facilitate the exchange of assets such as stocks, bonds, currencies, and derivatives.
They provide a platform for companies to raise capital through issuing stocks or bonds.
Financial markets can be categorized into primary markets (new securities are issued) and secondary markets (e...
- Q2. What is investment banking
- Ans.
Investment banking involves providing financial services to corporations, governments, and other institutions.
Facilitates mergers and acquisitions
Underwrites securities offerings
Provides financial advisory services
Assists with raising capital for clients
Engages in trading and market-making activities
- Q3. What is Net Asset Value
- Ans.
Net Asset Value (NAV) is the value of a fund's assets minus its liabilities, divided by the number of shares outstanding.
NAV is calculated by subtracting the fund's liabilities from its assets.
The result is then divided by the number of shares outstanding to determine the NAV per share.
NAV is used to determine the price at which investors can buy or sell shares of the fund.
It is an important metric for investors to tra
(3 Questions)
- Q1. Tell me about yourself
- Ans.
I am a detail-oriented professional with a strong background in accounting and a passion for financial analysis.
I have a Bachelor's degree in Accounting and have worked in the finance industry for 5 years.
I am proficient in financial reporting, reconciliations, and fund accounting principles.
I have experience using accounting software such as QuickBooks and Excel to analyze financial data.
I am a team player and have ex...
- Q2. Journal entries
- Q3. Talk on current affairs
- Ans.
I will discuss the impact of COVID-19 on the global economy and financial markets.
COVID-19 pandemic led to economic slowdown worldwide
Stock markets experienced volatility due to uncertainty
Central banks implemented stimulus measures to support economies
Remote work became the norm for many industries
Supply chain disruptions affected various sectors
Interview Preparation Tips
Fund Accountant Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
(3 Questions)
- Q1. Tell me about yourself
- Ans.
Experienced Linux Administrator with 8+ years of hands-on experience in managing and troubleshooting Linux servers.
8+ years of experience in Linux system administration
Strong knowledge of server configuration, maintenance, and troubleshooting
Proficient in shell scripting and automation tools like Ansible
Experience with virtualization technologies such as VMware and KVM
Familiarity with networking protocols and security
- Q2. What is biggest issue facing in the real time work environment and how can you handle it
- Ans.
The biggest issue facing in the real time work environment is managing system downtime effectively.
Implementing proper monitoring tools to detect issues early
Creating a detailed incident response plan
Regularly testing backups and disaster recovery procedures
Utilizing automation for routine tasks to reduce human error
Establishing clear communication channels for notifying stakeholders during downtime
- Q3. How can you work on under the deadline
- Ans.
I prioritize tasks, break them down into smaller steps, set milestones, and communicate effectively with team members to ensure timely completion.
Prioritize tasks based on importance and urgency
Break down tasks into smaller steps to make them more manageable
Set milestones to track progress and stay on schedule
Communicate effectively with team members to coordinate efforts and address any obstacles
Utilize time managemen...
(3 Questions)
- Q1. Patching related question
- Q2. Linux Administrator role commands related questions
- Q3. Troubleshooting related question
(3 Questions)
- Q1. Day to day activity related questions
- Q2. What are tools you used and briefly explain and why it is used
- Ans.
Some tools used by Senior Linux Administrators include Ansible, Nagios, and Docker.
Ansible - used for automation of tasks and configuration management
Nagios - used for monitoring and alerting of system and network resources
Docker - used for containerization of applications for easy deployment and management
- Q3. Troubleshooting related questions
Interview Preparation Tips
Senior Linux Administrator Interview Questions asked at other Companies
Sumant Dalai
(2 Questions)
- Q1. Can you explain your current professional profile?
- Q2. Salary exceptions
Senior Financial Analyst Interview Questions asked at other Companies
BNP Paribas Interview FAQs
Some of the top questions asked at the BNP Paribas interview -
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 Interviews By Designations
- BNP Paribas Senior Associate Interview Questions
- BNP Paribas Associate Interview Questions
- BNP Paribas Associate 1 Interview Questions
- BNP Paribas Intern Interview Questions
- BNP Paribas Assistant Manager Interview Questions
- BNP Paribas Senior Software Engineer Interview Questions
- BNP Paribas Business Analyst Interview Questions
- BNP Paribas Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
BNP Paribas Interview Process
based on 158 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
BNP Paribas Reviews and Ratings
based on 1.6k reviews
Rating in categories
|
Senior Associate
2.1k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate 1
998
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate
809
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
462
salaries
| ₹0 L/yr - ₹0 L/yr |
HSBC Group
Standard Chartered
ICICI Bank
HDFC Bank
- Home >
- Interviews >
- BNP Paribas Interview Questions
