I applied online. I interviewed at EAB (Atlanta, GA) in Dec 2023
Interview
1. Online Aptitude Test: Focused on basic pattern recognition and math questions.
2. Phone Screening: Covered resume-based questions and SQL basics like joins and unions.
3. Live Coding + Behavioral: Included questions on:
• Experience working in production.
• Cross-functional team collaboration.
• SQL query solving (join, count, group by, having).
• Debugging and correcting a DDL query to insert values into rows.
4. Data Analytics Round: Worked with two datasets, creating graphs to analyze the data.
Interview questions [1]
Question 1
Experience working in production.
• Cross-functional team collaboration.
• SQL query solving (join, count, group by, having).
• Debugging and correcting a DDL query to insert values into rows
1st Round: Team Manager Interview
-> Discussion of your background and understanding of the role.
2nd Round: Technical Interview with Data Engineers
-> SQL Coding: Practical coding tasks to assess your SQL skills.
-> Theory: In-depth technical questions covering data engineering principles.
3rd Round: Case Study
-> Detailed case study analysis.
-> Presentation of your solution and thought process.
