i
Slice
Filter interviews by
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
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
FU...
Window functions are used to perform calculations across a set of table rows related to the current row.
Window functions are used in SQL to perform calculations on a set of rows related to the current row.
They allow you to perform calculations like ranking, moving averages, and cumulative sums.
Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
Quantitative case study on cost benefit analysis of 2 types of public buses running in a city. Need to choose one of them with higher profits
Fraud detection model: 3rd party firm proposing to use thier model for fraud detection. Need to profit analysis of whether to go for it or not.
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...
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 applied via Referral and was interviewed in Jul 2024. There were 2 interview rounds.
36 questions of cognitive ability
How social media is killing the creativity
I appeared for an interview in Sep 2024, where I was asked the following questions.
A GROUP BY statement on unique values returns the same unique values, often used for aggregation.
GROUP BY aggregates data based on specified columns.
If the column has unique values, each group will contain only one row.
Example: SELECT column_name, COUNT(*) FROM table GROUP BY column_name; returns unique values with their counts.
Useful for summarizing data, but no meaningful aggregation occurs with unique values.
Use a data migration tool to copy the dataset efficiently.
Utilize a data migration tool like AWS Data Pipeline, Apache Nifi, or Talend to copy the dataset.
Break down the dataset into smaller chunks to avoid overwhelming the system.
Ensure proper data validation and error handling during the copying process.
Consider using parallel processing to speed up the copying process.
Monitor the progress of the dataset copying to t
No, data analysis job is not overrated as it plays a crucial role in decision-making and problem-solving.
Data analysis helps in identifying trends and patterns in data
It provides valuable insights for businesses to make informed decisions
Data analysis is essential for optimizing processes and improving efficiency
It can uncover hidden opportunities and potential risks
Many industries rely on data analysis for strategic p
posted on 9 Oct 2024
I appeared for an interview in Sep 2024.
based on 2 interviews
Interview experience
based on 2 reviews
Rating in categories
KYC Associate
144
salaries
| ₹2.5 L/yr - ₹4.8 L/yr |
Team Lead
56
salaries
| ₹4 L/yr - ₹10.7 L/yr |
Collections Executive
49
salaries
| ₹2.2 L/yr - ₹4.2 L/yr |
Customer Support Executive
40
salaries
| ₹3.1 L/yr - ₹5.8 L/yr |
Customer Service Executive
25
salaries
| ₹3.2 L/yr - ₹6.1 L/yr |
Fiserv
PhonePe
KFintech
Angel One