Add office photos
Filter interviews by
Infiniti Research Analytics Consultant Interview Questions and Answers
Infiniti Research Analytics Consultant Interview Experiences
1 interview found
I applied via LinkedIn and was interviewed in Aug 2022. There were 4 interview rounds.
(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.
- Q2. Questions regarding Data Modelling in power bi
(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
- Q2. Questions about power bi services part
(2 Questions)
- Q1. It was about Salary discussions
- Q2. And Joining formalities
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Analytics Consultant Interview Questions & Answers
LatentView Analytics
Rahil Bandi
posted on 16 Sep 2022
Easy with 40-50 questions
Easy was for 30 minutes. Team vs Individual
(2 Questions)
- Q1. About me , About Resume
- Q2. Some SQL Questions and projects
Interview Preparation Tips
I applied via campus placement at National Institute of Technology (NIT), Warangal
1 hour aptitude test
(1 Question)
- Q1. What is one hot encoding
(1 Question)
- Q1. What is your long term goal
Selected
I applied via LinkedIn and was interviewed before Oct 2023. There were 3 interview rounds.
Basic aptitude question
(1 Question)
- Q1. Basic analysis and ML questions , more focused on approach instead of coding
(1 Question)
- Q1. As like other HR rounds
(1 Question)
- Q1. Regression, clustering
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed before Sep 2023. There were 3 interview rounds.
Simple Data Science Case Study
(1 Question)
- Q1. Python knowledge related questions
Data Science Case Study
Senior Data Analyst Interview Questions & Answers
LatentView Analytics
Anonymous
posted on 28 Apr 2024
Selected
I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Sql Based Questions on Join, CTE,Advance Functionc
- Q2. Use case study implementation of logics
- Ans.
Implementing logics in a use case study to analyze data and derive insights.
Identify the problem statement and objectives of the study
Collect relevant data and clean it for analysis
Apply statistical and machine learning techniques to derive insights
Interpret the results and communicate findings to stakeholders
Python, data manipluation, ML, SQl
Interview Preparation Tips
- SQL
- Python
- Machine Learning
Skills evaluated in this interview
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
Topics like sql, python, aptitude were covered.
(1 Question)
- Q1. Questions from stats, machine learning were asked. Behavioral questions were also covered.
Interview Preparation Tips
I applied via campus placement at Lovely Professional University (LPU) and was interviewed before May 2023. There was 1 interview round.
(2 Questions)
- Q1. Reverse a string in list
- Ans.
Reverse a string in a list of strings
Iterate through each string in the list
Use the built-in function to reverse each string
Store the reversed strings in a new list
- Q2. Explain joins in sql
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Interview Preparation Tips
Skills evaluated in this interview
Data Science Intern Interview Questions & Answers
McKinsey & Company
CodingNinjas
posted on 7 Feb 2022
I was interviewed before Feb 2021.
(1 Question)
Round duration - 90 Minutes
Round difficulty - Medium
The test is divided into 3 sections:
1. R coding.
2. Python coding. This section includes NumPy and scikit questions.
3. Statistics. This section includes T-tests, Anova regression distributions, and chi-square.
Each section has roughly 12 questions. The number of questions and difficulty is not set in advance, the test is adaptive. The more correct answers you give, the more the questions get tougher. The qualification does not depend upon the number of questions solved, rather on the difficulty level you can achive.
- Q1. Complete the Code
Complete the function to find the value in a specified categorical column with the highest average of a specified numeric column.
import pandas as pddef category_avg(df, cat_column, num_col...
- Ans.
The function finds the value in a specified categorical column with the highest average of a specified numeric column.
Use the groupby() function in pandas to group the data by the categorical column
Calculate the average of the numeric column for each group
Find the group with the highest average and return the corresponding value from the categorical column
(1 Question)
Round duration - 60 Minutes
Round difficulty - Hard
- Q1. Rotate matrix by 90 degrees
You are given a square matrix of non-negative integers 'MATRIX'. Your task is to rotate that array by 90 degrees in an anti-clockwise direction using constant extra spac...
- Ans.
The task is to rotate a square matrix by 90 degrees in an anti-clockwise direction using constant extra space.
Iterate through each layer of the matrix from outer to inner
For each layer, perform a four-way swap of elements
Continue this process until all layers have been rotated
(1 Question)
Round duration - 30 Minutes
Round difficulty - Medium
- Q1. Basic HR Questions
How was your interview experience so far?
Why do you want to join us?
Are you a leader or a follower? - Ans.
Answering basic HR questions in a data science intern interview.
My interview experience so far has been positive and informative.
I want to join your company because of its reputation in the data science field and the opportunity to work on challenging projects.
I consider myself a leader as I have successfully led a team in a previous project.
I believe in taking initiative and guiding others towards achieving common goa...
Interview Preparation Tips
Tip 1 : Have in-depth knowledge of data-frame manipulation using Pandas
Tip 2 : Learn all NumPy array methods
Tip 3 : Good working knowledge about Scikit Learn
Tip 1 : Have 2-3 good projects on Machine Learning or Data Science preferably in Python.
Tip 2 : List only those skills which you are good at.
Skills evaluated in this interview
Infiniti Research Interview FAQs
Tell us how to improve this page.
Infiniti Research Interviews By Designations
- Infiniti Research Research Analyst Interview Questions
- Infiniti Research Research Associate Interview Questions
- Infiniti Research Senior Research Associate Interview Questions
- Infiniti Research Software Engineer Interview Questions
- Infiniti Research Analytics Consultant Interview Questions
- Infiniti Research Assistant Technician Interview Questions
- Infiniti Research Associate Product Manager Interview Questions
- Infiniti Research Content Writer Interview Questions
- Show more
Interview Questions for Popular Designations
- Analytics Manager Interview Questions
- Decision Analytics Associate Interview Questions
- Senior Analytics Consultant Interview Questions
- Data Scientist Interview Questions
- Analytics Specialist Interview Questions
- Senior Manager Analytics Interview Questions
- Analytics Executive Interview Questions
- Senior Data Analyst Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
Infiniti Research Analytics Consultant Reviews and Ratings
based on 6 reviews
Rating in categories
|
Research Associate
198
salaries
|  ₹2 L/yr - ₹6.2 L/yr |
|
Senior Research Associate
111
salaries
| ₹3.5 L/yr - ₹8.6 L/yr |
|
Research Analyst
100
salaries
| ₹3.2 L/yr - ₹9.7 L/yr |
|
Software Engineer
59
salaries
| ₹3.5 L/yr - ₹10.5 L/yr |
|
Analyst
55
salaries
| ₹4 L/yr - ₹10.2 L/yr |
Frost & Sullivan
McKinsey & Company
BCG
Gartner
Calculate your in-hand salary
- Home >
- Interviews >
- Infiniti Research Interview Questions >
- Infiniti Research Analytics Consultant Interview Questions
