Real questions from top companies · easy
How would you handle null values in a dataset, especially in a single column?
Identify consecutive numbers in a column (at least 3 consecutive).
Merge two dictionaries and remove keys with null values.
Strategies for working with busy team leads?
Tasks where the candidate faced failure and lessons learned.
Tell us about a project where you optimized an existing process or pipeline. What was the impact?
Use cases for internal staging in Snowflake?
Using Airflow to trigger and manage ETL jobs?
What are Assert Transformations, and where are they used?
What is BigQuery Cache?
Write SQL query to replace specific patterns in a string column.
Write a query to find minimum age.
Write a query to find the median salary of employees in a table.
Approaches to handling multiple tasks within a sprint?
Can you share a time when you had to shift focus due to urgent tasks?
Create a DataFrame with default column types
Explain your approach to monitoring and logging Spark jobs in AWS. What tools would you use to identify performance bottlenecks?
How do you compare the time investment and value of a task?
How do you handle bad data in Databricks?
Sqoop Incremental Import?
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.