i
OLX
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
Rank does not skip ranks when there are ties, while Dense Rank does
Rank will have gaps in ranks if there are ties, while Dense Rank will not
Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
I applied via Naukri.com and was interviewed in Sep 2020. There was 1 interview round.
I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.
Experienced in conducting market research and competitor analysis
Proficient in using various data analysis tools such as Excel, SQL, and Tableau
Skilled in identifying business needs and translating them into functional requirements
Excellent communication and presentation skills
Ability to work colla...
I want to work here because of the company's reputation, growth opportunities, and alignment with my skills and interests.
I am impressed by the company's reputation in the industry.
I see great potential for growth and advancement within the company.
The company's values and mission align with my own.
I believe my skills and experience would be a valuable asset to the company.
I am excited about the opportunity to contribu...
I have a unique combination of technical skills and business acumen, allowing me to bridge the gap between IT and business stakeholders.
I have a strong background in both technology and business domains.
I can effectively communicate with both technical and non-technical stakeholders.
I have a track record of successfully translating business requirements into technical solutions.
I possess a deep understanding of various...
The company is a leading technology firm specializing in software development and consulting services.
The company was founded in 2005 and has since grown to have a global presence.
They offer a wide range of services including business analysis, software development, and project management.
Some of their notable clients include Fortune 500 companies in various industries.
They have a strong focus on innovation and staying...
My key professional strengths include analytical thinking, problem-solving, and effective communication.
Analytical thinking: I have a strong ability to analyze complex business problems and identify key insights.
Problem-solving: I am skilled at finding creative solutions to challenges and implementing them effectively.
Effective communication: I can communicate complex ideas and findings clearly and concisely to stakeho...
My biggest weaknesses include perfectionism, overthinking, and public speaking anxiety.
Perfectionism: I tend to spend too much time on tasks to ensure they are flawless.
Overthinking: I sometimes overanalyze situations, which can lead to indecisiveness.
Public speaking anxiety: I get nervous when presenting in front of large audiences.
I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.
I appeared for an interview in Nov 2020.
An interview is a formal conversation between an employer and a job candidate to assess their suitability for a role.
Interviews are used to evaluate a candidate's skills, experience, and personality.
They can be conducted in person, over the phone, or via video conferencing.
Interviews typically involve a series of questions and may include assessments or tests.
Examples of common interview questions include 'Tell me abou
I plan to save a portion, invest in professional development, and treat myself to a small reward.
Save a portion of the salary for future financial goals
Invest in professional development such as courses or certifications
Treat myself to a small reward or experience as a form of celebration
I applied via Company Website and was interviewed before Oct 2021. There were 4 interview rounds.
There is one OA after your interview shortlisted based on your domain or profile.
I applied via Naukri.com and was interviewed in Jan 2022. There were 3 interview rounds.
Group by clause is used to group data based on a specific column in a table.
Used with aggregate functions like SUM, COUNT, AVG, etc.
Helps in analyzing data by grouping it based on a common attribute.
Can be used with multiple columns to create nested groups.
Example: GROUP BY department in a table of employees to get the total salary for each department.
CountA, CountB, Countif are functions used in Google Sheets to count cells based on certain criteria.
CountA counts the number of cells in a range that are not empty.
CountB counts the number of cells in a range that are not blank.
Countif counts the number of cells in a range that meet a certain condition.
Countif can be used with operators like >, <, =, and functions like AND, OR.
Countif can also be used with wildcards l
Cohort analysis in Google Analytics helps track the behavior of specific groups of users over time.
Cohort analysis groups users based on a common characteristic or behavior, such as sign-up date or acquisition channel.
It helps in understanding user retention, engagement, and conversion rates for different cohorts.
Example: Analyzing the retention rate of users who signed up in a particular month compared to users who si
Types of joins in SQL include inner join, outer join, left join, right join, and full join.
Inner join: returns rows when there is a match in both tables
Outer join: returns all rows from both tables, filling in NULLs for missing matches
Left join: returns all rows from the left table and the matched rows from the right table
Right join: returns all rows from the right table and the matched rows from the left table
Full joi...
I appeared for an interview before Aug 2023.
Simple python related and sql based question
Regular customers can be incentivized through loyalty programs, personalized discounts, exclusive offers, and rewards points.
Implement a loyalty program where customers earn points for each purchase, which can be redeemed for discounts or free items.
Offer personalized discounts based on the customer's purchase history or preferences.
Provide exclusive offers or early access to new products/services for regular customers...
Discounting is a way to incentivize inactive customers by offering them reduced prices or special deals to encourage them to make a purchase.
Discounting can help attract the attention of inactive customers who may have lost interest in the product or service.
It can create a sense of urgency and motivate customers to take action before the discount expires.
Discounting can also help clear out excess inventory or generate...
based on 2 interviews
Interview experience
Key Account Manager
149
salaries
| ₹3.2 L/yr - ₹8.6 L/yr |
Dealer Success Manager
149
salaries
| ₹3 L/yr - ₹6.3 L/yr |
Accounts Manager
109
salaries
| ₹2.7 L/yr - ₹6.8 L/yr |
Senior Accounts Manager
70
salaries
| ₹3.9 L/yr - ₹8 L/yr |
Retail Associate
65
salaries
| ₹2.9 L/yr - ₹6 L/yr |
Quikr
eBay
Tokopedia
Flipkart