i
Mobikwik
Filter interviews by
I appeared for an interview in Sep 2024.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets using SQL, Python, and R
Skilled in creating insightful reports and dashboards using Tableau and Power BI
Strong communication skills to present findings to stakeholders
Certified in data analysis and machine learning techniques
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
Strength: Strong analytical skills
Strength: Attention to detail
Weakness: Getting caught up in details (provide example)
I appeared for an interview in Dec 2021.
Round duration - 90 Minutes
Round difficulty - Easy
Problem solving using SQL questions
Round duration - 90 Minutes
Round difficulty - Easy
A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round
Metrics selection based on campaign objectives, target audience, and key performance indicators.
Identify campaign objectives and goals
Consider target audience and their behavior
Select key performance indicators (KPIs) relevant to the campaign
Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost
Analyze data to measure success and make data-driven decisions
Round duration - 30 Minutes
Round difficulty - Easy
Social empathatic fit round
Tip 1 : SQL logics to be understood completely
Tip 2 : A good running working logic of Python
Tip 3 : Basics of Dashboarding
Tip 1 : One pager , single column resume which shows all your skills
Tip 2 : Mention all things that make you relevant for the job
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.
They allow for calculations to be performed on a specific subset of rows within a query result set.
Window functions are commonly used for running totals, moving averages, and ranking data.
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a 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.
Full Outer Join: Returns rows when there is a match in one of the tables.
Cross Join:
I applied via Referral and was interviewed in Sep 2023. There were 4 interview rounds.
Technical SQL Coding Round of 1 hour
Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,
Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.
Bar Raiser Round of 1 hour involving -
1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?
2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.
3. Resume based work exp discussion
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 applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
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 Campus Placement and was interviewed in Dec 2021. There were 4 interview rounds.
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...
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Team Lead
69
salaries
| ₹2.2 L/yr - ₹7 L/yr |
Assistant Manager
56
salaries
| ₹4.5 L/yr - ₹12.6 L/yr |
Senior Executive
55
salaries
| ₹2.7 L/yr - ₹6.7 L/yr |
Software Developer
49
salaries
| ₹7.9 L/yr - ₹30.6 L/yr |
Software Development Engineer II
48
salaries
| ₹11 L/yr - ₹30 L/yr |
Paytm
Freecharge
HighRadius
Razorpay