Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Shopee
Colloquio
The interview process is too bad, they asked a lot of questions ranging from hardware to software. I feel that if you are very passionate in databases (different from data analytics), then this role should be suitable for you.
Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Shopee (Singapore) nel mese di apr 2022
Colloquio
3 Tech Round & 1 HR Round
First round is online assessment with MCQs and fill in the blank and one SQL question (cannot test). MCQs questions are about what tools to use to handle certain situations and basic knowledge of database.
Second round is tech interview. Questions are based on your resume. I got the questions like python memory management, shallow copy and deep copy, MySQL mvcc properties, row lock, buffer pool. The interviewers are nice and giving a lot of hints during interview.
Third tech interview is with the team lead. He shared with me about the job detail clearly and asked a question about how a SQL query works.
Last round is HR interview that asked about your preference to work in Singapore, salary discussion, introduced the benefits and etc.
Domande di colloquio [1]
Domanda 1
python memory management, shallow copy and deep copy
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Shopee (Singapore) nel mese di mar 2022
Colloquio
Online assessment with no screen monitoring. 30 MCQ including 1 sql question.
Two more technical rounds if pass the OA.
First technical round - OS, DB, network, programming language + 3 coding questions.
Coding questions are relatively easy.
Domande di colloquio [1]
Domanda 1
binary search
sort an array without using inbuilt function
How an insert query works under the hood?
Raid 5
TCP header vs IP header
