AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Merilytics
Compare
Filter interviews by
Merilytics Data Engineer 1 Interview Questions and Answers
Merilytics Data Engineer 1 Interview Experiences
1 interview found
Anonymous
Aptitude test contains of programming language and aptitude questions
(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.
(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...
- 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...
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via campus placement at Indian Institute of Technology (IIT), Bhuvaneshwar and was interviewed in Nov 2024. There were 3 interview rounds.
2 coding problem 1)NSE
This is again a coding round 1) boundary traversal of binary tree and 2)Rotten Oranges
(2 Questions)
- Q1. About project which I have done
- Q2. 2 DSA problem of linked list
Interview Preparation Tips
(2 Questions)
- Q1. What is RDD and how its different from DF and Datasets
- Ans.
RDD stands for Resilient Distributed Dataset and is the fundamental data structure of Apache Spark.
RDD is a distributed collection of objects that can be operated on in parallel.
DataFrames and Datasets are higher-level abstractions built on top of RDDs.
RDDs are more low-level and offer more control over data processing compared to DataFrames and Datasets.
- Q2. What is Partitioning and how to use colease and repartition
- Ans.
Partitioning is the process of dividing data into smaller chunks for better organization and processing in distributed systems.
Partitioning helps in distributing data across multiple nodes for parallel processing.
Coalesce is used to reduce the number of partitions without shuffling data, while repartition is used to increase the number of partitions by shuffling data.
Example: coalesce(5) will merge partitions into 5 pa...
(2 Questions)
- Q1. What is Spark and explian its architecture
- Ans.
Spark is a distributed computing framework that provides an interface for programming entire clusters with implicit data parallelism and fault tolerance.
Spark has a master-slave architecture with a driver program that communicates with a cluster manager to distribute work across worker nodes.
It uses Resilient Distributed Datasets (RDDs) for fault-tolerant distributed data processing.
Spark supports various programming l...
- Q2. What is DAG? how a spark job works how the dag gets created
- Ans.
DAG stands for Directed Acyclic Graph. It is a finite directed graph with no cycles.
DAG is a collection of nodes connected by edges where each edge goes from one node to another, but no cycles are allowed.
In the context of Spark, a DAG represents the sequence of transformations that need to be applied to the input data to get the final output.
When a Spark job is submitted, Spark creates a DAG of the transformations spe...
Skills evaluated in this interview
Data Analyst Interview Questions & Answers
Institutional Shareholder Services
Priya Vishwakarma
posted on 13 Mar 2024
I applied via campus placement at Zagdu Singh Chartitable Trust's Thakur Institute of Management Studies & Research, Mumbai and was interviewed in Feb 2024. There were 3 interview rounds.
Aptitude test was divided into 3 parts and was not a typical quant, logical question it was more of an application based questions
(1 Question)
- Q1. What do you understand about the company?
(1 Question)
- Q1. Mostly behavioural and situation based questions.
I applied via Approached by Company and was interviewed in Oct 2023. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions based on resume
(1 Question)
- Q1. On skills mentioned in resume
(1 Question)
- Q1. Asked scenario based questions
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed in Dec 2022. There were 3 interview rounds.
Presence of mind, logical approach, problem solving attitude, flexibility
(2 Questions)
- Q1. Approach to solve the scenario.
- Q2. Awareness of the things.
Interview Preparation Tips
- intellegenc
Salman Haider
I was interviewed in Sep 2016.
Interview Preparation Tips
Experience: Written Test based on which students were shortlist
Duration: 4 hours
Total Questions: 60
Round: Group Discussion
Duration: 1 hour
College Name: Dr. KNMIET
I was interviewed in Jan 2025.
2 MCQs sections based on SQL and Power BI.
(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
(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.
(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
Selected
I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.
(1 Question)
- Q1. Sql, Python programming Questions
(1 Question)
- Q1. Retail, CPG based case study questions like offer allocation method for loyal customers
(2 Questions)
- Q1. Given a non-decreasing array, how can I determine the indices of an element X within it? If the element is not present, the output should be [-1, -1]. For example, for the array [1,2,3,3,5,5,7,8] and X=5, ...
- Q2. From the employee table, how can I return the employee_name, department, age, and salary of the employee who is older than 35 and has the highest salary within each department?
Merilytics Interview FAQs
Tell us how to improve this page.
Merilytics Interviews By Designations
- Merilytics Business Analyst Interview Questions
- Merilytics Business Associate Interview Questions
- Merilytics Senior Business Analyst Interview Questions
- Merilytics Data Engineer Interview Questions
- Merilytics Analyst Interview Questions
- Merilytics Senior Technical Associate Interview Questions
- Merilytics IT Analyst Interview Questions
- Merilytics Business Development Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Data Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Azure Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Show more
Merilytics Data Engineer 1 Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Business Analyst
164
salaries
|  ₹6.6 L/yr - ₹12 L/yr |
|
Business Associate
130
salaries
| ₹8.1 L/yr - ₹14.8 L/yr |
|
Business Analyst
89
salaries
| ₹5 L/yr - ₹10 L/yr |
|
Senior Technical Associate
76
salaries
| ₹5 L/yr - ₹10.4 L/yr |
|
Senior Analyst
67
salaries
| ₹3.6 L/yr - ₹14 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- Merilytics Interview Questions >
- Merilytics Data Engineer 1 Interview Questions
