Upload Button Icon Add office photos

Filter interviews by

Infiniti Research Analytics Consultant Interview Questions and Answers

Updated 9 Aug 2023

Infiniti Research Analytics Consultant Interview Experiences

1 interview found

I applied via LinkedIn and was interviewed in Aug 2022. There were 4 interview rounds.

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. Types of Joins in SQL
  • Ans. 

    Types of joins in SQL include inner join, left join, right join, and full outer join.

    • 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 either table.

  • Answered by AI
  • Q2. Questions regarding Data Modelling in power bi
Round 3 - Technical 

(2 Questions)

  • Q1. Explain about static and dynamic RLS
  • Ans. 

    Static RLS restricts access based on predefined rules, while dynamic RLS adjusts access based on user attributes or context.

    • Static RLS uses fixed rules to control access to data

    • Dynamic RLS adjusts access based on user attributes or context

    • Static RLS example: Only managers can view salary information

    • Dynamic RLS example: Employees can only access data for their own department

  • Answered by AI
  • Q2. Questions about power bi services part
Round 4 - HR 

(2 Questions)

  • Q1. It was about Salary discussions
  • Q2. And Joining formalities

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare on ur concepts and especially whatever u have used in ur resume u need to be aware of it

Skills evaluated in this interview

Analytics Consultant Jobs at Infiniti Research

View all

Interview questions from similar companies

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 - Aptitude Test 

Easy with 40-50 questions

Round 3 - Group Discussion 

Easy was for 30 minutes. Team vs Individual

Round 4 - Technical 

(2 Questions)

  • Q1. About me , About Resume
  • Q2. Some SQL Questions and projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through your basics well for the technical interview

I applied via Company Website and was interviewed in May 2022. There were 7 interview rounds.

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 - Aptitude Test 

This aptitude + technical MCQ test was of 120 minutes in duration. Had MCQs on quantitative ability, logical ability, Language, and technical MCQs consisted of questions on DBMS, OS, Networks, DSA. There were two coding questions as well. One on Bit Manipulating, and the other on DFS.

Round 3 - One-on-one 

(1 Question)

  • Q1. A question on BFS very similar to Leetcode 924. Was given one hour to discuss and come to an optimized solution with the interviewer.
Round 4 - Technical 

(4 Questions)

  • Q1. Search an element in a sorted and rotated array
  • Ans. 

    Search an element in a sorted and rotated array

    • Find the pivot point where the array is rotated

    • Divide the array into two sub-arrays based on pivot point

    • Perform binary search on the appropriate sub-array

  • Answered by AI
  • Q2. SQL query on left join
  • Q3. Questions on CPP memory management
  • Q4. Questions related to projects done
Round 5 - Technical 

(2 Questions)

  • Q1. Propose a system for a popular media stream service
  • Ans. 

    Proposed system for a popular media stream service

    • Implement a recommendation engine to suggest content based on user preferences and viewing history

    • Integrate with social media platforms to allow users to share and discuss content

    • Provide multiple subscription options with varying levels of access and features

    • Ensure high-quality streaming with minimal buffering through the use of content delivery networks

    • Implement robust...

  • Answered by AI
  • Q2. Questions related to Fullstack Tech Stacks
Round 6 - Case Study 

Guesstimate on number of Reddit users in India. No starting input was given. Gave solution by using bottom to top approach. Tried to focus on quantifying teenagers with internet access and a particular interest about internet. Gave a figure around ~1 million in a year.

Round 7 - HR 

(1 Question)

  • Q1. Where do you see yourself at McKinsey?

Interview Preparation Tips

Topics to prepare for McKinsey & Company Software Engineer interview:
  • DSA
  • DBMS
  • Web Development
Interview preparation tips for other job seekers - Show leadership potential. Be honest. They are smart, they are McKinsey, they know what's what. If appearing for software profile, the preparation is no different from what's needed for other companies. They are highly selective. Rest assured; it will be good experience, keep your head up.

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Aug 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Polymorphism and a function to randomize a pack of cards
  • Ans. 

    Polymorphism can be used to create a Card class with different types of cards. A function can then use polymorphism to randomize the pack.

    • Create a Card class with different types of cards as subclasses

    • Implement a function that creates a pack of cards using polymorphism to add different types of cards

    • Use a random number generator to shuffle the pack

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be good with OOPs concepts and you are good to go

I applied via Approached by Company and was interviewed before Jul 2021. There were 7 interview rounds.

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 - HR 

(1 Question)

  • Q1. Basic question about qualification about experience suitable for role or not
Round 3 - Technical 

(3 Questions)

  • Q1. Oops concepts should be strong.
  • Q2. Strong knowledge with c#
  • Q3. Asp .net, MVC, web APIs, .net core .
Round 4 - Technical 

(1 Question)

  • Q1. Senior lead will take this round and deep knowledge of technology
Round 5 - One-on-one 

(1 Question)

  • Q1. Manager round with skills and experience
Round 6 - One-on-one 

(1 Question)

  • Q1. International call one to one
Round 7 - HR 

(1 Question)

  • Q1. Final discussion for salary and all

Interview Preparation Tips

Topics to prepare for Aristocrat Technologies Software Engineer interview:
  • OOPS
  • C#.Net
  • ASP.Net
  • ASP.Net MVC
  • Web Api
  • .Net Core
Interview preparation tips for other job seekers - Technical should be strong .
Oops concepts must be clear .
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 - Coding Test 

