Position: Data Engineer
Location: San Francisco Bay Area, CA
Outcome: Techncal Screen Rejected
How was the interview process? What was it like?
What technical questions were asked?
SQL / Pandas, Business Case and Estimation, Modeling and ML knowledge
What was one of your solutions?
The UNION operator combines and returns the result-set retrieved by two or more SELECT statements.
The MINUS operator in SQL is used to remove duplicates from the result-set obtained by the second SELECT query from the result-set obtained by the first SELECT query and then return the filtered results from the first.
The INTERSECT clause in SQL combines the result-set fetched by the two SELECT statements where records from one match the other and then returns this intersection of result-sets.