Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Gameskraft (Bengaluru) nel mese di lug 2022
Colloquio
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
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Gameskraft (Bengaluru) nel mese di ago 2022
Colloquio
- 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
Domande di colloquio [1]
Domanda 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.