Candidatei-me online. Fui entrevistado pela CGI (Bengaluru) em jun. de 2024
Entrevista
The interview process consisted of multiple rounds focusing on technical and scenario-based problem-solving. The panel asked detailed questions on SQL, data pipelines, Hive optimization, and big data concepts. While the discussions were engaging, I did not receive any feedback after the interviews were completed, which made the experience feel incomplete. The difficulty level was high, and the questions required strong technical depth along with practical project knowledge. Overall, it was a challenging process but could have been better with timely communication.
Perguntas de entrevista [1]
Pergunta 1
Q: Can you explain how you would optimize a Hive query that is running slower than expected?
A: I mentioned techniques like using partitioning and bucketing, avoiding SELECT *, preferring ORC/Parquet file formats, and checking query execution with EXPLAIN to tune performance.
Q: What is the difference between Spark and Hadoop MapReduce in terms of performance and execution model?
A: I explained that Spark uses in-memory computation, which makes it much faster than MapReduce, which writes intermediate results to disk. Spark also supports iterative and real-time processing, unlike MapReduce.
Q: Can you describe an ETL pipeline you worked on and how you handled data quality issues?
A: I discussed a project where data was ingested from raw files into Hive, cleaned using Spark, and validated with automated checks. I explained how I implemented null checks, schema validation, and exception handling to ensure reliability.
Le processus d’entretien chez GCI Rabat pour un poste de Data Engineer se déroule généralement en plusieurs étapes. D’abord, une pré-sélection RH à partir du CV suivie d’un court appel pour vérifier la motivation, les compétences générales et les prétentions salariales. Ensuite, un test technique (SQL, Python, ETL, concepts Big Data). Si le test est réussi, un entretien technique avec un senior évalue la maîtrise des pipelines data, Spark, modèles de données et la logique de résolution de problèmes. Une dernière rencontre avec un manager confirme l’adéquation au poste et à l’équipe. Si tout est validé, l’entreprise envoie une offre d’embauche, suivie d’un onboarding.
Perguntas de entrevista [1]
Pergunta 1
Pouvez-vous me décrire un projet Data sur lequel vous avez travaillé et quel était votre rôle exact ?
Candidatei-me por meio de recrutador(a). O processo levou 1 semana. Fui entrevistado pela CGI (Hyderābād) em nov. de 2025
Entrevista
It has 4 rounds of interview. 2 tech rounds, 1 manager round and 1 client discussion.
The process took around 1.5 weeks. Hr reached out to me via nakuri as i am serving notice.
Candidatei-me online. O processo levou 2 semanas. Fui entrevistado pela CGI (Bengaluru) em nov. de 2025
Entrevista
Good focused on scenario based questions Databricks and ADLS concept with delta implementation.
Deep dive in Azure data factory and IR.
Understanding of spark.
SQL and Pyspark coding complex logic.
