Filter interviews by
I applied via Campus Placement and was interviewed in Apr 2024. There were 3 interview rounds.
Mix of coding 2 Dsa program , 15 Dsa mcq
Top trending discussions
I applied via LinkedIn and was interviewed in Oct 2024. There were 6 interview rounds.
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
WHERE is used with SELECT statement to filter rows based on a condition
HAVING is used with GROUP BY statement to filter groups based on a condition
WHERE is applied before grouping, HAVING is applied after grouping
Example: SELECT * FROM table WHERE column = 'value'
Example: SELECT column, COUNT(*) FROM table GROUP BY column HAVIN
Retail data case study
Case study discussion
Metrics used in retail business include sales, customer acquisition cost, customer lifetime value, inventory turnover, and gross margin.
Sales: Total revenue generated from products or services sold
Customer acquisition cost: Cost incurred to acquire a new customer
Customer lifetime value: Predicted revenue a customer will generate over their lifetime
Inventory turnover: Number of times inventory is sold and replaced in a ...
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Build a pipeline to connect http source and bring data in adls
Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source
Transform the data as needed using tools like Apache Spark or Azure Databricks
Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis
Dimension tables store descriptive attributes while fact tables store quantitative data.
Dimension tables contain attributes that describe the business entities, such as customer, product, or time.
Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.
Dimension tables are denormalized and have a one-to-many relationship with fact tables.
Fact table...
Use a self join to find employees with 2 managers in SQL query.
Use a self join on the employee table to join the table with itself.
Count the number of distinct managers for each employee.
Filter the results to only include employees with 2 managers.
I applied via Job Portal and was interviewed in Mar 2024. There was 1 interview round.
I am fascinated by the ability of analytics to uncover insights and drive informed decision-making.
I enjoy the challenge of working with large datasets and finding patterns within them
I am passionate about using data to solve complex problems and improve processes
I find it rewarding to see the impact of data-driven decisions on business outcomes
I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.
Python and sql based questions
I applied via Job Portal
A/B Testing, data structures
I applied via Naukri.com and was interviewed in Nov 2023. There were 2 interview rounds.
based on 1 interview
Interview experience
Software Engineer
1k
salaries
| ₹7.5 L/yr - ₹27 L/yr |
Senior Software Engineer
964
salaries
| ₹11.4 L/yr - ₹40 L/yr |
Senior Analyst
238
salaries
| ₹7 L/yr - ₹25 L/yr |
Analyst
221
salaries
| ₹4.2 L/yr - ₹17.9 L/yr |
Lead Software Engineer
162
salaries
| ₹18 L/yr - ₹60 L/yr |
Home Depot
Ace Hardware
Menards
Sherwin Williams Paints