i
Vyapar
Filter interviews by
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
Basic Hacker Rank SQL Questions 2 . and 10 MCQ based
The query selects all columns and calculates the total amount for each customer in table t2.
The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.
The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.
The 'select *' statement selects all columns from the table along with the calculated total amount.
The 'sum(amt) over (partiti...
To find customers who purchased the same item multiple times on the same day.
Identify unique customers who purchased the same item multiple times on the same day
Check for duplicate transactions by customer and item on the same day
Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
6 mcqs and 2 sql questions
In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.
HAVING is used with GROUP BY to filter groups based on aggregate functions
WHERE is used to filter rows before grouping
HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;
Example: S
I applied via Instahyre and was interviewed in Jul 2024. There were 3 interview rounds.
HackerEarth based assessment.
1. 8 qs were stats & prob based multiples choices
2. 2 were medium level sql questions.
I applied via Referral and was interviewed in Oct 2024. There were 2 interview rounds.
Mathematical questions was given for aptitude test which is basic if you know formulas pretty well u can easily score
Vyapar interview questions for popular designations
To productinize Data Pipelines, one must automate, monitor, and scale the pipeline for efficient and reliable data processing.
Automate the data pipeline using tools like Apache Airflow or Kubernetes
Monitor the pipeline for errors, latency, and data quality issues using monitoring tools like Prometheus or Grafana
Scale the pipeline by optimizing code, using distributed computing frameworks like Spark, and leveraging clou...
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data.
BigQuery uses a distributed architecture to process and analyze large datasets quickly.
It allows users to run SQL-like queries on datasets stored in Google Cloud Storage.
BigQuery automatically scales to handle large amounts of data and can be integrated with other Google Cloud services.
It supports real-time data...
Get interview-ready with Top Vyapar Interview Questions
I applied via Walk-in and was interviewed in May 2024. There were 2 interview rounds.
In aptitude test there are 10 questions from percentage profit loss and reasoning direction test etc.
GST stands for Goods and Services Tax, a value-added tax levied on most goods and services sold for domestic consumption.
GST is a consumption tax that is imposed on the supply of goods and services.
There are different types of GST, such as CGST (Central Goods and Services Tax), SGST (State Goods and Services Tax), and IGST (Integrated Goods and Services Tax).
CGST is collected by the central government, SGST by the stat...
I would highlight the benefits of using a duster for cleaning and dusting tasks.
Explain how a duster can easily remove dust and dirt from surfaces
Mention the convenience of using a duster for hard-to-reach areas
Highlight the effectiveness of a duster in reducing allergens and improving air quality
Accounting is the process of recording, summarizing, and analyzing financial transactions of a business. A balance sheet is a financial statement that shows a company's assets, liabilities, and equity at a specific point in time.
Accounting involves recording financial transactions, summarizing them in financial statements, and analyzing the results.
A balance sheet is a financial statement that shows a company's assets ...
Medium to hard questions based on arrays, dp
Quick sort is a popular sorting algorithm that uses divide and conquer strategy.
Divides array into smaller sub-arrays based on a pivot element
Recursively sorts sub-arrays
Combines sorted sub-arrays to get final sorted array
Time complexity: O(n log n) on average, O(n^2) worst case
Example: [3, 6, 8, 10, 1, 2, 1] -> [1, 1, 2, 3, 6, 8, 10]
Rotate a matrix by 90 degrees in place
Transpose the matrix
Reverse each row of the transposed matrix
I applied via Apna Jobs and was interviewed in Nov 2024. There was 1 interview round.
Basic percentage, profit and loss question
I applied via Walk-in and was interviewed in May 2024. There were 2 interview rounds.
In aptitude test there was question from percentage and profit loss
Sql ans logical reasoning assignment
I am a data analytics analyst with a strong background in statistics and programming.
Experienced in data cleaning, analysis, and visualization
Proficient in programming languages such as Python and R
Skilled in using tools like SQL, Tableau, and Excel
Strong understanding of statistical methods and machine learning algorithms
Top trending discussions
Interview experience
based on 338 reviews
Rating in categories
Business Development Executive
134
salaries
| ₹2.8 L/yr - ₹5.4 L/yr |
Inside Sales Executive
78
salaries
| ₹2.2 L/yr - ₹4.5 L/yr |
Accounts Manager
77
salaries
| ₹2.8 L/yr - ₹6 L/yr |
Team Lead
71
salaries
| ₹3.7 L/yr - ₹8.4 L/yr |
Customer Support Executive
64
salaries
| ₹2.8 L/yr - ₹4.2 L/yr |
Zoho
Tally Solutions
MARG ERP
Busy Infotech