i
Rupeek
Filter interviews by
I applied via LinkedIn and was interviewed in Jun 2023. There were 2 interview rounds.
SQL queries for JOINS
Use INNER JOIN to retrieve rows from both tables that have matching values
Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table
Use FULL JOIN to retrieve rows when there is a match in either table
The query is asking for metrics provided in a specific sheet.
Identify the specific sheet being referred to in the question
Review the metrics listed in the sheet
Analyze the relevance of each metric to the query
This is a case study round revolve around a business problem in which we have to analyse data driven solutions.
I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.
General aptitude questions and excel questions
I appeared for an interview in Dec 2016.
I tend to be too organized and structured, which can annoy my friends at times.
My friends sometimes find my need for planning and structure to be excessive
I can be inflexible when it comes to deviating from my plans
My attention to detail can come across as nitpicky to some
I prioritize efficiency over spontaneity, which can be frustrating for my more laid-back friends
I don't have the available data to answer this question.
Need data on number of barbers in Kanpur
Need data on average revenue per barber
Need data on number of working days in a year
Need data on number of customers per barber per day
To open an e-commerce website like Flipkart, one must keep in mind various factors such as target audience, product range, user experience, logistics, and marketing.
Identify the target audience and their preferences
Offer a wide range of products to cater to different needs
Ensure a seamless user experience with easy navigation and quick loading time
Establish a robust logistics network for timely delivery and hassle-free...
It depends on the job profile and its alignment with my career goals.
I would consider the job profile and evaluate its alignment with my career goals.
I would assess the job responsibilities and the skills required for the role.
I would also consider the company culture and work environment.
If the job profile aligns with my career goals and offers growth opportunities, I would accept it.
However, if it does not align with...
I would have pursued a certification in data science earlier.
I should have taken a course in data science during my undergraduate studies.
I could have pursued a certification in data science while working as a business analyst.
Learning data science earlier would have opened up more opportunities for me in the field.
I could have gained more experience in data analysis and visualization.
I could have applied for more adva
I appeared for an interview in Mar 2017.
I am a detail-oriented business analyst with experience in data analysis and project management.
Experienced in data analysis and project management
Detail-oriented and analytical mindset
Strong communication and interpersonal skills
Proficient in various analytical tools such as Excel, SQL, and Tableau
I am not familiar with your company.
I have not had the opportunity to research your company yet.
I would appreciate it if you could provide me with more information about your company.
I am open to learning more about your company and its goals.
I have the skills, experience, and passion to excel in this role and contribute to the success of the company.
I have a strong background in data analysis and problem-solving, which are essential skills for a business analyst.
I have experience working with various stakeholders, including clients, developers, and project managers, to ensure successful project delivery.
I am a quick learner and adaptable to new technologie...
Marketing strategies are plans and tactics implemented by businesses to promote their products or services and reach their target audience.
Identifying target audience and market segmentation
Creating a unique value proposition
Developing a marketing mix (product, price, place, promotion)
Utilizing digital marketing channels (social media, email marketing, SEO)
Implementing content marketing and storytelling
Building brand a...
posted on 9 Oct 2024
I appeared for an interview in Sep 2024.
posted on 12 Jun 2024
Online banking application is a web-based platform that allows customers to perform financial transactions remotely.
Customers can view account balances and transaction history.
They can transfer funds between accounts or to other people.
They can pay bills and set up automatic payments.
The application should have strong security measures to protect customer data.
It should also have a user-friendly interface for easy navi...
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.
Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.
Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.
Current CTC and preferred location are confidential information.
Current CTC and preferred location are personal and confidential details.
It is common practice not to disclose current CTC during interviews.
Preferred location may vary based on individual circumstances and preferences.
based on 2 interviews
Interview experience
based on 9 reviews
Rating in categories
Loan Manager
340
salaries
| ₹2.4 L/yr - ₹5 L/yr |
Sales Manager
277
salaries
| ₹2 L/yr - ₹4.6 L/yr |
Senior Relationship Manager
276
salaries
| ₹2 L/yr - ₹5 L/yr |
Team Lead
135
salaries
| ₹4 L/yr - ₹7.2 L/yr |
Operations Executive
73
salaries
| ₹2.1 L/yr - ₹4 L/yr |
Fiserv
PhonePe
KFintech
Angel One