Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by MiQ Digital Team. If you also belong to the team, you can get access from here

MiQ Digital Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

MiQ Digital Analyst II Interview Questions and Answers

Updated 5 Nov 2022

MiQ Digital Analyst II Interview Experiences

1 interview found

Analyst II Interview Questions & Answers

user image Anonymous

posted on 5 Nov 2022

I was interviewed in Oct 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. SQL: 1. find the duplicates in a given dataset 2. order of execution 3. output of rank and dense rank 4. running total Tableau: 1. live vs extract 2. scatter plot and box plot 3. formula for IDR and outlie...
  • Ans. 

    Interview questions for Analyst II position on SQL, Tableau, and Guesstimate

    • SQL: finding duplicates, order of execution, rank and dense rank, running total

    • Tableau: live vs extract, scatter plot and box plot, IDR and outliers formula

    • Guesstimate: estimating number of flights taking off from an airport in a day

  • Answered by AI
  • Q2. Aptitude: 10 SQL basis questions and 3 DI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with what you mentioned in your resume. All the best.

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. What type of products are there ?

Interview Questionnaire 

2 Questions

  • Q1. Little discussion on my project
  • Q2. Given a chessboard and the initial position of horse. If “n” is the number of steps the horse can make then what is probability that it goes out of board ?
  • Ans. 

    Probability of a horse going out of a chessboard in 'n' steps.

    • The total number of possible moves for a horse is 8.

    • The probability of going out of the board depends on the position of the horse.

    • For example, if the horse is at a corner, the probability of going out of the board is higher.

    • The probability can be calculated using combinatorics and geometry.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: They did not expect any code in this round. An algo or pseudo code is fine.



1) You are given 2 vessels with capacity M liters and N liters capacity and infinite supply of water. You need to find the minimum number of steps required to get P liters. Any of the below action is considered a step



     a) Filling vessel with water



     b) Emptying vessel



     c) Pouring water from one vessel to another vessel.



2) Given n sets each containing m integers. You need to create MinDiff set by picking exactly 1 element from each set. The difference between the maximum and minimum elements in the MinDiff set should be minimum.



eg: for the sets {30, 20, 10, 40},{ 22, 33, 44, 99},{ 16, 17, 18, 19} min diff set is {19, 20, 22}. Max and min elements in MinDiff set are 22 and 19 and their difference is 3.

Round: Technical Interview
Experience: 1) you will be given the binary representation of the numbers in the form of 2D array.eg: r1- 00001

r2- 00100

r3- 01010

r4- 00110

r5- 00111 This means the elements are 1, 4, 10 , 6 and 7.

A number “n” is given. Let us say that n can be formed by doing bitwise OR operation on rows of given matrix. What is the minimum number of rows that needs to be deleted from the matrix so that “n” can never be formed by doing the OR of the rows.

If n is 14(01110) then it can be formed by doing r2|r3 or r3|r4. You can prevent n formation either by deleting {r2,r4} or {r3}. But {r3} has least number of elements so it is the required set.2) Find the average of mid 50% of elements in the running stream of integersI have not cleared round-II so no further questions.

College Name: IIT GANDHINAGAR

I applied via Campus Placement

Interview Questionnaire 

3 Questions

  • Q1. Tell me one thing about you that's not listed on your resume
  • Ans. 

    I am an avid traveler and have visited over 20 countries

    • I love experiencing new cultures and trying new foods

    • I have backpacked through Europe and Asia

    • I have volunteered in orphanages in Cambodia and Nepal

  • Answered by AI
  • Q2. When you hear InMobi, what's the first word that comes in your head?
  • Ans. 

    Mobile advertising platform

    • Adtech

    • Mobile marketing

    • App monetization

  • Answered by AI
  • Q3. The office of InMobi technologies has 10 floors, each with 300 employees. In the morning (7-8 AM), the building sees 3000 employees entering and waiting in a queue for 3 lifts. In the morning, everyone goe...

Interview Preparation Tips

Round: Resume Shortlist
Experience: The first round was a resume shortlist, which I think was on the basis of programming and coding courses (and projects) taken along with your CGPA. Out of 10 shortlisted people, I knew 4 and all of us were 9 pointers. The rest who I didn't know turned out to be 9 pointers as well! :P
Out of 10 shortlisted people, 3 (including me) were from ECE and the rest were from CS. Even though InMobi was open for Mathematics & Computing, no person from MnC dept. was in the shortlist. (Presumably due to their CGPAs or some other criterion that I'm not in the knowledge of.)
Tips: i) High CGPA is a must (We're talking above 9, at the end of 2nd year for CS/ECE and 3rd year for MnC)
ii)Taking programming and algorithm courses and projects is important, as that must be visible in your resume.

