ATHENAHEALTH | MTS | CHENNAI | GHOSTED
Summary
I had an interview experience for the Member Technical Staff role at Athenahealth in Chennai, which consisted of an online assessment and two technical discussion rounds. I successfully cleared the initial rounds but was unfortunately ghosted after the final technical discussion.
Full Experience
My interview journey with Athenahealth for the Member Technical Staff role in Chennai, with 3.5 years of experience, started with an Online Assessment.
1st Round: Online Assessment
In this round, I encountered two coding challenges. The first problem asked me to find the length of the longest subsequence of string X which is a substring in sequence Y. The second was described as a tricky array question, which I don't recall the specifics of. I successfully cleared this round.2nd Round: Technical Discussion 1
This round involved a mix of theory and practical coding. I was asked a few theory questions on Java and SQL. Following that, I had to write Spring Boot REST CRUD APIs for an employee database. There were also two specific coding questions: one was the classic LeetCode problem "Longest Substring Without Repeating Characters", and the other required me to implement Merge Sort. Finally, I had to write an SQL query based on a self-join. I was selected to proceed to the next round.3rd Round: Technical Discussion 2
The final technical round began with a coding question: given two maps, I needed to return a new map with elements from both, excluding any common keys. This was followed by a Low-Level Design (LLD) question to design a restaurant ordering system, where I had to outline the DB schema, classes, microservice design, and APIs. Although I provided a good design, I struggled when asked to write some queries based on my schema. The interviewer also inquired about the data structure I would use for autocomplete search functionality for restaurants by location. Additionally, there were some theory questions on DNS and API Gateway.Ultimately, after this round, I was ghosted by the company.
Interview Questions (8)
Given two strings 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.
Design and implement Spring Boot REST CRUD APIs for an employee database.
Implement the Merge Sort algorithm.
Write an SQL query involving a self-join.
Given two maps with some key-value pairs, return a new map containing elements from both maps but excluding any keys that are common to both.
Design a restaurant ordering system. This includes designing the database schema, defining classes, outlining microservice architecture, and specifying APIs.
Which data structure would you use to implement an autocomplete search functionality for searching restaurants by location?
Preparation Tips
Reflecting on my experience, a key learning point was the importance of thorough SQL knowledge and diverse data structures. I believe fumbling one SQL query and not knowing the Trie data structure for the autocomplete search contributed to my outcome. I regret not having studied Trie DS more thoroughly.