Filter interviews by
I applied via Campus Placement and was interviewed in Jul 2022. There were 5 interview rounds.
There were 48 questions to be done in 60 minutes.
the platform used was below average.
about 1400 gave the test
The Next round was a GD.
about 250 were shortlisted.
it was held in groups of 10 - 13.
there were 2 Panelists observing the body language, the fluency and time you speak for.
It is very important that you either start or conclude the GD.
leaves a good impression.
Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information.
It involves collecting and organizing data
It includes statistical analysis and visualization
It helps in making informed decisions
Examples include market research, financial analysis, and scientific research
SQL Queries using Joins and sub-queries
Joins are used to combine rows from different tables based on a related column
Sub-queries are queries nested within another query
Joins and sub-queries can be used together to retrieve specific data from multiple tables
I applied via Campus Placement
Gamification round Game gamification
Data analytics related topic
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
What people are saying about LatentView Analytics
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
LatentView Analytics interview questions for popular designations
Get interview-ready with Top LatentView Analytics Interview Questions
I applied via Campus Placement
Normal Aptitude Test
Python or SQL coding round
Query to retrieve the third transaction of every user
Use a subquery to rank the transactions for each user
Filter the results to only include the third transaction for each user
Query to output the name of credit card and number of cards issued in launch month
Use GROUP BY to group by launch month
Count the number of cards issued in each launch month
Select the name of the credit card and the count of cards issued
4 SQL questions, complexity 7/10
Aptitude test was easy, you can prepare it with online available resources
We were asked to complete few games which were related to logical thinking
It was a common topic and was 1 hour long
Some of the top questions asked at the LatentView Analytics interview -
The duration of LatentView Analytics interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 52 interviews
Interview experience
based on 231 reviews
Rating in categories
Senior Analyst
333
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
299
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
240
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
239
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Engineer
121
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
Bridgei2i Analytics Solutions