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.
