Me postulé a través de un reclutador. El proceso tomó 1 semana. Acudí a una entrevista en TikTok
Entrevista
The interview was in Zoom. The interviewer was disconnected from the Internet in the middle of the interview, so I have to continue the interview via phone call. Still got rejected.
Preguntas de entrevista [1]
Pregunta 1
Given a purchase table(user, purchase_time, amount_of_money, level1_category, level2_category), write a sql query to find the customer purchase in continue 7 days and with the total money greater than 500
Me postulé a través de una recomendación de un empleado. El proceso tomó 2 semanas. Acudí a una entrevista en TikTok (San Jose, CA)
Entrevista
3 rounds in total. Every round will have deep dive on Resume, foundation questions, 2-3 Coding questions, BQ questions... Overall fair enough. Coding on their own platform. Might interview in Chinese sometimes.
First round of tech interview: 3 questions, 1 SQL hard, 1 SQL medium and 1 brain teaser. Interviewer asked to code in a notepad and insist my solution was wrong. As I couldn't run the code in IDE I couldn't prove my code was right. After my interview I ran my code and it is working perfectly well.
Me postulé a través de un reclutador. Acudí a una entrevista en TikTok
Entrevista
I solved complex SQL problems, discussed Spark architecture, and answered performance optimization questions, including indexing strategies, partitioning, query tuning, and resource management in distributed data processing systems effectively and efficiently.
