Candidatei-me online. O processo levou 4 semanas. Fui entrevistado pela Gameskraft (Bengaluru) em jul. de 2022
Entrevista
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
Candidatei-me por meio de recrutador(a). O processo levou 1 semana. Fui entrevistado pela Gameskraft (Bengaluru) em ago. de 2022
Entrevista
- 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
Perguntas de entrevista [1]
Pergunta 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.
