Goodworker Technologies Pvt ltd. Interview Experience for SDE-1 (1.5 Years Experienced)

There were two rounds of interviews.

Round 1: It involved two coding questions.

1. https://leetcode.com/discuss/interview-question/1397869/compass-online-assessment-questions
2. https://www.geeksforgeeks.org/check-if-a-word-exists-in-a-grid-or-not/

Round 2: It involved some questioning and project discussion.  Some questions asked are:
1. Project discussion
2. Monlithic vs microservice
3. How to prevent spam traffic from external API
4. NoSQL vs SQL
5. Caching uses. Why use caching
6. LRU cache implementation
7. Indexing, Primary key, foreign key, composite key,  Normalization
8. Joins and their types.
9. Given two tables employee(id, first_name,last_name,mobile,email) and attendance(id,employee_id,date,time_logged). Get aggerate of time logged for each employee 
10. Alter command in SQL