Candidatei-me online. Fui entrevistado pela TikTok (Sydney) em ago. de 2023
Entrevista
Initially 30min talk over phone with HR. Then 60min screen share with a team member. This interview include experience talking, technical questions, SQL coding and any language coding. After that, I have not received any update yet for about one week. The organization of the interview was completely chaos. Organizer from US, position was in Australia, Interviewer from Singarpor. And all use different time zone. First HR call was shared with wrong meeting bridge. Interviewer did not show in 2nd Technical call, and then reschedule. Organizer did not even reply my email for several days when the interview no show.
Perguntas de entrevista [1]
Pergunta 1
Q1: What was Hive External Table. What was Hive UDF.
Candidatei-me por indicação de um funcionário. O processo levou 2 semanas. Fiz uma entrevista na empresa 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.
Candidatei-me por meio de recrutador(a). Fiz uma entrevista na empresa 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.
