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

Merilytics Data Engineer Interview Questions and Answers

Updated 26 Nov 2024

Merilytics Data Engineer Interview Experiences

4 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 26 Nov 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement

Round 1 - Aptitude Test 

First round Aptitude + Technical questions on CS fundamentals

Round 2 - Technical 

(3 Questions)

  • Q1. Frog jump Dynamic programming question
  • Q2. Remove zeroes from a numbers only string and insert at last also maintain the relative order
  • Ans. 

    Remove zeroes from a numbers only string and insert at last while maintaining relative order.

    • Iterate through the string and separate numbers and zeroes

    • Store numbers in an array and zeroes in a separate array

    • Concatenate the numbers array with the zeroes array at the end

  • Answered by AI
  • Q3. One sql question on joins

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 27 Sep 2024

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

I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

15 mcqs aptitude for 15 min, then section closes, then 15 coding mcqs based on oops, java, python,dsa and very few about sql.

Round 2 - HR 

(1 Question)

  • Q1. Asked about what projects i did , and asked me to explain briefly about them , Asked if i would be given an offer , would it be final, or even then would you be applying for jobs for other companies. Aske...
Round 3 - Technical 

(1 Question)

  • Q1. Few questions about python , gave me a string "abc-def-ghi" and asked me to split it into substrings and return the substrings, asked about lists, tuples, dictionaries, differences and comparison between t...

Interview Preparation Tips

Interview preparation tips for other job seekers - do revise basics of sql, not just writing queries, but each and every keyword in sql, what does it do in theory, be thorough with all theoretical concepts like joins, ddl dml commands,
for writing complex queries, SQL 50 on leetcode would suffice, also learn window functions properly and their implementation in queries.

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more
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 Oct 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Normal maths 10 questions were there on syllabus till 10th
10 oops question in python and some other normal MCQ on Java can be solved without knowing java

Round 2 - One-on-one 

(1 Question)

  • Q1. General questions on resume SQL queries based on joins
Round 3 - One-on-one 

(1 Question)

  • Q1. General discussion on resume Medium level SQL questions little higher level than first round A puzzle to measure 4 l of milk from a 3 and 5 little container Some situation based questions like behavioural ...

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 22 Jul 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic aptitude questions

Round 2 - One-on-one 

(1 Question)

  • Q1. Sql schemas and asked about sql joins and relations and also about sql injections

Merilytics interview questions for designations

 Data Engineer 1

 (1)

 Data Engineer 2

 (1)

 Senior Data Analyst

 (1)

 IT Analyst

 (2)

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 

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

(2 Questions)

  • Q1. How to build data pipeline
  • Ans. 

    Building a data pipeline involves extracting, transforming, and loading data from various sources to a destination for analysis.

    • Identify data sources and determine the data to be collected

    • Extract data from sources using tools like Apache NiFi or Apache Kafka

    • Transform data using tools like Apache Spark or Python scripts

    • Load data into a destination such as a data warehouse or database

    • Schedule and automate the pipeline fo...

  • Answered by AI
  • Q2. IICS
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Tell me about yourself, second highest salary , question related to coleasce function

Merilytics Interview FAQs

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

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

  1. Remove zeroes from a numbers only string and insert at last also maintain the r...read more
  2. General discussion on resume Medium level SQL questions little higher level tha...read more
  3. General questions on resume SQL queries based on jo...read more

Tell us how to improve this page.

Merilytics Data Engineer Interview Process

based on 5 interviews

1 Interview rounds

  • Aptitude Test Round
View more
Merilytics Data Engineer Salary
based on 17 salaries
₹5 L/yr - ₹10.4 L/yr
28% less than the average Data Engineer Salary in India
View more details

Merilytics Data Engineer Reviews and Ratings

based on 2 reviews

1.0/5

Rating in categories

1.9

Skill development

1.0

Work-life balance

2.4

Salary

3.7

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 2 Reviews and Ratings
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