Round: Puzzle Interview
Experience: One special thing about the interviews, you're asked not to wear any formals! That actually helps in taking the tension off of things!
It's simple logic, after that. Increase the lift's speed (taking in mind of the safety), collecting usage data, optimising the lift's floor-stoppage according to that.
As told after the interview, the interviewer is just observing how you think and approach a problem.

One odd thing was not being asked about any coding/algorithm questions even though the profile was for a software engineer.

After this question, I was asked if I had any questions to ask. I simply stated that the work environment and culture affected me as much as the profile I'm applying for. Thus, the drive and motivation of the people who work there is also very important. So I asked what are the companies' values which the employees believe in, too.
Tips: Stay confident, don't let any tension get to your head.
In the future, InMobi may start asking coding questions too in the interviews. or change the selection procedure, which will be communicated in the PPT of InMobi.
Whatever may happen, the first round should show your zeal to solve problems, your creativity in trying different approaches, and applying logic to find the best solution.

Round: HR Interview
Experience: OK! There were a lot of questions asked since the interview was more like a conversation taking place. Like in ANY conversation, keep proper eye contact, smile and be approachable for any questions. Show enthusiasm in your voice and your answers. The interviewer asked me questions about
i)My resume, and all the activities that I'd listed there. (eg: Why did you enlist in this course? Do you like coding?)
ii)Why programming, how does it interest you?
iii)Basic questions about InMobi, like 'What do you know about us after attending the PPT?' and 'Why InMobi'

Since I had done quite a lot of marketing activities, I was also asked about that. Will you do an MBA in the future? What all did you do for marketing? I had a strong background in digital marketing, and we had a little chat about mobile marketing and what's the future of mobile advertising.
Tips: Smile, for god's sake! It's a conversation about you, do all the basic things to improve the conversational experience.
Small things like greeting the interviewer, smiling, proper eye contact, and speaking properly are paramount.

Like in any HR interview, make sure you know yourself and your resume properly, so that you don't phase out in the interview when asked some 'unexpected' question. (since that's when they know thatyou might be lying/exaggerating). Hence introspect enough before sitting the interviews.

General Tips: Make sure you're able to convince yourself and the interviewers for why do you want to work in Inmobi Technolgies.

I've already shared the rest in previous sections! :)

2 people out of 10 were selected for this internship experience, so make sure you prepare well! All the best! :D

Skill Tips: I don't think that this adds on as a skill, but InMobi wants to create a huge impact on the mobile world and the mobile advertising sector.
Your knowledge about this sector in general could help you strike good conversations (at least in the HR round).
Skills: Logic, Problem Solving Abilties, Creativity, Communication Skills
Duration: 2.5
College Name: IIT Kharagpur
Motivation: I'm a gadget geek from my childhood. The mobile industry amazes me as it's been the biggest change-bringer in the modern world. InMobi as a company wants to create a huge impact in the mobile advertising space and mobile advertising! And seeing their products that they offer in this domain had me thinking that they're doing something unique and awesome!
The work culture of InMobi is just amazing, right from flexible work hours to the epic office they have in Bangalore full of awesome people working towards that one goal! Also, InMobi offers their employees opportunities to shift between various verticals if they want to. All of this (along with a good compensation ;-) ) was enough motivation for me to apply!
Funny Moments: When I was asked whether I was in the third year, I said yes, and then said, usually people think that I'm still in high school!
We had a good laugh on that one! :P

Otherwise also, the entire procedure was relaxed and fun in general.

Interview Questionnaire 

