TikTok Data Engineer interview questions

reached out with an online interview after the first initial application, it was three sql questions, each increasing in difficulty and I had an hour and 25 minutes to complete all three.

Describe the primary data processing frameworks you’ve used (e.g., Spark, Flink) and how they work. What challenges have you encountered in big data processing, and how did you resolve them? For large-scale, real-time data streams, which tools or frameworks would you choose and why? When optimizing performance in a data pipeline, what specific areas do you focus on?