about sql query, left outer join, pivot
Senior Data Engineer Interview Questions
2,447 senior data engineer interview questions shared by candidates
1: OOP 2: DS & Algo (definitions and time/space complexity) 3. SQL
Questions on experience relating to creating end to end data solutions using Azure.
1st round is technical. 2nd round manager will ask your current salary, previous salary, 1st salary. How can you expect x% hike etc.
Q: Using the daily_customer_addresses table, provide all the contiguous date ranges when customer '2051' lived on 123 Main St.
SQL: Calculate moving average of a metric
It was a quick call where they asked about my working experience and expectations.
More around Java threading , oops concept and cluster related questions
SQL questions involving simple aggregations and joins, but my interviewer got caught up on the intricacies of date formatting (that wasn’t part of the question). Since I code primarily in SparkSQL and PySpark he got bent out of shape about how my answer wasn’t correct. Huge waste of my time. There was also a question about calculating rolling averages where the “solution” was a cross join (an antipattern that almost certainly wouldn’t work in a prod environment) so this gives you a sense of what we’re dealing with. The whole thing felt like it was something dreamed up by someone with 2-3 years of data engineering experience who is fully on the Dunning Kruger curve and thinks they’re a lot smarter than they actually are.
Tell me about yourself in detail
Viewing 1281 - 1290 interview questions