Round 1
Questions:
- Count all palindrome substrings.
- 2 Leetcode hard SQL questions.
- 3-4 Spark questions.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 2
Questions:
- Linked list - find a loop and remove it.
- 2 Leetcode hard SQL questions.
- 2-3 Spark questions.
- ETL related questions.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 3
Questions:
- Design a payment system. Create an ER diagram and list all entities and attributes. Then write SQL queries on top of it.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 4
Questions:
- Project discussion.
- Behavioral questions.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 5
Questions:
- Salary discussion.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Final Outcome: SELECTED. But they put me on hold as they found someone else who can join early.