It was chill, the interviewer asked which section do you want to start the coding from SQL or Python.
Started with SQL solved 3 questions and then Python solved 2 questions completely and 3rd one because of less time he mentioned just explain the process.
Perguntas de entrevista [1]
Pergunta 1
Python -
1. You are given a dictionary where the key is location of book store and value is the list of reviews as string. the list can have duplicate values. return the most frequent review across all locations after removing the duplicate review for each location.
2. Given a number return the biggest odd number out of it by rearranging digits.
3. Given a list of workshops, return the largest number of classes that were hosted in total across any 2 consecutive years that had at least one workshop each.
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.
Perguntas de entrevista [1]
Pergunta 1
Tell us about yourself and why you want to work for us
Candidatei-me online. Fiz uma entrevista na empresa Meta (New York, NY).
Entrevista
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.