had 3 professional interviews, with the team leader, another team leader in the same group, and with the group leader. The interview with the team leader was very practical and required an above-average SQL exercise and an easy python coding exercise. the two other interviews were an ongoing architecture question, not directly relevant for data scales but to software architecture

1. A call with hr and team lead 2. frontal coding interview 3. system design (need to present a project you worked on) It's wrong and amateur to do a system design on ZOOM. It's challenging enough and if you can't put together two people to be in the office for that, it's not a place to work for