Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Exponentia.ai Team. If you also belong to the team, you can get access from here

Exponentia.ai Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Exponentia.ai Associate Data Engineer Interview Questions and Answers

Updated 12 Nov 2022

Exponentia.ai Associate Data Engineer Interview Experiences

1 interview found

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 - Aptitude Test 

Medium to difficult level Questions

Round 3 - Technical 

(2 Questions)

  • Q1. SQL queries and python
  • Q2. BI related questions
Round 4 - Technical 

(1 Question)

  • Q1. SQL queries and python codes
Round 5 - HR 

(1 Question)

  • Q1. Soft skills and background

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice company for freshers who are opting career in data/business analytics

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. How to decide upon Spark cluster sizing?
  • Ans. 

    Spark cluster sizing depends on workload, data size, memory requirements, and processing speed.

    • Consider the size of the data being processed

    • Take into account the memory requirements of the Spark jobs

    • Factor in the processing speed needed for the workload

    • Scale the cluster based on the number of nodes and cores required

    • Monitor performance and adjust cluster size as needed

  • Answered by AI
  • Q2. Question on Spark internals
Round 2 - Case Study 

Implement a pipeline based on given conditions and data requirement

Round 3 - HR 

(1 Question)

  • Q1. There were no questions as such. They want me join on very next day when the HR discussion was over and started itimidating me with aggressive approach even without discussing the salary part and the benef...

Interview Preparation Tips

Interview preparation tips for other job seekers - I could clear both the rounds and salary discussion was the only thing left I decided not to join the company because of the way HR handled the process.
Based on the HR behaviour, I can say there is no respect for an employee/ candidate.
The behaviour was like as if I am at the mercy of the employer and I don't have any other company in this world.

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Spark and airflow related questions
  • Q2. AWS services and it's related questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. NLP based question
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(4 Questions)

  • Q1. Components of Databricks
  • Ans. 

    Databricks is a unified data analytics platform that includes components like Databricks Workspace, Databricks Runtime, and Databricks Delta.

    • Databricks Workspace: Collaborative environment for data science and engineering teams.

    • Databricks Runtime: Optimized Apache Spark cluster for data processing.

    • Databricks Delta: Unified data management system for data lakes.

  • Answered by AI
  • Q2. How to read a json file
  • Ans. 

    To read a JSON file, use a programming language's built-in functions or libraries to parse the file and extract the data.

    • Use a programming language like Python, Java, or JavaScript to read the JSON file.

    • Import libraries like json in Python or json-simple in Java to parse the JSON data.

    • Use functions like json.load() in Python to load the JSON file and convert it into a dictionary or object.

    • Access the data in the JSON fi...

  • Answered by AI
  • Q3. Second highest salary SQL
  • Ans. 

    To find the second highest salary in SQL, use the MAX function with a subquery or the LIMIT clause.

    • Use the MAX function with a subquery to find the highest salary first, then use a WHERE clause to exclude it and find the second highest salary.

    • Alternatively, use the LIMIT clause to select the second highest salary directly.

    • Make sure to handle cases where there may be ties for the highest salary.

  • Answered by AI
  • Q4. How to configure the spark while creating the cluster
  • Ans. 

    Spark cluster configuration involves setting up memory, cores, and other parameters for optimal performance.

    • Specify the number of executors and executor memory

    • Set the number of cores per executor

    • Adjust the driver memory based on the application requirements

    • Configure shuffle partitions for efficient data processing

    • Enable dynamic allocation for better resource utilization

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Dec 2023. There were 4 interview rounds.

Round 1 - Coding Test 

I cannot recall the platform, but it featured a combination of Python and SQL questions, with the majority being focused on SQL.

Round 2 - One-on-one 

(2 Questions)

  • Q1. SQL basics like Indexes, Clustering, Keys, Data warehousing concepts, Normalization and Denormalization etc..
  • Q2. SQL coding questions
Round 3 - One-on-one 

(2 Questions)

  • Q1. SQL questions to solve using different types of joins
  • Q2. Questions based on project and data quality checks
Round 4 - HR 

(2 Questions)

  • Q1. Behavioral questions
  • Q2. Culture fit

Interview Preparation Tips

Interview preparation tips for other job seekers - Fractal typically emphasizes core skills in programming and data engineering. It is important to have a solid understanding of the fundamentals and to be prepared for coding challenges, as well as knowledge of data warehousing and ETL concepts.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Feb 2022. 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 - Aptitude Test 

MCQ SQL round coding easy questions

Round 3 - Technical 

(1 Question)

  • Q1. Resume based questions mostly on SQL, Python, Cloud basic to medium level
Round 4 - Technical 

(1 Question)

  • Q1. It was both mangerial and technical round similar to round 1 but more deep

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your resume well because questions are mostly from resume

Interview Questionnaire 

1 Question

  • Q1. Round 1: Coding round, Round 2: Basic and conceptual from Spark and Hive, Round 3: In Depth question from Spark and Hive, Write code in Spark and Hive.

Interview Preparation Tips

Interview preparation tips for other job seekers - They will grill you on whatever knowledge you have in Big data. Be very thorough and confident with your concepts. Also, Practice SQL and Spark codes. They will ask you to write an application in Spark.

I applied via Naukri.com and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions about the project, responsibilities. Basic oop concepts, programming questions, sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on understanding the fundamentals, show that you're willing to learn as you grow in your career

I applied via LinkedIn and was interviewed in Aug 2020. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. A program was given and asked to identify the number of stages.
  • Q2. In a word count spark program which command will run on driver and which will run on executor
  • Ans. 

    Commands that run on driver and executor in a word count Spark program.

    • The command to read the input file and create RDD will run on driver.

    • The command to split the lines and count the words will run on executor.

    • The command to aggregate the word counts and write the output will run on driver.

    • Driver sends tasks to executors and coordinates the overall job.

    • Executor processes the tasks assigned by the driver.

  • Answered by AI
  • Q3. SQL questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the spark architecture and sql

Skills evaluated in this interview

Exponentia.ai Interview FAQs

How many rounds are there in Exponentia.ai Associate Data Engineer interview?
Exponentia.ai interview process usually has 5 rounds. The most common rounds in the Exponentia.ai interview process are Technical, Resume Shortlist and Aptitude Test.
What are the top questions asked in Exponentia.ai Associate Data Engineer interview?

Some of the top questions asked at the Exponentia.ai Associate Data Engineer interview -

  1. SQL queries and pyt...read more
  2. SQL queries and python co...read more
  3. Soft skills and backgro...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
Tredence Interview Questions
3.6
 • 123 Interviews
MathCo Interview Questions
2.9
 • 110 Interviews
Zeta Interview Questions
3.3
 • 69 Interviews
embedUR Systems Interview Questions
3.3
 • 48 Interviews
Subex Interview Questions
3.5
 • 35 Interviews
View all
Data Engineer
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Intelligence Engineer
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Exponentia.ai with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

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