Last interview consisted of a case study that was supposed to showcase something I did in the past or I could also pick a task predefined by them.
Senior Data Engineer Interview Questions
2,553 senior data engineer interview questions shared by candidates
Oh, you code in SQL? I sent you a link. CODE SQL OR ELSE!!!!!
Round 2 Interview Topics Python Basic concepts such as generators and iterators. Sorting a list without using built-in functions. SQL Fundamental SQL queries. Analytical operations using window functions and data deduplication. PySpark Optimization techniques. Operations with window functions, grouping, filtering, and exploding data. System Design Questions Provide a detailed explanation of one of your projects, including end-to-end (ETE) project design. How the ETL process flow works?. Describe how you would develop an anomaly detection algorithm and an alerting mechanism.
SQL based leetcode easy questions
Python 1D and 2D Arrays, behavioral questions.
"They asked me to design an end-to-end data pipeline that supports both batch and real-time processing using tools like Kafka, Spark, and a cloud platform like AWS or Azure. They were particularly interested in how I’d handle schema evolution and ensure data quality at each stage."
SQL and Python related questions.
About project design and implementation
Questions related to data modeling, DW design, metadata management, spark
Implement this function, describe how you would optimize, discuss runtime & complexity.
Viewing 2071 - 2080 interview questions