Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto più di una settimana. Ho sostenuto un colloquio presso Impetus Technologies (Nuova Delhi) nel mese di dic 2020
Colloquio
I applied through recruiter via LinkedIn. Recruiter schedule the interview according to my available time. There was 2 technical rounds. In first round main focus is SQL. And they gave one code in my case find second largest element in Array. Interviewer asked about proj,Sqoop,hive,spark basic questions. In second round main focus is on again sql hands-on , and spark practical scenario based questions.
Domande di colloquio [3]
Domanda 1
Table with duplicates . how to get unique records in that table.
Given the following table named A:
x
------
2
-2
4
-4
-3
0
2
Write a single query to calculate the sum of all positive values of x and the sum of all negative values of x.
Ho sostenuto un colloquio presso Impetus Technologies
Colloquio
L1l2 rounds 1 rounds asked about GCP Big Query Partition clustering and How do u handle large data For Backup In Coldline and Nearline storage with code and GCP Console code to tranfer big file with backup options
Domande di colloquio [1]
Domanda 1
L1l2 rounds 1 rounds asked about GCP Big Query Partition clustering and How do u handle large data For Backup In Coldline and Nearline storage with code and GCP Console code to tranfer big file with backup options
Thank you for sharing your experience with us! We’re glad to hear that you found the process positive and interactive. Creating a transparent and welcoming experience for every candidate is our priority, and we’re glad that it is reflected in your journey. Wishing you all the best!
Ho presentato la mia candidatura online. La procedura ha richiesto 4 giorni. Ho sostenuto un colloquio presso Impetus Technologies (Bengaluru) nel mese di lug 2025
Colloquio
It was smooth, Got a call for first round, started with intro and project I've worked on, as it was technical focused more on pyspark and sql. Data Engineering principles and processes.
Domande di colloquio [2]
Domanda 1
Databricks and spark architecture and deep dive into it.
Ho sostenuto un colloquio presso Impetus Technologies (Gurgaon, Haryana)
Colloquio
The interview was all based upon python, spark and sql. Questions were easy to moderate level. Mostly from python and sql. Questions like : a table consists of some positive and some negative integers. Write a query to create a new table and to separate positive integers in positive _numbers column and negative integers in negative_numbers column
Domande di colloquio [1]
Domanda 1
a table consists of some positive and some negative integers. Write a query to create a new table and to separate positive integers in positive _numbers column and negative integers in negative_numbers column
Thank you for sharing your interview experience. We're glad to hear that you found the questions relevant and aligned with your skills.
Wishing you all the best in your professional journey, and thank you once again for considering Impetus.