AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
iQuanti
Compare
Filter interviews by
iQuanti Lead Analyst Interview Questions and Answers
iQuanti Lead Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consultant and was interviewed in Jul 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Questions revolved around basic adobe analytics, case studies and 1 guestimations
Interview Preparation Tips
Lead Analyst Jobs at iQuanti
Interview questions from similar companies
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.
Interview Preparation Tips
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
45 min very easy MCQ test on hacker rank covering aptitude , MySQL and MS Excel topics.
(1 Question)
- Q1. SQL queries,Python,Pandas,Numy,MS Excel
(1 Question)
- Q1. Behavioural questions
Interview Preparation Tips
Selected
(2 Questions)
- Q1. Prepare SQL and Pyspark well
- Q2. Prepare well on SQL Joins
(1 Question)
- Q1. Read about Programmatic advertising
Selected
I applied via Recruitment Consulltant and was interviewed before Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions about your previous experience
(1 Question)
- Q1. Excel and Data visualization questions. Depends on the role you are being hired for.
Interview Preparation Tips
Selected
I applied via Job Portal and was interviewed before Apr 2023. There were 3 interview rounds.
Test on Hackerrank SQL
(1 Question)
- Q1. Questions on SQL, R, Case study
Detailed discussion on use cases
abishek saju
(1 Question)
- Q1. Why do you want to work here
(1 Question)
- Q1. Explain your previous work experience
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There were 2 interview rounds.
This is kind of mixed round with both technical questions followed by coding test.This position if for SR RPA developer(uipath) so I was asked about UiPath and then was asked to extract data from some pdf invoices using document understanding.
I was asked if I know Power BI,( if they have had a look at my resume before shortlisting my profile,they would have known that I dont have any exposure to power BI),Still they shortlisted it.
(1 Question)
- Q1. Combined tech and coding round
Interview Preparation Tips
I was approached by a consultancy regarding this job opportunity with Dentsu,Bangalore COE.
Pathetic experience right from the beginning.
I told my CTC expectation and the HR(consultancy) was like 'Dentsu offers only 30-40% hike at max.'. and I was like ' what! When did RPA skillset become a non-digital skill, that too when digital profiles recruitment is on a peak stage. (Trust me the hike % have gone all time high during the last 3-4 months for digital skillset.), But after 1 day, HR replied back saying that the company is ok to match my expectation.(this was a bit fishy).
Then,
The interview was rescheduled 4 times because they want to conduct interview after 3PM and during weekdays only and also the interview is for 1 hr and 30 mins (which is pretty much busy time as I work during UK hours and also 1.30 hrs seriously?)
Finally I compromised and i took half day leave to attend the interview.
I've answered pretty much everything they asked and have completed the data extraction task within the given time but I dont know what made them drop my profile.
This is what I came to conclusion :
They needed someone who is having POWER BI,VBA experience with RPA tools knowledge.
Then why the hell have they raised a CO to hire an sr. RPA developer for UIPATH?
Are they expecting everything to be done by a single resource, if that's the expectation then here's my Tip "READ THE RESUMES PROPERLY" before shortlisting.
Here's my tip to those who attend interviews for similar positions in this company:
Don't waste your precious time and dont compromise.Just because they are offering a job doesn't mean you have to compromise. When interviews are being scheduled on weekdays and for experienced professionals, its a common sense that the schedule has to be based on common available times for both the parties and if the interview is going to be more than an hour,it has to be scheduled on a weekend.
The whole interview seemed to be a timepass activity as the people (2 persons) interviewing me dropped one after the other saying that they had some work. Lol.
I had to attend interview at the time they wanted and by applying a leave but they couldn't wait.
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.
Online Hackerrank Test on SQL
(1 Question)
- Q1. Discussion on CV, questions on SQL, R and Python
Case Study Discussion
Selected
I applied via LinkedIn and was interviewed before Feb 2023. There were 3 interview rounds.
(3 Questions)
- Q1. Questions were on Power BI, SQL, Python
- Q2. Explain the use cases of different charts in Power BI?
- Ans.
Different charts in Power BI have various use cases such as visualizing trends, comparing data, and highlighting outliers.
Bar charts are useful for comparing data across categories.
Line charts are great for showing trends over time.
Pie charts can be used to show the proportion of each category in a dataset.
Scatter plots are helpful for identifying relationships between two variables.
Gantt charts are ideal for visualizi
- Q3. Write a query to find nth highest salary in SQL?
- Ans.
Query to find nth highest salary in SQL
Use the ORDER BY clause to sort the salaries in descending order
Use the DISTINCT keyword to eliminate duplicates
Use LIMIT and OFFSET to get the nth highest salary
Price Implementation Case Study. Determine the new price of a product based on a few conditions applied to other columns or parameters.
(1 Question)
- Q1. Generic resume review and questions about past work experience. There were a few questions about drawing actionable insights based on data analysis.
Skills evaluated in this interview
iQuanti Interview FAQs
Tell us how to improve this page.
iQuanti Interviews By Designations
- iQuanti Analyst Interview Questions
- iQuanti Senior Analyst Interview Questions
- iQuanti Management Trainee Interview Questions
- iQuanti Associate Product Manager Interview Questions
- iQuanti Senior Product Manager Interview Questions
- iQuanti Lead Analyst Interview Questions
- iQuanti SEO Analyst Interview Questions
- iQuanti Engagement Manager Interview Questions
- Show more
Interview Questions for Popular Designations
Interview Questions from Similar Companies
iQuanti Lead Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Senior Analyst
113
salaries
|  ₹6 L/yr - ₹14 L/yr |
|
Lead Analyst
51
salaries
| ₹9.8 L/yr - ₹18 L/yr |
|
Management Trainee
38
salaries
| ₹12 L/yr - ₹15.1 L/yr |
|
Analyst
37
salaries
| ₹5.2 L/yr - ₹12 L/yr |
|
Engagement Manager
35
salaries
| ₹15.3 L/yr - ₹31 L/yr |
R.R. Donnelley
Epsilon
Denave
Smollan Group
- Home >
- Interviews >
- iQuanti Interview Questions >
- iQuanti Lead Analyst Interview Questions
