SQL questions
Big Data Engineer Interview Questions
1,228 big data engineer interview questions shared by candidates
Design Facebook graph search with basic implementation. Create/ implement a chat server, searching a rotated sorted tree.
2. DBMS (Database Management System) Goal: Check your knowledge of databases, queries, and design. Common Topics: SQL Queries → SELECT, JOIN, GROUP BY, HAVING Normalization → 1NF, 2NF, 3NF Transactions → ACID properties Indexes → Types, usage, pros/cons ER Diagrams → Designing schemas Example Question: “Write an SQL query to find the 2nd highest salary from the Employee table.” “Explain the difference between INNER JOIN and LEFT JOIN.” “What are ACID properties in DBMS?” Tip: Even if you forget exact SQL syntax, explain the logic clearly.
Behavioural Interviews have the normal situational questions, Technical Case Interview was quite relevant to the work I am doing. It is good to stay prepared.
What do you know about Hadoop?
why are passionate about the technology industry?
Rate Your DSA , SQL and Coding skills out of 10. What do you know about Big Data? Asked basics of SQL. 2 queries related to finding salaries (3rd highest and Nth highest) from employee table. Deep Learning Project in detail. Build a BST from scratch with given list of elements (Python only) Both Explanation and code.
Describe the past projects you did
How do you find the largest kth element in a Table with SQL?
Video interview with a technical manager about how to retrieve data from big data platform, and how to design a Datawarehouse for a specific situation
Viewing 351 - 360 interview questions