i
Almonds Ai
Filter interviews by
I applied via campus placement at Great Lakes Institute of management, Chennai and was interviewed in Nov 2024. There were 3 interview rounds.
Use the MAX() function in SQL to find the highest salary.
Use the MAX() function along with the column name that contains the salaries.
Example: SELECT MAX(salary) FROM employees;
Ensure you have the necessary permissions to access the salary data.
Index match and match functions are used in Excel to lookup values in a table.
Index match is used to lookup a value in a table based on row and column criteria.
Match function is used to find the position of a value in a range.
Example: =INDEX(A1:D10, MATCH(lookup_value, A1:A10, 0), MATCH(lookup_value, A1:D1, 0))
Star and dimension schema are used in data warehousing to organize data, while window functions in SQL are used for analytical queries.
Star schema is a type of schema where a central fact table is connected to multiple dimension tables.
Dimension schema is a type of schema where each dimension is represented by a separate table.
Window functions in SQL are used to perform calculations across a set of table rows related t...
Top trending discussions
posted on 18 Sep 2024
I am a detail-oriented data analyst with a strong background in statistics and programming.
Graduated with a degree in Statistics
Proficient in programming languages such as Python and R
Experience in analyzing and interpreting data sets
Strong attention to detail and problem-solving skills
I have a strong analytical background, excellent problem-solving skills, and a passion for data-driven decision making.
I have a degree in Statistics and experience with data analysis tools such as Python and SQL.
I have successfully completed projects where I identified trends and patterns in data to drive business decisions.
I am a quick learner and have a strong attention to detail, ensuring accuracy in my analysis.
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
2 questions based on coding
Reverse a given string
Use built-in functions like reverse() or slice() in Python
Iterate through the string in reverse order and append each character to a new string
Convert the string to an array of characters, reverse the array, then join the characters back together
A linked list is a data structure in Java where each element points to the next element in the list.
Linked list nodes contain data and a reference to the next node
Insertion and deletion operations are efficient in linked lists
Traversal requires iterating through each node starting from the head
Example: Node class with data and next pointer, LinkedList class with methods to insert, delete, and traverse
posted on 1 Oct 2023
I applied via campus placement at Lokmanya Tilak College of Engineering, Navi Mumbai and was interviewed in Apr 2023. There were 3 interview rounds.
Questions related to web development and quantitative aptitude. It was one hour test. Based on the score of this test, the position is allotted to you for which you are eligible to give the interview.
Coding round didn't had compilers and I had to write the pseudo code for the given problems. Few DSA and SQL questions were there in this round.
I applied via Referral and was interviewed before Aug 2023. There was 1 interview round.
Overfitting occurs when a model learns the training data too well, leading to poor performance on new, unseen data.
Overfitting occurs when a model is too complex and captures noise in the training data.
It can be identified when a model performs well on training data but poorly on test data.
Techniques to prevent overfitting include cross-validation, regularization, and early stopping.
Example: A decision tree with too ma...
based on 4 reviews
Rating in categories
Accountant
5
salaries
| ₹3.8 L/yr - ₹3.8 L/yr |
Accounts Manager
4
salaries
| ₹3.8 L/yr - ₹7.7 L/yr |
Accounts & Finance Executive
4
salaries
| ₹3.8 L/yr - ₹3.8 L/yr |
Procurement Manager
4
salaries
| ₹6.4 L/yr - ₹6.6 L/yr |
Category Manager
4
salaries
| ₹4.4 L/yr - ₹8.5 L/yr |
Yalamanchili Software Exports
ScoreMe Solutions
Global Edge Software
Logelite