I have an interview for L4 Data Engineer at Square and have 45 min SQL and 45 min Python interview round. Could you please help me with what should I be expecting and prepared for? How difficult is it compared to other FAANG companies?
they quiz you on the different transaction isolation levels and how to optimize query plans
Can you give an example ?
How many yrs of exp ?
2
Yoe?
Python was reading code and writing a unit test. SQL was standard. Writing queries with joins. Maybe a window function. Meta is tougher because you have 25 minutes. Every other FAANG level interview is tougher.
Thanks , and do you mean an assertion statement and all?
It's basically reverse engineering a function to match a result. I don't want to get too specific but it will make sense if/when you see it. Also it looks like everyone had a different experience so it might not matter.
Tech Industry
Yesterday
2749
Crossed a line with my boss
Tech Industry
Yesterday
1077
Update: Trans Coworker Stealing Breast Milk
Tech Industry
Yesterday
497
which chinese city better than bay area
Tech Industry
Yesterday
1980
Cute girl on the floor
Tech Industry
Yesterday
3302
The job market is absolutely brutal right now
It's easy, I took the interview at square without even studying anything lol
anything specific like string manipulation , etc?