Unicommerce Esolutions Senior Software Engineer Interview Questions and Answers

Q1. Mimic Dataframe Merge
Ans. 
Implement a function to mimic the functionality of merging two DataFrames in Python.
• Create a function that takes two DataFrames as input.

• Merge the two DataFrames based on a common column or index.

• Handle different types of joins like inner, outer, left, and right joins.

• Return the merged DataFrame as output.
Answered by AI
Add your answer
Q2. Improve above case by case
Add your answer

1 hour - Find longest palindromic substring

Q1. Questions on what project you worked on
Add your answer
Q2. Design 2 factor authentication
Ans. 
Implementing 2 factor authentication for enhanced security
• Require users to enter their password as the first factor

• Send a unique code to the user's registered email or phone as the second factor

• Prompt the user to enter the code to complete the authentication process
Answered by AI
Add your answer

2 Leetcode medium - LRU Cache and sliding window question

Q1. Design Whatsapp
Ans. 
Design a messaging app like Whatsapp
• Implement end-to-end encryption for secure messaging

• Allow users to send text messages, images, videos, and documents

• Include features like group chats, voice and video calls, status updates

• Provide option for users to share their location

• Develop a user-friendly interface with customizable settings
Answered by AI
Add your answer

Basic of os, network snd oops

Q1. Problem solving (coding)
Add your answer

Q1. Technical discussion
Add your answer

Q1. HR discussion, pay discussion
Add your answer

Q1. Most questions were on Java 8 and Collections Framework. Some Questions on Core Java and SQL for Round 1
Add your answer
Q2. How to Filter from stream.
Ans. 
Filtering from a stream involves selecting specific elements based on certain criteria.
• Use filter() method to create a new stream with elements that pass a given test.

• Provide a Predicate functional interface to filter() method.

• Example: stream.filter(x -> x > 5) will return a new stream with elements greater than 5.
Answered by AI
Add your answer
Q3. Find Top 3 salary for SQL
Ans. 
To find top 3 salaries for SQL, we need to use the ORDER BY and LIMIT clauses in SQL query.
• Use ORDER BY clause to sort the salaries in descending order

• Use LIMIT clause to limit the result to top 3 salaries

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 3
Answered by AI
Add your answer

Q1. HQL, How to write Queries
Add your answer

Q1. Salary Discussion based on previous job
Add your answer

Q1. Leet code problem solving
Add your answer
Q2. Microservices spring boot
Add your answer
Q3. Manager round, job responsibilities, project discuss
Add your answer