Upload Button Icon Add office photos

Filter interviews by

Modak Analytics Data Engineer Interview Questions and Answers

Updated 15 Mar 2024

Modak Analytics Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 15 Mar 2024

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Duration was around 105 minutes
aptitude, python and java were sections in this round

Round 2 - Technical 

(4 Questions)

  • Q1. What are the languages based in sql
  • Ans. 

    Languages based in SQL include T-SQL, PL/SQL, and SQL/PSM.

    • T-SQL (Transact-SQL) is Microsoft's proprietary extension to SQL used in SQL Server.

    • PL/SQL (Procedural Language/SQL) is Oracle's procedural language extension to SQL.

    • SQL/PSM (SQL/Persistent Stored Modules) is a standard for defining stored procedures and functions in SQL.

  • Answered by AI
  • Q2. What do you understand by oops concepts
  • Ans. 

    Object-oriented programming concepts that focus on classes and objects

    • Encapsulation: bundling data and methods that operate on the data within a single unit

    • Inheritance: ability of a class to inherit properties and behavior from another class

    • Polymorphism: ability to present the same interface for different data types

    • Abstraction: hiding the complex implementation details and showing only the necessary features

  • Answered by AI
  • Q3. Sql queries was asked to find the second highest salary
  • Q4. Java string question based on manipulation
Round 3 - HR 

(3 Questions)

  • Q1. Tell me about yourself
  • Q2. What are the projects that you have done
  • Q3. What are your hobbies and interest and what were your achievement in your school life and college life and was asked about the background check focused on candidate's qualities

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, don't hesitate and stay honest and go with whatever you know. All the best

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Two coding questions, one is easy and the other is difficult. Who solved 2nd question was shortlisted for an interview.

Round 2 - Interview 

(1 Question)

  • Q1. Introduce yourself—questions from OS, DBMS, DSA, Project, and one coding problem.
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Two easy questions two wasy questions two easy questions two easy questions

Round 3 - Technical 

(2 Questions)

  • Q1. Technical interviews was very easy techijcal interviews was very easy very easy very easy
  • Q2. Interviews was conducted in advance of a news conference in the United Kingdom and the European government on Tuesday

Interview Preparation Tips

Interview preparation tips for other job seekers - Ghar was the second man killed by an twowwywiwywuw The new rules would be similar y
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

1 coding question, and basic MCQ

I applied via Referral and was interviewed in Aug 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Find k min elements in given array.
  • Ans. 

    Find k min elements in given array.

    • Sort the array and return the first k elements.

    • Use a min heap of size k to find the k min elements.

    • Use quickselect algorithm to find the kth smallest element and return first k elements smaller than it.

  • Answered by AI
  • Q2. Find that given tree is BST or not.
  • Ans. 

    Check if a given tree is a Binary Search Tree (BST) or not.

    • Traverse the tree in-order and check if the elements are in ascending order.

    • Check if the maximum value in the left subtree is less than the root and the minimum value in the right subtree is greater than the root.

    • Use recursion to check if all subtrees are BSTs.

    • Time complexity: O(n), Space complexity: O(h) where h is the height of the tree.

  • Answered by AI
  • Q3. Find pair in BST with given sum
  • Ans. 

    Given a BST and a sum, find a pair of nodes whose values add up to the given sum.

    • Traverse the BST in-order and store the nodes in a list

    • Use two pointers approach to find the pair with the given sum

    • If the sum is less than the current pair, move the right pointer to the left

    • If the sum is greater than the current pair, move the left pointer to the right

    • If the sum is equal to the current pair, return the pair

    • Time complexit

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was Focused on DS Algo mostly.
2 technical round ( DS Algo)
1 managerial round ( General past working experiences questions)

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Maximal rectangal
  • Q2. Loop in linked list
  • Ans. 

    Loop in linked list is a situation where a node points to a previous node in the list, creating an infinite loop.

    • Check for loops using Floyd's cycle detection algorithm

    • Use two pointers, one moving twice as fast as the other, to detect a loop

    • If the fast pointer catches up to the slow pointer, there is a loop

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Basic hr question regarding your project and all
  • Q2. He was more interested in what is my thinking pattern

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Pyspark, sql, Python.
Round 2 - Technical 

