I applied online. The process took 2 months. I interviewed at Marshmallow in Feb 2025
Interview
**Interview Review**
I applied online in December and received confirmation toward the end of the month. After several follow-ups, I had my first round in January. The tech interview was an hour-long Python coding challenge on API integration, followed by a system design for DWH and a 5-part SQL question. After that, I moved to a hiring manager interview focused on my previous experience and finally had a behavioral interview with the Director of Analytics. Unfortunately, the interview process was disorganized. The interviewer was late and asked some odd questions. Despite what seemed like a good conversation, I received a generic rejection email the next day, which was disappointing. Given the time I invested, I expected at least some feedback rather than a robotic email response.
Interview questions [1]
Question 1
Tech Round (Python Coding for API Integration):
Write Python code to fetch data from an API endpoint and process it.
How would you handle pagination when fetching data from an API?
System Design (Data Warehouse - DWH):
Design a Data Warehouse (DWH) architecture for a large-scale dataset.
What are the key components you would include in a DWH design and why?
How would you ensure data quality and integrity in a DWH?
SQL Question (5-part question):
Write complex SQL queries for data manipulation or retrieval.
Hiring Manager Interview (Experience-focused):
Can you describe your experience with [specific technology or project]?
How did you handle challenges in your previous roles?
How do you prioritize tasks and manage time when working on complex projects?
Director of Analytics (Behavioral Interview):
Tell me about a time you worked under pressure and how you managed the situation.
How do you handle conflict in a team?
Can you describe a situation where you had to make a tough decision at work?
I applied online. The process took 2 weeks. I interviewed at Marshmallow in Jun 2025
Interview
First stage: speaking with the HR person
Second stage: technical interview
Third stage: culture fit interview
I only got to the second stage. I think the overall interview process was lean and fast, they don't waste too much time. The technical interview was not that difficult, but despite completing all tests with time to spare and confirmed by the interview that the solutions are correctly. The feedback was quite negative from the rejection email. I believe the interviewers wasn't communicating well and feed back the right messages during the interview process. I'm guessing probably you need a bit of luck here really.
Interview questions [1]
Question 1
Data modeling about the business, sql question and a simple python question
