Filter interviews by
Be the first one to contribute and help others!
I have worked with Java, Python, and SQL.
Proficient in Java for developing enterprise applications
Experience in Python for data analysis and automation
Skilled in SQL for database management and querying
I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.
Financial data for baking companies and other industries
Financial statements like income statement, balance sheet, and cash flow statement are key for analyzing baking companies and other industries
Key financial ratios like profitability ratios, liquidity ratios, and solvency ratios can provide insights into the financial health of these companies
Comparing financial data of baking companies with industry benchmarks can...
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
Sql test like joins and etc
I applied via Campus Placement and was interviewed before Oct 2022. There were 3 interview rounds.
I appeared for an interview in Mar 2021.
Steps involved in analyzing decrease in sales for a particular area
Identify the time period for which sales have decreased
Analyze the sales data for the area and compare it with previous periods
Identify any external factors that may have contributed to the decrease in sales
Conduct customer surveys to identify any issues with products or services
Analyze competitor activity in the area
Develop a plan to address the issues...
SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.
Use AVG function to calculate mean waiting period
Subtract ordered time from delivered time to get waiting period
Filter data by driver ID and delivery partner
Group by delivery partner
Rolling sum query adds up a specified number of rows in a table based on a given condition.
Use the OVER() function to specify the window frame for the rolling sum.
Specify the number of rows to include in the window frame using ROWS BETWEEN.
Use ORDER BY to specify the order of rows in the window frame.
Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FR
I appeared for an interview in Nov 2021.
Round duration - 60 minutes
Round difficulty - Easy
Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.
Query to calculate rolling sum
Use window functions like SUM() OVER() in SQL
Specify the window frame to define the range for the rolling sum
Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Prepare well for SQL, you have to be strong in SQL.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
The amount of work experience is an important factor in determining the suitability of a candidate for the Business Analyst role.
Work experience helps in developing a deep understanding of business processes and industry trends.
It allows the candidate to gain practical knowledge and skills in data analysis, problem-solving, and project management.
Having relevant work experience demonstrates the ability to work effectiv...
I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.
Types of SQL joins and their minimum and maximum possible rows.
Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross
Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows
Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows
1.Features you would look for if you have to buy an elevator
2. How do you estimate the number of trains passing through a station
Business Analyst
4
salaries
| ₹15 L/yr - ₹24.6 L/yr |
Assistant Manager
4
salaries
| ₹7.9 L/yr - ₹12.5 L/yr |
Java Developer
4
salaries
| ₹9.6 L/yr - ₹24 L/yr |
Deputy Manager
4
salaries
| ₹13.8 L/yr - ₹34 L/yr |
Manager
3
salaries
| ₹22 L/yr - ₹26 L/yr |
L&T Construction
Udaan
Home Credit Finance
Swiggy