(1 Question)

  • Q1. Python, dsa,PySpark
Round 3 - HR 

(1 Question)

  • Q1. Simple questions
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Not Selected

I appeared for an interview in Jan 2025.

Round 1 - Assignment 

2 MCQs sections based on SQL and Power BI.

Round 2 - Technical 

(3 Questions)

  • Q1. Standard SQL question - 6 to 8 queries.
  • Q2. Case studies - 2 in total.
  • Q3. Why I'm curious about Data Science and other Data science related personal talk to understand the understanding in Data domain
Round 3 - One-on-one 

(2 Questions)

  • Q1. Medical to Hard level SQL and Power BI - DAX queries. 5-6 queries.
  • Q2. Again talked about Data Science and called back again after 4 hours to know more about my SQL understandings.
Round 4 - HR 

(2 Questions)

  • Q1. 15 min quick discussion. Discuss the roles and responsibilities. Discuss the salary.
  • Q2. Guy looked exhausted and wrap the call quickly.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be cautious with HR, I know if you're searching for job you've some really good skills and knowledge but communication is key undoubtedly.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in May 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Just basic questions. Checking our rnglish communication.
Round 3 - One-on-one 

(1 Question)

  • Q1. Ask about my skills and learn me to study extra skills for the next round
Round 4 - Technical 

(1 Question)

  • Q1. Asked about advanced excel questions. And sql and datas in my resume.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Aptitude Test 

(1 Question)

  • Q1. We need to complete 40 questions in 20 mins

Modak Analytics Interview FAQs

How many rounds are there in Modak Analytics Data Engineer interview?
Modak Analytics interview process usually has 3 rounds. The most common rounds in the Modak Analytics interview process are Aptitude Test, Technical and HR.
How to prepare for Modak Analytics Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Modak Analytics. The most common topics and skills that interviewers at Modak Analytics expect are AWS, GCP, Kafka, Perl and Python.
What are the top questions asked in Modak Analytics Data Engineer interview?

Some of the top questions asked at the Modak Analytics Data Engineer interview -

  1. What are the languages based in ...read more
  2. what do you understand by oops conce...read more
  3. sql queries was asked to find the second highest sal...read more

Tell us how to improve this page.

Modak Analytics Data Engineer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Sigmoid Interview Questions
3.3
 • 59 Interviews
ZoomRx Interview Questions
3.1
 • 36 Interviews
Dunnhumby Interview Questions
4.0
 • 29 Interviews
Jasper Colin Interview Questions
4.1
 • 25 Interviews
Everest Group Interview Questions
3.3
 • 25 Interviews
GfK MODE Interview Questions
3.3
 • 23 Interviews
View all
Modak Analytics Data Engineer Salary
based on 51 salaries
₹5 L/yr - ₹13 L/yr
29% less than the average Data Engineer Salary in India
View more details

Modak Analytics Data Engineer Reviews and Ratings

based on 3 reviews

3.5/5

Rating in categories

5.0

Skill development

3.0

Work-life balance

3.0

Salary

3.8

Job security

3.0

Company culture

3.0

Promotions

4.7

Work satisfaction

Explore 3 Reviews and Ratings
Software Development Engineer
54 salaries
unlock blur

₹4.8 L/yr - ₹9 L/yr

Data Engineer
51 salaries
unlock blur

₹5 L/yr - ₹13 L/yr

Software Developer
35 salaries
unlock blur

₹4.8 L/yr - ₹12 L/yr

Software Engineer
34 salaries
unlock blur

₹4 L/yr - ₹11.7 L/yr

Hadoop Administrator
25 salaries
unlock blur

₹5.2 L/yr - ₹16 L/yr

Explore more salaries
Compare Modak Analytics with

Markelytics Solutions

4.7
Compare

Savista Global Solutions

4.0
Compare

Jasper Colin

4.1
Compare

GfK MODE

3.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview