Company : Athenahealth
Role: Member Technical Staff
Experience : 3.5
Location: Chennai
1st Round : Online Assessment
1st question : Given two string X and Y of length N and M respectively. The task is to find the length of the longest subsequence of string X which is a substring in sequence Y.
2nd : Tricky array question
Verdict : Selected
2nd Round : Technical Discussion 1
Few theory questions from java and SQL
Asked to write Spring boot REST CRUD APIs for employee db.
2 coding questions
- https://leetcode.com/problems/longest-substring-without-repeating-characters/description/
- Merge sort
And lastly sql query based on self join.
Verdict : Selected
3rd Round : Technical Discussion 2
Coding question : Given two Maps with some key value pairs need to return a new map with elements from both map excluding the common keys present in both the maps.
LLD question : Design a restaurant ordering system asked to design db schema, classes, how microservices will be designed and asked to write APIs.
I provided a good design but suddenly he asked to write some queries based on my schema design which I fumbled.
Also asked which data structure I will use to implement autocomplete search functionality if we need to search restaurant with location.
Asked few theory questions on DNS, API Gateway
Verdict : Ghosted!!
Possible reason for rejection : Fumbled 1 SQL query and didn't answer that DS question which is trie. I didn't study trie DS :(
Hope it helps someone!!
