Tell me about your previous experience and describe interesting problem that you faced.
Senior Data Engineer Interview Questions
2,569 senior data engineer interview questions shared by candidates
I was asked multiple scenarios about handling the situation with client apps updating data in near real time.
How would you build a data pipeline?
The Packages table represents packages that customers purchase. Each package has an ID, a start and end date (represented by a number), and a number of installs that the package includes. The Consumption table shows us how many installs each account used and when. When we get a user's consumption data, we need to check according to the date, which packages the user used. A user can only have one package at any given time. The report we need to calculate needs to show how many installs a user used from each of its packages, and how many installs remain in each package the user purchased. Packages table +-----+-------------------+----------------+-------------------+ |pack |pack_end_date |pack_installs |pack_start_date| +-----+-------------------+----------------+-------------------+ | 1 | 123460| 10| 123456| | 2 | 123470| 5| 123460| | 3 | 123475| 10| 123470| +-----+-------------------+----------------+-------------------+ consumption table +----------+--------------+---------+ |account |install_date | installs| +----------+--------------+---------+ | AB| 123459| 10| | AB| 123465| 5| | AB| 123466| 3| +----------+--------------+---------+
Tell us about your current project and what skills have you applied
Explain a challenging project in your career. How did you manage it?
What is the difference between Unit Test and Integration Test?
Did you work with external customers. Experience in Databricks/Spark/Scala. Salary expectations. What environment you like
How do you parallelize python code to improve its performance?
Live Coding with Java and IntelliJ Past Experience
Viewing 1381 - 1390 interview questions