Filter interviews by
I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.
Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.
Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.
Aggregate functions can also be used with WHERE clause to filter rows before grouping.
WHERE clause filters rows before grouping, while HAVING clause filters groups aft...
The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM: Specifies the tables involved in the query
WHERE: Filters the rows based on specified conditions
GROUP BY: Groups the rows that have the same values into summary rows
HAVING: Filters the groups based on specified conditions
SELECT: Selects the columns to be displayed in the result set
ORDER BY: Sorts the result set based on speci
User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.
User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.
Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.
Triggers are special types of stored procedures that are auto...
Top trending discussions
I applied via Naukri.com and was interviewed before Dec 2023. There were 2 interview rounds.
As a Data Analyst, my roles and responsibilities include analyzing data, creating reports, identifying trends, and providing insights to support decision-making.
Analyzing large datasets to extract meaningful insights
Creating reports and visualizations to communicate findings
Identifying trends and patterns in data
Collaborating with stakeholders to understand business needs
Providing recommendations based on data analysis
...
In the next 4 years, I see myself advancing my skills in data analysis, taking on more responsibilities, and potentially moving into a leadership role.
Continuing to improve my data analysis skills through training and hands-on experience
Taking on more complex projects and responsibilities within the data analysis field
Possibly transitioning into a leadership role where I can mentor and guide junior analysts
Exploring op...
I am a data analyst with a background in statistics and programming, passionate about uncovering insights from data.
Background in statistics and programming
Experience in data analysis and visualization tools like Python, R, and Tableau
Strong problem-solving skills
Ability to communicate complex data findings to non-technical stakeholders
I have 5 years of experience working as a Data Analyst in various industries.
5 years of experience as a Data Analyst
Worked in multiple industries such as finance, healthcare, and technology
Proficient in data analysis tools and techniques
Experience in handling large datasets and generating insights
Strong problem-solving and communication skills
I applied via Referral and was interviewed before Mar 2023. There were 3 interview rounds.
Excel test with basic aptitude questions
I will streamline the process by identifying bottlenecks and implementing automation.
Analyze current process flow
Identify areas of delay or inefficiency
Implement automation tools to reduce manual effort
Set up clear communication channels between team members
Track progress and adjust as needed
Hypothesis testing in ticket closing example
Define null and alternative hypothesis
Choose appropriate statistical test
Set significance level
Collect data and calculate test statistic
Determine p-value and compare with significance level
Make conclusion and interpret results
I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.
Statistics is the study of collecting, analyzing, and interpreting data.
Descriptive statistics summarize and describe data
Inferential statistics make predictions and draw conclusions about a population based on a sample
Hypothesis testing is used to determine if there is a significant difference between groups
Regression analysis is used to model the relationship between variables
Probability theory is used to quantify un...
Adam optimizer is an extension to the Gradient Descent optimizer with adaptive learning rates and momentum.
Adam optimizer combines the benefits of both AdaGrad and RMSProp optimizers.
Adam optimizer uses adaptive learning rates for each parameter.
Gradient Descent optimizer has a fixed learning rate for all parameters.
Adam optimizer includes momentum to speed up convergence.
Gradient Descent optimizer updates parameters b...
Use ReLU for hidden layers in deep neural networks, avoid for output layers.
ReLU is commonly used in hidden layers to introduce non-linearity and speed up convergence.
Avoid using ReLU in output layers for regression tasks as it can lead to vanishing gradients.
Consider using Leaky ReLU or Sigmoid for output layers depending on the task.
ReLU is computationally efficient and helps in preventing the vanishing gradient prob...
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
I applied via Referral and was interviewed before May 2023. There were 4 interview rounds.
180 mins of online test with camera ON. Major topics include Excel, Aptitude, Python, Statistics and Case Study
Apriori method is a popular algorithm for frequent itemset mining in data mining.
Used for finding frequent itemsets in transactional databases
Based on the concept of association rule mining
Involves generating candidate itemsets and pruning based on support threshold
Example: If {milk, bread} is a frequent itemset, then {milk} and {bread} are also frequent
Train-test split is a method used to divide a dataset into training and testing sets for model evaluation in Scikit learn.
Split the dataset into two subsets: training set and testing set
Training set is used to train the model, while testing set is used to evaluate the model's performance
Common split ratios are 70-30 or 80-20 for training and testing sets
Example: X_train, X_test, y_train, y_test = train_test_split(X, y,
I applied via Naukri.com and was interviewed before Dec 2023. There were 2 interview rounds.
As a Data Analyst, my roles and responsibilities include analyzing data, creating reports, identifying trends, and providing insights to support decision-making.
Analyzing large datasets to extract meaningful insights
Creating reports and visualizations to communicate findings
Identifying trends and patterns in data
Collaborating with stakeholders to understand business needs
Providing recommendations based on data analysis
...
In the next 4 years, I see myself advancing my skills in data analysis, taking on more responsibilities, and potentially moving into a leadership role.
Continuing to improve my data analysis skills through training and hands-on experience
Taking on more complex projects and responsibilities within the data analysis field
Possibly transitioning into a leadership role where I can mentor and guide junior analysts
Exploring op...
I am a data analyst with a background in statistics and programming, passionate about uncovering insights from data.
Background in statistics and programming
Experience in data analysis and visualization tools like Python, R, and Tableau
Strong problem-solving skills
Ability to communicate complex data findings to non-technical stakeholders
I have 5 years of experience working as a Data Analyst in various industries.
5 years of experience as a Data Analyst
Worked in multiple industries such as finance, healthcare, and technology
Proficient in data analysis tools and techniques
Experience in handling large datasets and generating insights
Strong problem-solving and communication skills
I applied via Referral and was interviewed before Mar 2023. There were 3 interview rounds.
Excel test with basic aptitude questions
based on 3 reviews
Rating in categories
Software Development Engineer
229
salaries
| ₹10 L/yr - ₹36 L/yr |
Technical Support Engineer
146
salaries
| ₹6.4 L/yr - ₹23 L/yr |
Software Engineer
126
salaries
| ₹8.5 L/yr - ₹25.2 L/yr |
Senior Software Engineer
72
salaries
| ₹11.1 L/yr - ₹38 L/yr |
Software Developer
51
salaries
| ₹8.6 L/yr - ₹31 L/yr |
NortonLifeLock's
Trend Micro
Kaspersky Lab
Sophos Technologies