EarlySalary Services SDE Intern Interview Questions and Answers

Asking about the excel and other data tool. Salary offer as per their terms no negotiate.

Q1. Salary offer as per their terms.
Add your answer
Q2. Tell me some thing about your self.
Add your answer
Q3. What is expertise why want to leave
Add your answer

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

Auto complete Input Search box with Dropdown

Q1. Machine coding round for SQL
Add your answer

Q1. LLD HLD HM rounds
Add your answer

Technical SQL Coding Round of 1 hour

Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,

Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.

Bar Raiser Round of 1 hour involving -

1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?

2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.

3. Resume based work exp discussion

Q1. Quick culture fitment round with HR discussing about past work experience, my expectations & why I want to join Jupiter.
Add your answer

Q1. Find connected components in a graph
Ans. 
Use Depth First Search (DFS) to find connected components in a graph
• Start by initializing all vertices as unvisited

• Iterate through each vertex and perform DFS to find connected components

• Keep track of visited vertices to avoid revisiting

• Example: For a graph with vertices {A, B, C} and edges {(A, B), (B, C)}, the connected components are {A, B, C}
Answered by AI
Add your answer

Q1. Design chess game
Ans. 
Design a chess game with proper board setup, piece movements, and win conditions.
• Create a 8x8 grid to represent the chess board

• Assign initial positions to each type of chess piece (pawn, rook, knight, bishop, queen, king)

• Implement rules for each piece's movement (e.g. pawn moves forward, rook moves horizontally/vertically)

• Check for valid moves and capture opponent's pieces

• Implement win conditions (checkmate, stalemate)

• ...read more
Answered by AI
Add your answer

Q1. DHCP and DNS difference
Ans. 
DHCP assigns IP addresses to devices on a network, while DNS resolves domain names to IP addresses.
• DHCP dynamically assigns IP addresses to devices on a network

• DNS resolves domain names to IP addresses

• DHCP is used for automatic IP address configuration

• DNS is used for translating domain names to IP addresses

• DHCP operates at the network layer (Layer 3)

• DNS operates at the application layer (Layer 7)
Answered by AI
Add your answer
Q2. Networking protocols and respective port numbers.
Ans. 
Networking protocols and their respective port numbers are essential for communication between devices.
• HTTP - Port 80

• HTTPS - Port 443

• FTP - Port 21

• SMTP - Port 25

• SSH - Port 22

• DNS - Port 53
Answered by AI
Add your answer

Q1. Current and expected Salary
Add your answer
Q2. Reason for leaving the current company.
Add your answer