I applied through a recruiter. The process took 3 weeks. I interviewed at Stellar Health (New York, NY) in Oct 2021
Interview
1. Technical take-home assessment.
2. A 1 HR review of the assessment and follow-up questions
3. Two whiteboards technical interviews
Overall a small company with an interesting product and smart engineers.
A red flag for me was some interviewers were not welcoming and didn't encourage collaboration. The exact quote: "It's not about what I think, it's about what you think." It might not be the best environment.
Interview questions [1]
Question 1
Take-home assessment: You have 2 hours to complete a program that reads a log file from AWS S3, removes dates from the log and pushes it back to S3. Watch out for inconsistent data!
Whiteboard interviews:
1. Leetcode easy-medium question. Don't worry about collaboration during the problem solving. They don't care and actually want you to solve it solely by yourself.
2. Create an API that stores claims for a patient. Hint: use HashSet to store patients and ArrayList for claims.
Great company but I didn't to well on the algorithm question. Would love to try again if opportunity arises.
There were 2 different interview questions, an API and an algorithm question.
I applied online. I interviewed at Stellar Health in Aug 2020
Interview
The interview flow is very typical. First HR phone screening, then a 2-hr homework. Next is a follow-up interview for the homework. If everything goes well, there will be 2 rounds whiteboard coding interview. I failed the first SQL one, so I guess the second one should be algorithm.
Everyone is very nice, but no response any more for my requirement of feedback after I got the refusal.
Interview questions [1]
Question 1
1. Homework. String replacement for a matching pattern.
2. Follow up of homework. Such as how to improve efficiency.
3. White board coding. Interviewer used some database tables from their daily work. Let me tell another story. Company ABC has several offices and HQ is in NYC. In Covid-19, IT department needs a few employee to work in HQ office a few days every week and the rest work from home. We have following table:
HQOfficeAttendance( employee_id, work_date);
TotalAttendance( employee_id, work_date);
Department( employee_id, depart_id);
Q1: how many attendance for IT department in HQ office for every month in the past year?
Q2: how many attendance EXCEPT IT department in HQ office for every month in the past year? Note: one IT employee could work at both office and home, but not in same day. ( I make a mistake in the left join )
Q3: follow up. How to design an API to query it?
