Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.
Partitioning is the process of dividing a large dataset into smaller, more manageable parts based on certain criteria.
Partitioning helps in improving query performance by reducing the amount of data that needs to be processed.
It can be done based on ranges, hash values, or specific columns in the dataset.
For example, partitioning a sales dataset by date can help in quickly retrieving sales data for a specific time peri
I have experience working with cloud warehouses such as Amazon Redshift and Google BigQuery.
Utilized Amazon Redshift to store and analyze large datasets for a retail company
Implemented ETL processes in Google BigQuery to transform and load data for a marketing campaign analysis
Optimized queries in Snowflake to improve performance for a financial services client
Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.
YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.
QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.
Thes...
Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.
Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.
Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.
Import is suitable for smaller datasets, while direct query is better for large da
Tableau offers various types of filters including quick filters, context filters, and data source filters.
Quick filters allow users to easily filter data by selecting values from a list.
Context filters are applied before other filters, affecting the data visible to subsequent filters.
Data source filters limit the data available to Tableau by filtering data at the data source level.
Other types of filters include extract...
There are two types of refresh in Tableau: Extract Refresh and Data Source Refresh.
Extract Refresh: Refreshes the data in Tableau extract, which is a snapshot of data from the original data source.
Data Source Refresh: Refreshes the data directly from the original data source.
Examples: Extract Refresh is useful when working with large datasets to improve performance, while Data Source Refresh ensures real-time data upda
Extract connection imports data into Tableau workbook while live connection directly connects to data source.
Extract connection creates a static snapshot of data in Tableau workbook.
Live connection directly queries data from the source in real-time.
Extract connection is useful for large datasets or when offline access is needed.
Live connection is beneficial for real-time data analysis and dynamic updates.
Example: Extra...
I applied via Campus Placement and was interviewed in Sep 2022. There were 3 interview rounds.
Easy but time limit was the main issue to address
Hard coding test on hacker earth platform no cameras and plagiarism tester will be on
I appeared for an interview before Mar 2024, where I was asked the following questions.
posted on 4 Feb 2017
I appeared for an interview before Feb 2016.
The Indian deodorant market is a growing industry with a large consumer base and increasing demand for premium and natural products.
The deodorant market in India has been experiencing steady growth over the years.
The market is driven by factors such as increasing disposable income, urbanization, and changing lifestyles.
There is a growing awareness among consumers about personal hygiene and grooming, leading to higher d...
Approximately 50,000 tractors are sold in Haryana every year.
Consider the population of Haryana and the number of farmers in the state.
Look at the agricultural output of Haryana and the demand for tractors in the region.
Take into account the number of tractor dealerships in Haryana and their sales figures.
Research the sales figures of major tractor manufacturers in Haryana.
Assume a growth rate based on the previous yea...
I appeared for an interview in Sep 2016.
I appeared for an interview in Jan 2017.
I come from a close-knit family in Chhattisgarh. Raipur and Bhilai have beautiful attractions like Mahant Ghasidas Memorial Museum and Maitri Bagh. I enjoy participating in various co-curricular activities.
Close-knit family in Chhattisgarh
Attractions in Raipur and Bhilai like Mahant Ghasidas Memorial Museum and Maitri Bagh
Participation in co-curricular activities
The last ball will be red.
If the first two balls are of different colors, they will be replaced with a red ball.
If the first two balls are of the same color, they will be replaced with a blue ball.
The number of balls in the container does not affect the outcome.
The last ball will be red because there are more red balls than blue balls in the container.
The exact number of Facebook users worldwide is constantly changing, but as of October 2021, there are over 2.8 billion monthly active users.
As of October 2021, Facebook reported having over 2.8 billion monthly active users.
The number of Facebook users is constantly changing as new users join and others deactivate or delete their accounts.
Facebook's user base is spread across different countries and demographics.
The nu...
VLOOKUP is a function in Excel used to search for a value in the first column of a range and return a corresponding value from another column.
VLOOKUP stands for vertical lookup.
It is commonly used to find specific data in large datasets.
The function takes four arguments: lookup value, table array, column index number, and range lookup.
VLOOKUP is case-insensitive and requires an exact match or an approximate match.
The f...
I appeared for an interview in Jan 2017.
I appeared for an interview in Jan 2017.
Output and error checking of SQL queries involves verifying the correctness of query results and handling any potential errors.
Verify the correctness of query results by comparing them with expected output
Check for syntax errors and correct them before executing the query
Handle runtime errors by using try-catch blocks or error handling mechanisms
Validate input parameters to prevent SQL injection attacks
Use appropriate ...
Estimating the percentage of smokers in an institute.
Collect data on the number of smokers and the total population in the institute.
Calculate the ratio of smokers to the total population.
Multiply the ratio by 100 to get the percentage of smokers.
Consider conducting surveys or analyzing existing data to gather information.
Take into account any potential biases or limitations in the data collection process.
based on 1 interview
Interview experience
Specialist
161
salaries
| ₹2 L/yr - ₹4.5 L/yr |
Verification Specialist
61
salaries
| ₹2.6 L/yr - ₹5 L/yr |
Senior Verification Specialist
21
salaries
| ₹3 L/yr - ₹4 L/yr |
Senior Associate
21
salaries
| ₹2 L/yr - ₹3.5 L/yr |
Background Verification Specialist
19
salaries
| ₹2.8 L/yr - ₹3.9 L/yr |
GeBBS Healthcare Solutions
UnitedHealth
Sahrudaya Healthcare (Medicover Hospitals)
Paras Hospital