About: 3.5yoe, SBC, ~1000 problems solved overall

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:

1. Given list of Integer map values and their frequency

2. 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