i
Razorpay
Filter interviews by
I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.
It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.
I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
1. FROM: Specifies the tables involved in the query.
2. WHERE: Filters the rows based on specified conditions.
3. GROUP BY: Groups the rows that have the same values into summary rows.
4. HAVING: Filters groups based on specified conditions.
5. SELECT: Selects the columns to be included in the result set.
6. ORDER BY: Sorts the result set base
Conditional formatting in Excel allows users to format cells based on specified conditions.
Select the range of cells you want to apply conditional formatting to
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose the desired formatting option, such as color scales, data bars, or icon sets
Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
Experienced in using statistical analysis tools such as Python, R, and SQL
Proficient in data visualization tools like Tableau and Power BI
Skilled in data cleaning, data mining, and data modeling techniques
Strong problem-solving and critical thinking skills
Effective communicator and team player
Example: I have w...
The biggest hurdle I faced during organizing the tech fest of my college was securing sponsorships.
Difficulty in convincing companies to sponsor the event
Limited budget for organizing a large-scale tech fest
Competition with other college events for sponsorships
Negotiating sponsorship deals and ensuring deliverables
Finding sponsors aligned with the theme and objectives of the tech fest
Yes, pursuing an MBA can enhance my skills and open up new career opportunities.
An MBA can provide a strong foundation in business and management principles.
It can help develop analytical and problem-solving skills.
An MBA can broaden my network and provide access to valuable connections.
It can open up leadership roles and higher-level positions in organizations.
Having an MBA can increase earning potential and job prosp...
Yes, Reliance Fresh should open a store in the north-eastern part of India.
The north-eastern part of India has a growing population and increasing consumer demand.
Reliance Fresh can tap into the untapped market potential in the region.
Opening a store in the north-eastern part of India can help Reliance Fresh expand its presence and increase its market share.
Reliance Fresh can leverage its existing supply chain and dist...
The number of people travelling by local metro in Mumbai is estimated to be in millions.
Mumbai has a population of over 20 million people.
The local metro is a popular mode of transportation in Mumbai.
During peak hours, the metro trains are usually crowded.
The metro network in Mumbai is extensive, covering various parts of the city.
The number of daily commuters on the metro can be estimated based on population density a
I applied via Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.
SQL
Python
R
Tableau
Excel
SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard
To find the nth salary in a dataset
Sort the dataset in descending order based on salary
Remove duplicates if necessary
Return the salary at index n-1
I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.
Implement lag() and lead() functions without using lag() or lead()
To implement lag(), shift the values in the array by one position to the right
To implement lead(), shift the values in the array by one position to the left
For example, to implement lag() on [1, 2, 3, 4], you can shift the values to get [null, 1, 2, 3]
For lead(), you can shift the values to get [2, 3, 4, null]
Optimising a query involves identifying bottlenecks and improving efficiency.
Identify slow-performing queries using tools like query execution plans.
Optimize database indexes to speed up query performance.
Limit the number of columns and rows returned in the query.
Avoid using SELECT * and instead specify only the necessary columns.
Use appropriate data types and avoid unnecessary data conversions.
Consider denormalizing d...
Replace 'b' with 'v' in the 3rd position of each string in an array
Iterate through each string in the array
Check if the 3rd position contains 'b'
If yes, replace 'b' with 'v'
I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.
Easy questions based on Logical Reasoning, Mathematics, English
Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.
based on 3 interviews
Interview experience
based on 5 reviews
Rating in categories
Junior Analyst
115
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
Analyst
102
salaries
| ₹3.5 L/yr - ₹7.3 L/yr |
Software Engineer
102
salaries
| ₹8 L/yr - ₹24 L/yr |
Senior Associate
93
salaries
| ₹5.2 L/yr - ₹15 L/yr |
Software Development Engineer
87
salaries
| ₹8 L/yr - ₹31.5 L/yr |
Paytm
PayPal
BharatPe
Fiserv