how much have experinece in spark?
Data Engineer Interview Questions
20,979 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
Viewing 111 - 120 interview questions
See Interview Questions for Similar Jobs
Modeling EngineerAnalytics EngineerPerl DeveloperDatawarehouse DeveloperEtl DeveloperData ModelerDatastage DeveloperEtl TesterData AnalystOracle Data IntegratorMachine Learning ScientistData ScientistData MinerBusiness Objects DeveloperDatabase AdministratorData Warehouse DeveloperData Warehouse ManagerData Warehouse ArchitectBusiness Intelligence Specialist