i
Exponentia.ai
Filter interviews by
Clear (1)
Medium to difficult level Questions
Top trending discussions
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
I applied via Naukri.com and was interviewed before Sep 2023. There were 2 interview rounds.
They give you SQL assignment to complete based on that select for technical interview
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a set of rows related to the current row.
They allow you to perform calculations without grouping the rows into a single output row.
Examples of window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Group by is used to group rows that have the same values into summary rows, while distinct is used to remove duplicate rows from a result set.
Group by is used with aggregate functions like COUNT, SUM, AVG, etc.
Distinct is used to retrieve unique values from a column or set of columns.
Group by is used to perform operations on groups of rows, while distinct is used to filter out duplicate rows.
Group by is used in conjunc...
Data Engineer
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
31
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Scientist
22
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Intelligence Engineer
21
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
21
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics