Filter interviews by
Create a function to generate a transaction bin column based on transaction amounts.
Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)
Use pandas cut() function in Python to create bins
Assign bin labels to the transactions based on the bin ranges
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
Experienced in using statistical analysis tools such as Python, R, and SQL
Proficient in data visualization tools like Tableau and Power BI
Skilled in data cleaning, data mining, and data modeling techniques
Strong problem-solving and critical thinking skills
Effective communicator and team player
Example: I have w...
The biggest hurdle I faced during organizing the tech fest of my college was securing sponsorships.
Difficulty in convincing companies to sponsor the event
Limited budget for organizing a large-scale tech fest
Competition with other college events for sponsorships
Negotiating sponsorship deals and ensuring deliverables
Finding sponsors aligned with the theme and objectives of the tech fest
Yes, pursuing an MBA can enhance my skills and open up new career opportunities.
An MBA can provide a strong foundation in business and management principles.
It can help develop analytical and problem-solving skills.
An MBA can broaden my network and provide access to valuable connections.
It can open up leadership roles and higher-level positions in organizations.
Having an MBA can increase earning potential and job prosp...
Yes, Reliance Fresh should open a store in the north-eastern part of India.
The north-eastern part of India has a growing population and increasing consumer demand.
Reliance Fresh can tap into the untapped market potential in the region.
Opening a store in the north-eastern part of India can help Reliance Fresh expand its presence and increase its market share.
Reliance Fresh can leverage its existing supply chain and dist...
The number of people travelling by local metro in Mumbai is estimated to be in millions.
Mumbai has a population of over 20 million people.
The local metro is a popular mode of transportation in Mumbai.
During peak hours, the metro trains are usually crowded.
The metro network in Mumbai is extensive, covering various parts of the city.
The number of daily commuters on the metro can be estimated based on population density a
I applied via Campus Placement
I applied via Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2019. There were 3 interview rounds.
To choose optimum probability threshold from ROC, we need to balance between sensitivity and specificity.
Choose the threshold that maximizes the sum of sensitivity and specificity
Use Youden's J statistic to find the optimal threshold
Consider the cost of false positives and false negatives
Use cross-validation to evaluate the performance of different thresholds
To test time series trend break up, statistical tests like Augmented Dickey-Fuller test can be used.
Augmented Dickey-Fuller test can be used to check if a time series is stationary or not.
If the time series is not stationary, we can use differencing to make it stationary.
After differencing, we can again perform the Augmented Dickey-Fuller test to check for stationarity.
If there is a significant change in the mean or va...
Communicate transparently and offer alternative solutions.
Explain the limitations of the available data and the potential risks of making decisions based on incomplete information.
Offer alternative solutions that can be implemented with the available data.
Collaborate with the customer to identify additional data sources or explore other options to gather more data.
Provide regular updates on the progress of data collect...
I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 2 interview rounds.
Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.
Window functions are used to calculate running totals, moving averages, and rank values.
They are applied to a set of rows defined by an OVER clause.
Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
CTE stands for Common Table Expression, a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
CTE is defined using the WITH keyword followed by a name and a SELECT statement.
It can be used to simplify complex queries, improve readability, and reduce code duplication.
CTE can also be recursive, allowing for hierarchical queries.
Example: WITH sales AS (SELECT * FROM order...
I appeared for an interview in Sep 2024.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets using SQL, Python, and R
Skilled in creating insightful reports and dashboards using Tableau and Power BI
Strong communication skills to present findings to stakeholders
Certified in data analysis and machine learning techniques
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
Strength: Strong analytical skills
Strength: Attention to detail
Weakness: Getting caught up in details (provide example)
Project explanation
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Aptitude questions asked about basic stuff
To delete duplicate values, use SQL queries with DISTINCT keyword or programming languages like Python with sets.
In SQL, use SELECT DISTINCT to retrieve unique values
In Python, convert list to set to automatically remove duplicates
Use pandas library in Python to drop duplicates in a DataFrame
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Software Engineer
647
salaries
| ₹14.5 L/yr - ₹44 L/yr |
Software Engineer
248
salaries
| ₹9.7 L/yr - ₹34.6 L/yr |
Staff Software Engineer
151
salaries
| ₹20 L/yr - ₹60 L/yr |
Senior Software Test Engineer
87
salaries
| ₹18 L/yr - ₹41.6 L/yr |
Senior Data Engineer
85
salaries
| ₹20 L/yr - ₹45 L/yr |
MasterCard
American Express
PayPal
State Bank of India