Filter interviews by
To find the second highest salary in a table, you can use a SQL query with the ORDER BY and LIMIT clauses.
Use a SQL query to select the salary column from the table
Order the results in descending order using ORDER BY
Use LIMIT 1,1 to retrieve the second highest salary
CTE (Common Table Expressions) are temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
CTEs are defined using the WITH keyword
CTEs can be used to simplify complex queries by breaking them into smaller, more manageable parts
CTEs can be recursive, allowing a query to reference itself
I applied via Approached by Company and was interviewed in Dec 2021. There were 4 interview rounds.
Two datasets were shared. Complete freedom was given to derive different insights.
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
SQL, excel, tableau , looker studio
I applied via Campus Placement and was interviewed in Apr 2024. There was 1 interview round.
Logistic regression is a linear model used for binary classification, while SVM is a non-linear model that can handle complex decision boundaries.
Logistic regression is a probabilistic model that predicts the probability of a binary outcome based on input features.
SVM aims to find the hyperplane that best separates the classes in a high-dimensional space.
Logistic regression is more interpretable and easier to implement...
I applied via Recruitment Consulltant and was interviewed in Dec 2022. There were 2 interview rounds.
MYSQL window functions allow for calculations across rows in a result set.
Window functions are used to perform calculations across rows in a result set
They are used with the OVER() clause
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
They can be used to calculate running totals, moving averages, and more
I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.
SQL based leetcode medium and hackerrank
Python take home EDA case study assessment
LLM stands for Language Model. Fine tuning involves adjusting hyperparameters and training on specific data.
LLM stands for Language Model, which is a type of AI model that predicts the next word in a sentence.
Fine tuning LLM involves adjusting hyperparameters such as learning rate, batch size, and number of training epochs.
Fine tuning also involves training the LLM on specific data related to the task at hand, such as ...
RAG stands for Red, Amber, Green and is a project management tool used to visually indicate the status of tasks or projects.
RAG is commonly used in project management to quickly communicate the status of tasks or projects.
Red typically indicates tasks or projects that are behind schedule or at risk, Amber indicates tasks that are on track but may need attention, and Green indicates tasks that are on schedule or complet...
I applied via Referral and was interviewed in Jun 2024. There were 3 interview rounds.
50 questions need to do in 15 mins.
I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.
Read about MPIN that is used to access mobile banking apps
Many a times users end up setting an MPIN that is guessable because
1. It is a commonly used MPIN eg 1122
2. It is a combination of easily known demographics of the user. Eg: if the birthdate is 02- Jan-1998 then MPIN could be 0201 or 9802 or 0201 etc. Demographics such as these could be used alone or in a combination
a. DOB
b. Wedding Anniversary
c. Spouse birthday
Solutions Required
1. Part A: Assume that the MPIN is 4-digits. Write a program that suggests if the MPIN is a commonly used one. Ignore the demographics for this part
2. Part B: Enhance the above to take user's demographics as input and provides an output
a. Strength: WEAK or STRONG
3. Part C: Enhance the above to provide the following outputs
a. Strength: WEAK or STRONG
b. If weak then the reason why was it considered weak: It should give from the following the reasons as an array. Array should be empty if Strength is STRONG and non-empty if WEAK
i. COMMONLY_USED
ii. DEMOGRAPHIC_DOB_SELF
iii. DEMOGRAPHIC_DOB_SPOUSE
iv. DEMOGRAPHIC_ANNIVERSARY
4. Part E: Above with a 6-digit PIN
5. Write code that tests the above written code using a set of inputs. Write at least 20 test case in PYTHON
I applied via Recruitment Consulltant and was interviewed in Dec 2021. There were 3 interview rounds.
15 mins aptitude test
Case study on the role
based on 1 interview
Interview experience
Key Account Manager
9
salaries
| ₹0 L/yr - ₹0 L/yr |
Product Manager
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Development Manager
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Customer Success Manager
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Product Designer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Dream11
Fantasy Akhada
MyTeam11
My11Circle