i
Merilytics
Filter interviews by
Aptitude test contains of programming language and aptitude questions
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.
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...
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...
Top trending discussions
I applied via Job Portal and was interviewed in Mar 2024. There were 3 interview rounds.
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
Implement a pipeline based on given conditions and data requirement
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.
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...
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.
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
posted on 6 Jan 2024
I applied via Campus Placement and was interviewed before Jan 2023. There were 4 interview rounds.
Aptitude test has 70 questions to be done in 75 minutes. It's moderately tough but not very tough with right amount of preparation
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
I applied via Job Fair and was interviewed before Feb 2023. There were 3 interview rounds.
1 hour, 2 coding and 20 MCQs
I applied via Naukri.com and was interviewed before Aug 2023. There were 4 interview rounds.
Quantitative Analysis, Data Interpretation, Logical Reasoning
based on 1 interview
Interview experience
Senior Business Analyst
164
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Associate
130
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
89
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Technical Associate
76
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
67
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics