The percentage of female customer base
Data Engineer Interview Questions
20,163 data engineer interview questions shared by candidates
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.
Match all words in a document against an name dictionary and anonymize them using a hash.
Viewing 111 - 120 interview questions
See Interview Questions for Similar Jobs
Modeling EngineerPerl DeveloperAnalytics EngineerDatabase AdministratorData Warehouse DeveloperDatastage DeveloperDatawarehouse DeveloperData MinerEtl TesterEtl DeveloperData ModelerBusiness Objects DeveloperData AnalystMachine Learning ScientistData ScientistData Warehouse ArchitectBusiness Intelligence SpecialistData Warehouse ManagerOracle Data Integrator