Interview Questions

Replace each node's value with the next greater value in the list. Addressed edge cases where no greater element exists.

Retrieve Schema of BigQuery Table

Review Kafka fundamentals and concepts.

SCD Implementation in ETL

SCDs: Types of Slowly Changing Dimensions and their use cases

SELF JOIN Applications - scenarios like manager-employee relationships

SQL Case study involving bank liabilities, loans, and balances - extensive JOINs and CASE statements

SQL Cross Join - difficult question

SQL Problem - multiple table joins and window functions

SQL Query Design: employees with highest salaries within each department

SQL Query Optimization techniques

SQL Query for 2nd Highest Salary without Using MAX()

SQL Query for Best of 3 Marks and Average in a Student Table

SQL Query to Find Average Sessions per User within 30-day period

SQL Query: Group Employees by Technology and Order by ID

SQL Question - Cricket Scoreboard Table - aggregations, joins, grouping

SQL Question - Inner Join with Null Handling, compute total row count

SQL query with LAG function.

SQL questions: Group By, Joins, Correlated Queries

Scenario: Query optimization for a large dataset.