AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
GfK MODE
Compare
Filter interviews by
GfK MODE Data Engineer Interview Questions, Process, and Tips
GfK MODE Data Engineer Interview Experiences
1 interview found
Anonymous
I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. What is coalesce
- Ans.
Coalesce is a function used to return the first non-null value in a list of expressions.
Coalesce function is commonly used in SQL to handle null values.
It takes multiple arguments and returns the first non-null value.
Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
- Q2. What is repartition
- Ans.
Repartition is the process of redistributing data across partitions in a distributed system.
Repartitioning helps in balancing the workload and improving performance in distributed computing environments.
It involves moving data between partitions based on certain criteria such as key values or hash functions.
Repartitioning can be done in Spark using operations like repartition() or coalesce().
(2 Questions)
- Q1. Non repeatable character
- Ans.
A non repeatable character is a character that appears only once in a given string.
Iterate through the string and count the frequency of each character
Identify the characters that have a frequency of 1
Return the first non repeatable character found
- Q2. Sort list without sort method
- Ans.
Sort list without using sort method
Create a custom sorting function using loops
Compare each element with every other element to determine the correct order
Swap elements based on the comparison results
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I was interviewed in Sep 2024.
They asked various questions on guestimates and few SQL Questions
(2 Questions)
- Q1. They asked questions on spark, SQL and Python
- Q2. They asked questions on ADF as well
(2 Questions)
- Q1. They majorly focused on PySpark and ADF in this round
- Q2. They focused on the project also in this round
(1 Question)
- Q1. They focused on managerial-related questions in this round
I applied via Instahyre and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic Spark, Python, SQL Questions.
- Q2. Some Data Modelling Questions.
I applied via Campus Placement
Very Tough Test, high chances of giving up in the beginning. Test was 2 hrs, covered OOPS, Networks, ML, SQL and some other topics total of 8 questions.
(1 Question)
- Q1. Basic AI/ML and SQL/DBMS questions
(1 Question)
- Q1. Mostly about tech stack in projects that I've done, python and AI coding(just asked to write algos) & basic HR
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Sep 2023. There were 2 interview rounds.
1 Python and 1 sql question
(4 Questions)
- Q1. Technical sql and dsa
- Q2. Dsa ,sql,spark, project understanding
- Q3. Puzzle related questions
- Q4. Dsa focused array and string
I applied via Naukri.com and was interviewed in Sep 2023. There was 1 interview round.
(1 Question)
- Q1. How to read and write parquet files in pyspark?
- Ans.
Reading and writing parquet files in PySpark involves using the SparkSession API.
Create a SparkSession object
Read a parquet file using spark.read.parquet() method
Write a DataFrame to a parquet file using df.write.parquet() method
Skills evaluated in this interview
Data Engineer Interview Questions & Answers
Acuity Knowledge Partners
arpita shetty
posted on 2 Aug 2024
Selected
I applied via Referral and was interviewed before Aug 2023. There were 3 interview rounds.
(1 Question)
- Q1. Windows function on sql
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a set of rows related to the current row
They do not cause rows to become grouped into a single output row like aggregate functions
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
(1 Question)
- Q1. Pandas questions
(1 Question)
- Q1. Asked regarding the previous project
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. I/p 1 o.p 1 1,2 1,2,3 Using ab initio
- Q2. Inner Join , left distinct join , delete files grater than 30 days
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
Aws, scala and cloud concept
(1 Question)
- Q1. Python question
Selected
I applied via Job Portal and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. SQL and python medium level questions
GfK MODE Interview FAQs
Tell us how to improve this page.
GfK MODE Interviews By Designations
- GfK MODE Analyst Interview Questions
- GfK MODE Junior Specialist Interview Questions
- GfK MODE Junior Analyst Interview Questions
- GfK MODE Associate Interview Questions
- GfK MODE CSM Project Manager Interview Questions
- GfK MODE Data Engineer Interview Questions
- GfK MODE Operations Executive Interview Questions
- GfK MODE Research Analyst Interview Questions
- Show more
GfK MODE Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
|
Analyst
127
salaries
|  ₹3 L/yr - ₹4.6 L/yr |
|
Junior Analyst
92
salaries
| ₹2.8 L/yr - ₹4 L/yr |
|
Senior Analyst
92
salaries
| ₹3.8 L/yr - ₹5.8 L/yr |
|
Associate
89
salaries
| ₹3 L/yr - ₹4 L/yr |
|
Principal Analyst
66
salaries
| ₹4.5 L/yr - ₹6.1 L/yr |
Nielsen
Kantar
Ipsos
Market Xcel Data Matrix
- Home >
- Interviews >
- GfK MODE Interview Questions >
- GfK MODE Data Engineer Interview Questions
