- 1st round, technical Assessment through online portal for SQL, Python, and Spark. The site was bad, running anything takes forever. The solution was also incorrect. - 2nd round technical interview with 2 users. First is writing pseudocodes for SQLs and Python pandas. They expect you to have memorized the syntaxes by heart and not google anything for quick reference. The user on this part was also quite hostile. Second part with the other is about data architecture, how to build end-to-end streaming pipelines based on a given use case. They would assess you on how well you gathered the requirements, how you formulated the design, and also performance considerations. Honestly, I enjoyed this part as it really gauges your ability on data engineering compared to the nonsensical coding challenge on the first part of the user interview. In the QnA session, my questions got interrupted by the user that grilled me on the first part even though there is still 15 minutes left. Looks like he really did not like me at all, but this is very unprofessional and rude. Decided to not go forward after advancing to the 3rd round because it does not seem that the work environment would be condusive for proper data engineering.