I applied through a recruiter. The process took 1 week. I interviewed at Gameskraft (Bengaluru) in Aug 2022
Interview
- HR discussion about the role
- Two technical rounds focused on Problem Solving and SQL/Database basic
- Last Hiring Manager Round (Best of all) - Designing Datawarehouse/Datalake, Scenario Based Questions, Spark/Hadoop/Kafka/Hive (In depth), Tricky SQL, Multidimensional models
Interview questions [1]
Question 1
DS and Algorithm
SQL problem based on Window Functions
:HM round: (Learning and Feedbacks :) )
Current work-related
Spark (RDD, Datasets/Dataframes) related questions - In-depth,
Kafka - In depth (replication/partitioning/grouping/checkpointing)
Datawarehouse (sorting, indexing, query optimization)
Modeling: Star Schema and Snowflake Schema
Streaming data pipeline/ETL pipelines (CDC - In depth) - Failure handling,
Designing ETL - Scaling based on heavy loads of data,
Large amount of unstructured data - sorting/processing/aggregation/transformation
SQL tricky questions (joins/window functions)
The hiring manager was incredibly kind and highly knowledgeable and next-level technical, and he never stopped giving me advice when I got stuck.
I wish I will get selected next time and work.
At the end, he gave candid feedback.
I applied online. The process took 4 weeks. I interviewed at Gameskraft (Bengaluru) in Jul 2022
Interview
1. Written round
2. Tech interview
3. Tech interview with hiring manager - Hiring manager asked me a scenario based question and I gave answer in a different manner and he rejected. When I googled that question, there were 3 solutions, out of which I gave 2 and he was firm with the third one and he rejected