9 Questions

  • Q1. Find Maximum sub sequence sum in an array ?
  • Ans. 

    Maximum sub sequence sum in an array

    • Use Kadane's algorithm

    • Initialize max_so_far and max_ending_here to 0

    • Iterate through the array and update max_ending_here and max_so_far

    • Return max_so_far

  • Answered by AI
  • Q2. What do you understand by the endianness of the system ? How do you find out the the type of endianness ?
  • Ans. 

    Endianness refers to the byte order of a system. It determines how multi-byte data types are stored in memory.

    • Little-endian systems store the least significant byte first, while big-endian systems store the most significant byte first.

    • Endianness can affect the way data is transmitted between systems.

    • To determine the endianness of a system, you can use the byte order mark (BOM) or write a test program that checks the by...

  • Answered by AI
  • Q3. Sort an array which consists of 0's and 1's only
  • Ans. 

    Sort an array of 0's and 1's only.

    • Use two pointers, one at the beginning and one at the end of the array.

    • Swap 0's from the beginning with 1's from the end until the pointers meet.

    • Alternatively, use a counting sort algorithm to count the number of 0's and 1's and then reconstruct the array.

  • Answered by AI
  • Q4. A question on applications of minimum spanning tree, apply prim's or kruskal's algorithm
  • Q5. What do you understand by Heaps, max and min heaps ?
  • Ans. 

    Heaps are data structures used to efficiently find the maximum or minimum element in a collection.

    • Max heap: parent nodes are always greater than or equal to child nodes

    • Min heap: parent nodes are always smaller than or equal to child nodes

    • Heaps are commonly used in priority queues and sorting algorithms

    • Heap operations include insert, delete, and extract max/min

    • Example: An array [3, 8, 2, 5, 1, 4, 6] can be represented a

  • Answered by AI
  • Q6. What do you understand by hashing ? questions on application of hashing
  • Q7. Find 3 nos a,b and c in an array where a+b = c
  • Ans. 

    Find 3 numbers in an array where a+b=c.

    • Loop through the array and check for all possible combinations of a and b.

    • Use a hash table to store the values of a and b, and check if c is present in the hash table.

    • Sort the array and use two pointers to find a and b, and then check if their sum equals c.

  • Answered by AI
  • Q8. Some puzzles, as the other interviewee said, but not asked to me
  • Q9. Questions on Dynamic programming

Interview Preparation Tips

College Name: NA

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. Algorithms on arrays and strings (coding)
  • Ans. 

    Algorithms for manipulating arrays and strings in coding

    • Use sorting algorithms like quicksort and mergesort for arrays

    • Use string manipulation functions like substring and replace for strings

    • Use dynamic programming for optimizing solutions to array and string problems

  • Answered by AI
  • Q2. Distributed Database Design
  • Q3. Large scale Ad Server Design
  • Ans. 

    Designing a large scale Ad Server

    • Use distributed systems for scalability

    • Implement caching for faster ad delivery

    • Ensure high availability and fault tolerance

    • Use real-time bidding for efficient ad placement

    • Implement fraud detection mechanisms

    • Ensure compliance with privacy regulations

  • Answered by AI

Interview Preparation Tips

Round: Interview
Experience: They tested on thought-process during design problems. What problems are with the current solution I suggested and how to improve it...
Tips: Hints from interviewer are very helpful
Keep talking while you are thinking

Skills: Algorithms, Thinking Skills, Coding
College Name: IIT KHARAGPUR

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Automation testing platforms
  • Q2. Java programs for list and strings
  • Ans. 

    Java programs for manipulating lists and strings.

    • Use ArrayList class for lists and String class for strings.

    • To add elements to a list: list.add(element);

    • To access elements in a list: list.get(index);

    • To concatenate strings: string1 + string2;

    • To find the length of a string: string.length();

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. Related to your previous experience
  • Q2. Costing questions basics
  • Q3. Accounting end to end
  • Q4. Taxation basics
Round 3 - HR 

(1 Question)

  • Q1. Location, expecting package
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Basic Fibonacci and prime number questions.

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Questions on your resume
  • Q2. Questions on summer internship
Round 2 - HR 

(2 Questions)

  • Q1. Awareness in general about trends
  • Q2. Company awareness

MiQ Digital Interview FAQs

How many rounds are there in MiQ Digital Analyst II interview?
MiQ Digital interview process usually has 2 rounds. The most common rounds in the MiQ Digital interview process are Resume Shortlist and Technical.
How to prepare for MiQ Digital Analyst II interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at MiQ Digital. The most common topics and skills that interviewers at MiQ Digital expect are Python, Analytical, Business Analysis, Data Science and Public Speaking.
What are the top questions asked in MiQ Digital Analyst II interview?

Some of the top questions asked at the MiQ Digital Analyst II interview -

  1. SQL: 1. find the duplicates in a given dataset 2. order of execution 3. output ...read more
  2. Aptitude: 10 SQL basis questions and 3...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Regalix Interview Questions
2.9
 • 44 Interviews
Denave Interview Questions
3.6
 • 39 Interviews
Xdbs Interview Questions
3.2
 • 39 Interviews
InMobi Interview Questions
3.5
 • 35 Interviews
Smollan Group Interview Questions
4.2
 • 34 Interviews
Mediamint Interview Questions
3.4
 • 32 Interviews
Adglobal360 Interview Questions
3.2
 • 24 Interviews
View all
MiQ Digital Analyst II Salary
based on 12 salaries
₹13 L/yr - ₹17 L/yr
109% more than the average Analyst II Salary in India
View more details

MiQ Digital Analyst II Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

3.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

3.0

Company culture

5.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
29 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
24 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
20 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
20 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare MiQ Digital with

Affle

3.1
Compare

InMobi

3.5
Compare

Komli Media

4.0
Compare

Deloitte Digital

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview