Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Meta nel mese di giu 2020
Colloquio
Found a FB recruiter on linkedin and send her a connection request. Next day got a reply back asking for contact details and if I am interested in positions in Data Engineer.
3 days later got a call with another recruiter who asked 5 sql and 5 python questions. Sql question on left join, having clause etc and python on linked list, stack (what data structure is FIFO) true/false type questions.
Post that was given 14 days to prepare for telephonic interview - same as 30 mins SQL and 30 mins python.
Telephonic interview was nice but again its matter of how comfortable and fast you are. I was able to answer 3 out of 3 sql and 2 out of 3 python. Was short of time so interviewer gladly asked to close the call.
I think I can do better in direct interviews where they ask design questions but these coding interviews with timer make me nervous. Please focus on that part and you can easily be able to go past this round. Most of the questions are same as in glassdoor.
Domande di colloquio [1]
Domanda 1
SQL questions on promotions, sales schema.
what %age of products have both non fat and trans fat.
find top 5 sales products having promotions
what %age of sales happened on first and last day of the promotion
Mysql was used and interviewer asked to if this can be done without subquery.
Python:-
[1,None,1,2,None} --> [1,1,1,2,2]
Ensure you take care of case input[None] which means None object.
find s in missisipi.
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Domande di colloquio [1]
Domanda 1
Tell us about yourself and why you want to work for us
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Meta (New York, NY)
Colloquio
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.
