BNP Paribas Chennai
Summary
I recently interviewed with BNP Paribas in Chennai, where the process included technical rounds focusing on coding (pattern printing, Java streams), SQL, system design concepts like Kafka vs RabbitMQ and SQL vs NoSQL, along with behavioral questions and a coding challenge involving URL shortener logic.
Full Experience
About: 3.5yoe, SBC, ~1000 problems solved overall
I am sharing my recent interview experience 💼 BNP Paribas Interview Experience (via 3rd Party Payroll) — hope this helps others preparing.
🧑💻 Round 1 – Technical (Online)
Pattern printing question:
*
*#
*#*
*#*#
Java Stream API problems:
- Given list of Integer map values and their frequency
- Filter distinct odd numbers using streams
💻 The coding was done live, online editor or IntelliJ.
Asked to solve SQL queries directly on the Programiz website:(https://www.programiz.com/sql/online-compiler)
- ✅ One SELECT query using WHERE and LIKE conditions
- ✅ One JOIN query with aggregate SUM
Focus was mainly on: Correct joins, Filtering logic,Writing clean SQL syntax
Kafka vs RabbitMQ discussion
🏢 Round 2 – Onsite Technical Discussion
💬 Conceptual Questions
- Difference between SQL vs NoSQL
- When to use each and how to choose
- How to make Singleton thread-safe
- Design patterns I’ve used in real projects
- Discussion about 42Crunch (since I mentioned using it in my project)
💻 Coding
Implemented a basic URL Shortener logic
🤝 Round 3 – Managerial Discussion
Discussion was more conversational:
- About the company and team expectations
- The biggest problem/project I have solved and my approach
- Why I am looking for a change
- General discussion around AI and how it impacts current software development
Interview Questions (13)
Pattern Printing Problem
Print the following pattern:
*
*#
*#*
*#*#
Map values and their frequency using Java Streams
Given a list of Integers, map values to their frequency using Java Stream API.
Filter distinct odd numbers using Java Streams
Filter distinct odd numbers from a given list of Integers using Java Stream API.
SQL SELECT with WHERE and LIKE conditions
Write a SELECT SQL query using WHERE and LIKE conditions.
SQL JOIN with Aggregate SUM
Write a SQL JOIN query involving an aggregate SUM function.
Kafka vs RabbitMQ Comparison
Discuss the differences between Kafka and RabbitMQ.
SQL vs NoSQL Comparison
Discuss the differences between SQL and NoSQL databases, when to use each, and how to choose between them.
Thread-Safe Singleton Implementation
Explain how to make a Singleton design pattern thread-safe.
Discuss Design Patterns in Projects
Discuss design patterns I have used in real projects.
Implement Basic URL Shortener
Implement the basic logic for a URL Shortener.
Discuss Biggest Project/Problem Solved
Discuss the biggest problem or project I have solved and my approach.
Reason for Job Change
Discuss why I am looking for a change in my current role/company.
Impact of AI on Software Development
General discussion around AI and how it impacts current software development.
Preparation Tips
I have solved around 1000 problems overall.