The technical interviews was a Coding Challenge and System Design. The coding challenge consisted of SQL and leetcode type of question (interviewers mentioned their focus was to understand how the interviewee thinks through problems and not so much on the most optimized approach).

The Design System question revolved around designing an ETL system where there are several different types of data sources (Streaming, API, SFTP) where the end goal is to have Insights access the data.

Question

The technical interviews was a Coding Challenge and System Design. The coding challenge consisted of SQL and leetcode type of question (interviewers mentioned their focus was to understand how the interviewee thinks through problems and not so much on the most optimized approach).

The Design System question revolved around designing an ETL system where there are several different types of data sources (Streaming, API, SFTP) where the end goal is to have Insights access the data.

Anonymous · Accepted Answer

For Coding challenge, I made sure to know all the different SQL functions (window, case when, CTE, having/qualify).

For the Design Session, I made to sure to understand Medallion Architecture as granular as possible -- including where to log, test, orchestrate, access.

Lark

Lark interview question

Interview Answer

Followed companies

Job searches

Bowls

Want the inside scoop on your own company?