HackerRank Questions were related to SQL and programming. The 1st technical discussion was a rigrous one where knowledge on different Hadoop ecosystem like hive, spark, sql, bucketing, joins etc was evaluated. Other technical discussions were on designing the applications.
I had applied for big data role so mainly questions were asked on concepts of spark optimization techniques, SQL queries, hive file formats, Spark configuration, Python, Projects you have worked on which includes academic project as well. Be confident with your answers
Design a system for scraping website for data and then use it for various use cases.
Basics, Hashing, Design Amazon recommendation system
Tell me about yourself/background (typical question
Deep technical assessment question of AWS. For instance, Write scripts in AWS glue moving data from one table to another.
How does Kafka work
What is Spark Parallelism and how do you use it
Walk through my experience My technical skills My projects
On Site: Round1: Detailed discussion on Indexes and how will I use on a given question. (Note study multiple indexes, partial indexes and order) Round 2: (Probably Bar raiser) 1. Top 3 unique salaries and all employees having that per department 2. LC 601 Round 3: Only LP
Viewing 331 - 340 interview questions