Interview Questions

Count the number of nulls in each column of a table.

Create Spark Session, read CSV, join, and write as table. Provide example code.

Create a SQL query to identify customers with purchases above a dynamic threshold.

Create data models for storing users, artists, and related data for music platform

Create partitioned table

Data Modeling and Airflow Scheduling - star schema, cron, backfill

Data Warehouse Design from scratch

Database vs Data Warehouse vs Data Mart vs Data Lake

Define cursors and stored procedures and their use cases.

Delete vs. Truncate in Snowflake?

Demonstrate how to use a LEFT JOIN to combine data from two tables and handle null values.

Describe a challenging project where you optimized a complex ETL process.

Describe a recent project where you used AWS services extensively. What was your role, and what challenges did you face?

Describe a scenario where you disagreed with a product or business team. What did you do?

Describe a scenario where you had to collaborate with a cross-functional team to deliver a solution.

Describe a scenario where you had to make trade-offs between data processing speed and accuracy. How did you approach this situation and what was the outcome?

Describe a scenario where you used Databricks for real-time data processing.

Describe a scenario where you would use a CROSS JOIN vs. an INNER JOIN.

Describe a situation where you had to redesign a data model to meet changing business needs

Describe a situation where you made a mistake in a data pipeline. How did you identify and fix it?