Razorpay Interview Questions, Process, and Tips

Q1. What is the to begin a software ?
Ans. 
The first step to begin a software is to identify the problem and gather requirements.
• Identify the problem that needs to be solved

• Gather requirements from stakeholders

• Analyze and prioritize requirements

• Design a solution architecture

• Choose appropriate technologies and tools

• Develop and test the software

• Deploy and maintain the software
Answered by AI
Add your answer
Q2. What is the system or process of an software company?
Ans. 
The system or process of a software company involves various stages from planning to deployment.
• The process starts with requirement gathering and analysis.

• Then comes the design and development phase.

• Testing and quality assurance is an important part of the process.

• Deployment and maintenance are the final stages.

• Agile and DevOps methodologies are commonly used.

• Tools like JIRA, Git, Jenkins, etc. are used for project man
Answered by AI
Add your answer
Q3. What we learn about software
Ans. 
Software development is a continuous learning process.
• Software development is constantly evolving and requires continuous learning to keep up with new technologies and best practices.

• Developers must stay up-to-date with programming languages, frameworks, and tools.

• Learning about software also involves understanding the importance of testing, documentation, and collaboration.

• Examples of new technologies include cloud co...read more
Answered by AI
Add your answer

Q1. Basic questions about CV and why Razorpay
Add your answer

Q1. Discussed about CTC, future plans and joining date
Add your answer

Q1. SQL questions regarding window functions
Add your answer
Q2. Calc retained revived new customer per month basis what are joins in sql what is dense rank
Ans. 
To calculate retained, revived, and new customers per month basis, joins in SQL and dense rank are used.
• To calculate retained, revived, and new customers per month basis, you would typically use SQL queries to join different tables containing customer data.

• Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Dense rank is a function in SQL that assigns a rank to each row ...read more
Answered by AI
Add your answer
Q3. How sql query work behind the scenes
Ans. 
SQL queries work by parsing and executing commands to retrieve data from databases.
• SQL query is written in a specific syntax to communicate with databases.

• The query is parsed by the database management system to understand the command.

• The database engine then executes the query to retrieve the requested data.

• Queries can involve selecting, updating, inserting, or deleting data from tables.

• Example: SELECT * FROM table_na
Answered by AI
Add your answer

Tv commercial case study regarding if we run campaign of product over television how can attribute it to spike or increase in tration which we see in our data.

Q1. Cultural fit round
Add your answer

Q1. Introduction Previous Sales Experience Passion about your projects
Ans. 
I have extensive sales experience and a passion for delivering successful projects.
• I have worked in sales for over 5 years, consistently exceeding targets and building strong relationships with clients.

• I am highly motivated and enjoy the challenge of meeting and exceeding customer expectations.

• I have a track record of successfully delivering projects on time and within budget, ensuring customer satisfaction.

• I am passio...read more
Answered by AI
Add your answer

Q1. Introduction Previous Experience Sales Cycle Experience
Ans. 
I have extensive experience in sales cycle management and have worked in various industries.
• I have worked in sales for over 7 years, with experience in both B2B and B2C sales.

• I have managed the entire sales cycle, from prospecting to closing deals.

• I have experience in industries such as technology, healthcare, and finance.

• I have consistently exceeded sales targets and have been recognized for my performance.

• I am skille...read more
Answered by AI
Add your answer

Round duration - 150 Minutes
Round difficulty - Easy

Machine coding round with local testing by the interviewer.
Interviewer was friendly and insisted on understanding the problem first and then designing and then inspecting whether it solves the problem and then implementing
Design and implement an In-Memory SQL based database with insert, get and filter features.

Q1. System Design Question
Design and implement an In-Memory SQL based database with insert, get and filter features.
Ans. 
Tip 1 : Have SQL database workings on your finger tips
Tip 2 : Understand the problem completely before implement and thinking of a solution.
Answered by CodingNinjas
Add your answer

Round duration - 60 Minutes
Round difficulty - Easy

It was around 6 PM. Had to turn on my camera and explain my role in previous experience in depth. 

Q1. Basic HR Questions
Also questions like what do you prefer, why are you switching, what do you like and dislike about current workplace and other behaviour questions, etc
Add your answer

Q1. The interview is a 3 step process starting with System Design Round, Technical Interview, Coding Round, HR Discussion. Couldn't go beyond System Design Round
Add your answer
Q2. Design a system to handle semi structure to structure data, how to utilize data lake, handle unclean data from source, tackle pipeline failure, data warehouse optimization techniques, identifying error que...read more
Add your answer