Window function in sql and uses.
Senior Data Engineer Interview Questions
2,552 senior data engineer interview questions shared by candidates
A simple test on Python and SQL
Had two homework assignments, one about coding in Python and the other one about writing a complicated SQL query. In the interviews we talked about SQL queries, AWS, Python, stakeholder management and mentorship.
Tell me about the last time you broke production.
What can you do to improve the performance of a SQL script?
1. Parse csv using standard library and do joins between tables 2. Optimize the query 3. remove duplicates of records between start date and end date
What is the importance if elastic search and what is inverted indexing.
SQL Questions about joins and looping and window functions.
tell me about your past experience? What is the biggest project you have worked on?
Online Coding Contest on Hackerrank: simple array question to solve in O(n) time and O(1) space 1 question on Binary Tree( medium level) Interview 1: 1.basic array Coding question 2.Coding question on Linked List Theory - OLTP vs OLAP Hadoop vs AWS S3 storage Question on spark(medium level) Interview 2: The interviewer asked me to solve Scenario based question on which he was currently working :P Didn't able to and this properly as many doubtful cases coming into the picture coding question on array(minimize to 1 for-loop, I did it with 2) very simple SQL query( solved with AVG() func) Interview 3: Coding Question on String(simple) coding question on Kadane's Algo questions on mongodb(basics) question on oops(basics) Interview 4(with Manager): 1.coding question on 2D array(medium level) 2.Advance Sql Ques Interview 5(with Head): General Discussion Call with HR : Salary discussion and perks
Viewing 451 - 460 interview questions