Real questions from top companies · easy
Write a decorator function to log the execution time of a function.
Write a higher-order function to filter values greater than a threshold in a list.
Write a swap function without if-else.
Write code for character frequency in a text file.
Write code using Java's concurrent API (forEach, forEachEntry, forEachKey)
Aggregate surface areas and calculate cumulative surface area using the LAG function.
Are you comfortable with the variable pay structure, and what are your expectations for the base salary?
CSV Without Column Names/Schema - how to read
Can CASE statements be used in an UPDATE query?
Can you chain multiple triggers for a single pipeline?
Compare Redshift, BigQuery, and Snowflake in terms of cost, performance, and scalability.
Converting SCD0 to SCD3
Describe a cross-team data project where you had to align architectural boundaries, ownership, and SLAs. How did you handle conflicting priorities, technical debt, and the scalability of communication as the number of stakeholders grew?
Walk through a production incident where data freshness or correctness was at risk. How did you balance immediate mitigation vs. root-cause remediation? What architectural changes would prevent recurrence, and what are the cost vs. reliability trade-offs?
Given a dataset, perform transformations: Filter rows where sales > 1000, Add a new column calculating a 10% discount on sales, Group data by region and calculate total revenue.
How do you count occurrences in a column in SQL?
How do you interact with Google BigQuery using Python?
How do you keep a specific column on top in SQL?
How to view Oozie jobs?
How would you clean the data by filtering out records with null values in user_id?
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.