Aug 5, 2018
2 Sum
Data Engineer Interview Questions
18,677 data engineer interview questions shared by candidates
2 Sum
The percentage of female customer base
Solve 3 SQL problems
Python graph node count
Python Questions: Avg length of words, some of the edge cases are having spaces in the beginning and end of the words, returning a float instead of int, returning None for blank input. Valid ip address, edge case to remember is if there are alphanumeric characters. SQL questions: One SQL question was tricky because you have to look at the data to come up with the question, the question is to find the percent of valid promotion, condition to find valid promotion is not specified in the question, so you have to figure it from looking at the data. Other SQL questions are based on a join, group by, top(3)
sql : inner join , cases , order by , limit python: avg length of sentence , valid IP address
Flatten a nested dictionary?? ( this was the hardest question in coder pad questions )
Onsite - 3 full stack interviews: given a KPI, choose the right metric, perform ETL (SQL/Code) . 1 lunch interview - casual discussion where you learn more about working in facebook and the interviewer tries to understand if you are a good fit.
Python coding: count the same letters in a single word
See other posts - mine were similar/the same for the phone screen. Had to sign an NDA for the virtual onsite, so can't give details.
Viewing 101 - 110 interview questions
See Interview Questions for Similar Jobs
Analytics EngineerModeling EngineerPerl DeveloperEtl TesterData ModelerData Warehouse DeveloperDatabase AdministratorMachine Learning ScientistDatawarehouse DeveloperData MinerBusiness Objects DeveloperData Warehouse ManagerData AnalystBusiness Intelligence SpecialistEtl DeveloperData Warehouse ArchitectData ScientistOracle Data IntegratorDatastage Developer