BNP Paribas Senior Technical Lead Interview Questions and Answers

Q1. How will you optimize the performance while reading a huge file with more than 100 columns and 1 lac rows?
Ans. 
Use efficient file reading techniques like memory mapping, parallel processing, and columnar storage.
• Utilize memory mapping to directly access file data without loading it into memory

• Implement parallel processing to read and process data concurrently for faster performance

• Consider using columnar storage to optimize data retrieval for specific columns

• Use appropriate data structures and algorithms for efficient data proc
Answered by AI
Add your answer

Q1. What is the difference between JPA repository and CRUD repository?
Ans. 
JPA repository is a standard interface provided by Spring Data for generic CRUD operations, while CRUD repository is a sub-interface of JPA repository with additional CRUD methods.
• JPA repository is a high-level abstraction that provides methods for common database operations like save, delete, findById, etc.

• CRUD repository extends JPA repository and adds additional methods like findAll, deleteAll, count, existsById, et...read more
Answered by AI
Add your answer

Q1. Asked questions on multithreading and deadlocks. Data flow between components in React - Parent to Child and vice versa. State management techniques in React. Life Cycle methods. HTML DOC and related ta...read more
Add your answer

Q1. General discussion on current CTC and Expected CTC.
Add your answer

Q1. How does the Angular pipes works. ?
Ans. 
Angular pipes are used to transform data in templates before displaying it to the user.
• Angular pipes are used in templates to format data before displaying it.

• Pipes can be used to transform strings, numbers, dates, and other types of data.

• There are built-in pipes like 'uppercase', 'lowercase', 'currency', 'date', etc.

• Custom pipes can also be created to suit specific formatting needs.

• Pipes can be chained together to app
Answered by AI
Add your answer

2 hours coding round with 3 sections
1st being mcq aptidute+coding question 20 mins were given for this section and 20 questions were there in this section

2nd section consisted of 8 questions where we had to do the error correction in the given code 20 mins were also given for this section

3rd section consisted of 2 coding problems 20 mins were given for each one was a dp and one was a segment tree question

I was able to do everything correctly and was selected for the first interview round

Q1. Firstly they asked me to Tell me about myself Then a little bit about my projects Then 3 coding questions were ASKED 1st was a really recursion problem 2nd was a dp problem specifically a generic problem ...read more
Add your answer

Q1. Why do you want to join the company
Add your answer
Q2. Tell me what do you know about the company
Add your answer
Q3. Then I was asked about my project and cross questioned on it
Add your answer
Q4. Then i was asked about a system design question (since I didn't study about it I tanked here :))
Add your answer

Q1. Questions on office 365 administration Scenario based questions Desktop support and troubleshooting
Add your answer
Q2. Questions on past experience
Add your answer
Q3. Questions on mail forwarding,shared mailbox.DL
Add your answer

Q1. Projects on resume , basic dsa, real life example fo data struct, oops . procedure - pl /sql
Add your answer

Q1. Family backgroudn , hobbies , general discussion
Add your answer