Recruiter then a 30 mins interview with the hiring manager. That's about fit and also a behavioral interview.
After a standard panel of 1 SQL interview, there was 1 system design and 1 coding interview.
It's a nicely designed panel where all the questions are around the same ETL pipeline. The question is asked in a confusing way so try to focus on the specific asks.
In the sys design part, they assess the depth of your understanding of the process while asking you to design an ETL pipeline. You'd want to revise concepts such as CDC, queues, batch and stream processing frameworks and things you can do when pipelines fail.
In the coding part, you're asked to implement the transform part of the pipeline. You have to aggregate the data together and transform it etc. It's no algorithmic challenge, it's about how comfortable you are with Python data structures to manipulate a whole bunch of data very quickly during an interview. You start with JSON input and massage the dataset to get it into the right shape.
Finally the SQL interview- you're asked to come up with and write several queries to check whether the data was copied properly. You'd want to do checks like row count checks etc
The following metrics were computed from 1 interview experience for the Betterment Senior Data Engineer role in United Arab Emirates.
Betterment's interview process for their Senior Data Engineer roles in the United Arab Emirates is extremely selective, failing the vast majority of engineers.
Candidates reported having very good feelings for Betterment's Senior Data Engineer interview process in United Arab Emirates.