Two easy questions two wasy questions two easy questions two easy questions

Round 3 - Technical 

(2 Questions)

  • Q1. Technical interviews was very easy techijcal interviews was very easy very easy very easy
  • Q2. Interviews was conducted in advance of a news conference in the United Kingdom and the European government on Tuesday

Interview Preparation Tips

Interview preparation tips for other job seekers - Ghar was the second man killed by an twowwywiwywuw The new rules would be similar y
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Jul 2024.

Round 1 - Coding Test 

Leet code medium level question

Round 2 - Technical 

(2 Questions)

  • Q1. About Java Streams
  • Q2. Restful API coding completion based on given file
Round 3 - HR 

(2 Questions)

  • Q1. To check your attitude
  • Q2. Given detailed about company and what project you are going to work on?
Round 4 - One-on-one 

(5 Questions)

  • Q1. Hashmap working
  • Ans. 

    Hashmap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.

    • Hashmap uses a hashing function to map keys to indices in an array.

    • It allows for constant time complexity O(1) for insertion, deletion, and retrieval operations.

    • Example: HashMap<String, Integer> map = new HashMap<>(); map.put("key", 123); int value = map.get("key");

  • Answered by AI
  • Q2. Multithreading cases
  • Q3. Scenario specific on how to handle multiple events on a single variable to have accurate result
  • Q4. Database indexing
  • Q5. Architecture level
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

1 coding question, and basic MCQ

I applied via Referral and was interviewed in Aug 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Find k min elements in given array.
  • Ans. 

    Find k min elements in given array.

    • Sort the array and return the first k elements.

    • Use a min heap of size k to find the k min elements.

    • Use quickselect algorithm to find the kth smallest element and return first k elements smaller than it.

  • Answered by AI
  • Q2. Find that given tree is BST or not.
  • Ans. 

    Check if a given tree is a Binary Search Tree (BST) or not.

    • Traverse the tree in-order and check if the elements are in ascending order.

    • Check if the maximum value in the left subtree is less than the root and the minimum value in the right subtree is greater than the root.

    • Use recursion to check if all subtrees are BSTs.

    • Time complexity: O(n), Space complexity: O(h) where h is the height of the tree.

  • Answered by AI
  • Q3. Find pair in BST with given sum
  • Ans. 

    Given a BST and a sum, find a pair of nodes whose values add up to the given sum.

    • Traverse the BST in-order and store the nodes in a list

    • Use two pointers approach to find the pair with the given sum

    • If the sum is less than the current pair, move the right pointer to the left

    • If the sum is greater than the current pair, move the left pointer to the right

    • If the sum is equal to the current pair, return the pair

    • Time complexit

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was Focused on DS Algo mostly.
2 technical round ( DS Algo)
1 managerial round ( General past working experiences questions)

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected

I appeared for an interview before Apr 2023.

Round 1 - Assignment 

Simple basic application

Round 2 - Technical 

(3 Questions)

  • Q1. Technical knowledge and some more personal information
  • Q2. Related to framework and api part
  • Q3. Php laravel question
Round 3 - HR 

(1 Question)

  • Q1. Final round with salary negotiation

Infiniti Research Interview FAQs

How many rounds are there in Infiniti Research Analytics Consultant interview?
Infiniti Research interview process usually has 4 rounds. The most common rounds in the Infiniti Research interview process are Technical, Resume Shortlist and HR.
How to prepare for Infiniti Research Analytics Consultant 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 Infiniti Research. The most common topics and skills that interviewers at Infiniti Research expect are SQL, Data Analytics, Data Modeling, Machine Learning and Python.
What are the top questions asked in Infiniti Research Analytics Consultant interview?

Some of the top questions asked at the Infiniti Research Analytics Consultant interview -

  1. Explain about static and dynamic ...read more
  2. Types of Joins in ...read more
  3. Questions regarding Data Modelling in power...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Chegg Interview Questions
4.1
 • 156 Interviews
CMA CGM Interview Questions
3.9
 • 92 Interviews
Sigmoid Interview Questions
3.3
 • 59 Interviews
Knorr-Bremse Interview Questions
3.9
 • 56 Interviews
Aristocrat Interview Questions
3.9
 • 46 Interviews
View all
Infiniti Research Analytics Consultant Salary
based on 42 salaries
₹5.1 L/yr - ₹21.6 L/yr
14% less than the average Analytics Consultant Salary in India
View more details

Infiniti Research Analytics Consultant Reviews and Ratings

based on 8 reviews

1.8/5

Rating in categories

2.0

Skill development

2.2

Work-life balance

2.1

Salary

2.0

Job security

1.8

Company culture

1.9

Promotions

1.8

Work satisfaction

Explore 8 Reviews and Ratings
Research Associate
179 salaries
unlock blur

₹2 L/yr - ₹7 L/yr

Research Analyst
109 salaries
unlock blur

₹3.2 L/yr - ₹9.8 L/yr

Senior Research Associate
108 salaries
unlock blur

₹3.5 L/yr - ₹8.6 L/yr

Senior Software Engineer
57 salaries
unlock blur

₹4.7 L/yr - ₹12.3 L/yr

Analyst
55 salaries
unlock blur

₹4 L/yr - ₹10.2 L/yr

Explore more salaries
Compare Infiniti Research with

Chegg

4.1
Compare

CMA CGM

3.9
Compare

Tekwissen

4.8
Compare

Nasser S. Al Hajri Corporation

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