Upload Button Icon Add office photos
Engaged Employer

i

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

Merilytics Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Merilytics Data Engineer 1 Interview Questions and Answers

Updated 16 Jun 2024

Merilytics Data Engineer 1 Interview Experiences

1 interview found

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

Aptitude test contains of programming language and aptitude questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell us about yourself
  • Q2. Which is your favourite programming language
  • Ans. 

    My favorite programming language is Python because of its readability, versatility, and extensive libraries.

    • Python is known for its readability, making it easier to write and maintain code.

    • Python is versatile and can be used for web development, data analysis, machine learning, and more.

    • Python has a vast collection of libraries like NumPy, Pandas, and Matplotlib that make data manipulation and visualization easier.

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. What are SQL commands
  • Ans. 

    SQL commands are instructions used to interact with databases to perform tasks such as querying, updating, and managing data.

    • SQL commands are used to perform various operations on databases, such as SELECT, INSERT, UPDATE, DELETE.

    • Examples of SQL commands include SELECT * FROM table_name, INSERT INTO table_name (column1, column2) VALUES (value1, value2), UPDATE table_name SET column1 = value1 WHERE condition, DELETE FRO...

  • Answered by AI
  • Q2. Difference between left and right join
  • Ans. 

    Left join returns all records from the left table and the matched records from the right table, while right join returns all records from the right table and the matched records from the left table.

    • Left join keeps all records from the left table, even if there are no matches in the right table.

    • Right join keeps all records from the right table, even if there are no matches in the left table.

    • Example: If we have a table o...

  • Answered by AI

Skills evaluated in this interview

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 

(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
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. NLP based question
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Basic SQL questions and Window fuctions
Round 3 - HR 

(1 Question)

  • Q1. HR asked how was the interview last round and gave me feedback

Interview Preparation Tips

Interview preparation tips for other job seekers - Answered almost all questions but still the interviewer gave feedback as, cannot write pyspark code. Although there was only one pyspark coding question and I did it.
In fact interviewer turned camera off several times between and missed responding for a few seconds.
He even didn't tell me to share screen to see what I code.

Totally not serious about the interview..
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jan 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

Aptitude test has 70 questions to be done in 75 minutes. It's moderately tough but not very tough with right amount of preparation

Round 2 - Coding Test 

I was from non-cs background so coding round was not mandatory but for cs people it was mandatory to clear it. It has SQL and python and they were easy to moderate. I am a fresher (imagineer) so we had to go this interview process

Round 3 - Technical 

(1 Question)

  • Q1. The interviewer was really nice and that went so smooth for me. 1. Asked questions from IC Engines and stuff 😄, as I was from mechanical 2.In coding, Sorting and Oops concepts were asked 3. Guessimates ...
Round 4 - HR 

(1 Question)

  • Q1. Typical HR questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Coding Test 

1 hour, 2 coding and 20 MCQs

Round 2 - Technical 

(1 Question)

  • Q1. 1 hour deep discussion on data engineering
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion, company policies etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Read SQL, PySpark, Performance Optimization, and Python.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. Sql questions and python
Round 2 - Behavioral 

(1 Question)

  • Q1. About last projects
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Aug 2023. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL query on joins, window function, remove duplicates, 2nd highest rank
  • Q2. Azure Data Factory, ETL questions
Round 2 - Technical 

(2 Questions)

  • Q1. SQL, python technical questions
  • Q2. Managerial questions
Round 3 - HR 

(2 Questions)

  • Q1. Strength and weakness
  • Q2. Typical hr questions
Round 4 - Aptitude Test 

Quantitative Analysis, Data Interpretation, Logical Reasoning

Contribute & help others!
anonymous
You can choose to be anonymous

Merilytics Interview FAQs

How many rounds are there in Merilytics Data Engineer 1 interview?
Merilytics interview process usually has 3 rounds. The most common rounds in the Merilytics interview process are One-on-one Round and Aptitude Test.
What are the top questions asked in Merilytics Data Engineer 1 interview?

Some of the top questions asked at the Merilytics Data Engineer 1 interview -

  1. Which is your favourite programming langu...read more
  2. Difference between left and right j...read more
  3. What are SQL comma...read more

Recently Viewed

LIST OF COMPANIES

Merilytics

Locations

INTERVIEWS

Pine Labs

No Interviews

INTERVIEWS

Saviynt

No Interviews

DESIGNATION

INTERVIEWS

Ascentt

No Interviews

INTERVIEWS

Pine Labs

No Interviews

SALARIES

Merilytics

INTERVIEWS

Merilytics

20 top interview questions

INTERVIEWS

Pine Labs

No Interviews

INTERVIEWS

Saviynt

No Interviews

Tell us how to improve this page.

Merilytics Data Engineer 1 Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 221 Interviews
Fractal Analytics Interview Questions
4.0
 • 208 Interviews
Axtria Interview Questions
3.1
 • 116 Interviews
Sigmoid Interview Questions
3.3
 • 59 Interviews
ICRA Analytics Interview Questions
3.4
 • 38 Interviews
Dunnhumby Interview Questions
4.0
 • 29 Interviews
Everest Group Interview Questions
3.3
 • 25 Interviews
View all
Merilytics Data Engineer 1 Salary
based on 4 salaries
₹6.5 L/yr - ₹13 L/yr
At par with the average Data Engineer 1 Salary in India
View more details
Senior Business Analyst
164 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Associate
130 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
89 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Technical Associate
76 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
67 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Merilytics 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