i
Paytm
Filter interviews by
They give me SQL test
I applied via Instahyre and was interviewed before May 2022. There were 3 interview rounds.
Advanced level of SQL involves complex queries, subqueries, joins, and optimization techniques.
Advanced SQL involves using subqueries to retrieve data from multiple tables
Joins are used to combine data from multiple tables based on common columns
Optimization techniques like indexing and query tuning are used to improve performance
Window functions and common table expressions are also part of advanced SQL
Examples includ...
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 Campus Placement
To determine profitability between monthly and daily bus membership, conduct a cost-benefit analysis.
Gather data on the cost of monthly and daily bus passes
Determine the frequency of usage for each pass type
Calculate the total cost of using each pass type over a given period
Compare the costs to the benefits of each pass type, such as convenience and flexibility
Consider external factors, such as the availability of park...
Choosing between two car varieties based on various costs
Consider upfront costs such as purchase price and financing options
Factor in ongoing costs such as fuel efficiency and maintenance
Evaluate potential resale value
Compare insurance rates
Consider any additional features or benefits of each car
Make a decision based on overall cost-effectiveness and personal preferences
Choosing between in-branch and out-branch ATM's based on various parameters
Consider the location and accessibility of the ATM
Analyze the cost of installation and maintenance
Evaluate the security measures in place
Assess the customer demand and usage patterns
Factor in the availability of other banking services at the branch
Out-branch ATMs may be more cost-effective but in-branch ATMs offer better customer experience
Phone calls are more effective for Capital One's marketing strategy.
Phone calls allow for immediate feedback and personalized communication.
Letters may be ignored or lost in the mail.
Capital One can track phone call success rates and adjust their strategy accordingly.
Phone calls can also be used to cross-sell and upsell products.
Letters may be more appropriate for certain types of communication, such as legal notices o
I sought help from my peers when I faced a complex data analysis problem.
I explained the problem to my peers and asked for their suggestions.
We brainstormed and discussed various approaches to solve the problem.
One of my peers suggested a new tool that could simplify the analysis process.
I tried the tool and it worked perfectly, saving me a lot of time and effort.
The outcome was a successful completion of the project w
Overcoming an obstacle in a project
During a software development project, we faced a challenge with integrating a third-party API
I researched and found a workaround by using a different API that provided similar functionality
I presented the solution to the team and we implemented it successfully
The outcome was that we were able to deliver the project on time and within budget
I learned about agile methodology for a project
Attended a training session on agile methodology
Implemented agile methodology in a project
Learned about sprints, backlogs, and daily stand-up meetings
Improved project efficiency and communication with team members
Implement thread safe load balancer.
focus on input validations and cover all corner cases in tests
I applied via Approached by company and was interviewed in Aug 2021. There were 2 interview rounds.
Quant focussed Case Study (be prepared for calculations)
I applied via Company Website and was interviewed in May 2022. There were 2 interview rounds.
There's a short technical multiple questions in the first round.
There's a short case interview. it's one-on-one case and it last for about 45 minutes.
DSA coding round.
Graph based question, dp question.
Design a service to download large files.
Use a scalable architecture to handle large file downloads.
Implement resumable downloads to handle network interruptions.
Use parallel downloading to speed up the download process.
Implement authentication and authorization to ensure security.
Provide progress updates to the user during the download process.
based on 2 interviews
Interview experience
based on 7 reviews
Rating in categories
Team Lead
2.1k
salaries
| ₹2 L/yr - ₹11.4 L/yr |
Senior Software Engineer
1.4k
salaries
| ₹10.1 L/yr - ₹35 L/yr |
Software Engineer
1.4k
salaries
| ₹6 L/yr - ₹23 L/yr |
Sales Executive
965
salaries
| ₹1 L/yr - ₹6 L/yr |
Senior Associate
911
salaries
| ₹2.3 L/yr - ₹9 L/yr |
BharatPe
Zerodha
Razorpay
Mobikwik