Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Meta (Menlo Park, CA) nel mese di mag 2019
Colloquio
1 hour phone screen;
SQL questions were fair but hard. The database schema has had 4 or 5 tables but the questions were related to one table only. In 30 min, I was able to answer only 2 sql questions instead of 3. In addition, answers with sub queries are not counted towards correct solution.
python/java coding examples are easily found glassdoor, but not SQL.
Domande di colloquio [1]
Domanda 1
SQL:
1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products
2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales.
Coding(Java):
1. find avg word length in a sentence
2. ip address validation
3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);
Starts with a screen, followed by leetcode style SQL+Python questions, Full loop of SQL, Python, SQL plus Python and lastly behavioural round. Every round is also an architecture round in some sense.
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.