Quant Systems India Big Data Engineer Interview Questions and Answers

Q1. Interview was taken in malad on interface 7 building The relationship officer Vaibhav Panchal . He assigned Interviewer the way he was talking he was not able to speak in english half of the question i was...read more
Add your answer
Q2. His english was poor How you will get the customer count who speak in english? he didn't gave me which table to fetch from ? * question changed get the customer from one table and count from the other ...read more
Add your answer

Q1. Types of Chunking in data preparation in RAG
Add your answer
Q2. How Embedding works in Vector Databases
Add your answer
Q3. Explain ARIMA model
Add your answer
Q4. How can we decide to choose Linear Regression for a business problem
Add your answer

Q1. What is token and it's limit for Open Source LLMs
Add your answer
Q2. Difference of a Regression and Time Series problem
Add your answer
Q3. Advantage of LSTM over RNN
Add your answer
Q4. Performance Metrics for Logistic Regression
Add your answer

Easy ques to answer basic

Easy ques to write. not tough ques

Q1. Easy ques to write.Not tough
Add your answer
Q2. Easy Ques to write not tough
Add your answer

Q1. Great to work here in Bajaj
Add your answer
Q2. 15min interview and basic of SQL
Add your answer

Q1. Get the maximum salary of the employee from the employee and department table
Add your answer
Q2. Explain the data analysis process that you would follow for employee salary table
Ans. 
The data analysis process for an employee salary table involves data cleaning, exploration, visualization, and modeling.
• Start by cleaning the data to remove any duplicates, missing values, or outliers.

• Explore the data by calculating basic statistics like mean, median, and standard deviation.

• Visualize the data using histograms, box plots, or scatter plots to identify patterns or trends.

• Perform statistical modeling to an...read more
Answered by AI
Add your answer
Q3. Explain the challenges you faced in your project
Ans. 
I faced challenges in managing large datasets and ensuring data accuracy in my project.
• Managing large volumes of data from multiple sources

• Ensuring data accuracy and consistency

• Dealing with missing or incomplete data

• Handling data cleaning and preprocessing tasks

• Addressing technical issues with data storage or processing tools
Answered by AI
Add your answer

It was moderate and also easy to crack

Q1. Write a SQL queries
Ans. 
SQL queries to retrieve data from a database
• Use SELECT statement to retrieve data from tables

• Use WHERE clause to filter results based on specific conditions

• Use JOIN clause to combine data from multiple tables
Answered by AI
Add your answer
Q2. Use case when while writing a query
Ans. 
Using a case statement in a query to handle different conditions
• Use CASE statement to handle different conditions in a query

• CASE can be used for conditional logic within SELECT, WHERE, ORDER BY clauses

• Example: SELECT column1, CASE WHEN condition1 THEN 'Result1' ELSE 'Result2' END AS new_column FROM table_name
Answered by AI
Add your answer

Q1. Different joins
Add your answer
Q2. Case study
Add your answer

Revenue impact for casino

English, quant, logical reasoning

Q1. Wacc, coc, beta
Add your answer
Q2. Coc, equity, capm
Add your answer

Q1. What is p value?
Ans. 
A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.
• A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

• A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.

• A p-value less than the significance level indicates st
Answered by AI
Add your answer
Q2. Tell the output a**2
Ans. 
The output of a**2 is the square of the value of a.
• The output is the value of a multiplied by itself

• For example, if a = 3, then the output would be 9 (3*3)
Answered by AI
Add your answer
Q3. Difference between append() and concat
Ans. 
append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.
• append() is a method used to add rows to a DataFrame.

• concat() is a function used to combine multiple DataFrames along a particular axis.

• append() modifies the original DataFrame, while concat() returns a new DataFrame.

• Example: df1.append(df2) vs pd.concat([df1, df2])
Answered by AI
Add your answer