Upload Button Icon Add office photos

Filter interviews by

AMD Consulting Data Analytics Consultant Interview Questions and Answers

Updated 23 Jun 2024

AMD Consulting Data Analytics Consultant Interview Experiences

1 interview found

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

(1 Question)

  • Q1. What is difference between vloockup and vloockup
  • Ans. 

    VLOOKUP and HLOOKUP are both Excel functions used to search for a value in a table, but VLOOKUP searches vertically while HLOOKUP searches horizontally.

    • VLOOKUP stands for vertical lookup and searches for a value in the first column of a table and returns a value in the same row from a specified column.

    • HLOOKUP stands for horizontal lookup and searches for a value in the first row of a table and returns a value in the sa...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What is time series?
  • Ans. 

    Time series is a sequence of data points collected at regular time intervals, used to analyze trends and patterns over time.

    • Time series data is ordered chronologically

    • Commonly used in forecasting future values based on past patterns

    • Examples include stock prices, weather data, and sales figures

  • Answered by AI
  • Q2. How do you handle missing values in dataset?
  • Ans. 

    Handle missing values using techniques like imputation, deletion, or modeling.

    • Use imputation techniques like mean, median, mode for numerical data

    • For categorical data, use mode or create a new category for missing values

    • Consider using advanced techniques like KNN imputation or predictive modeling

    • Delete rows or columns with high percentage of missing values if appropriate

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - NA

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Group Discussion 

One as two people are together discussion then it will be very good

Round 2 - One-on-one 

(5 Questions)

  • Q1. Yes it very well by one-one round
  • Q2. It's little question by person
  • Q3. How many types are doing this job
  • Q4. How many types I receive payment
  • Ans. 

    There are multiple types of payment methods that can be received.

    • Cash

    • Credit card

    • Debit card

    • Online payment

    • Bank transfer

  • Answered by AI
  • Q5. Do I skip that very critically situation.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in May 2024. There were 6 interview rounds.

Round 1 - Aptitude Test 

Aptitude and Reasoning

Round 2 - Group Discussion 

Describe a topic of our routine life

Round 3 - HR 

(2 Questions)

  • Q1. How can I get this job in easy way?
  • Q2. Is there any work from home jobs available?
Round 4 - Assignment 

Submit the project assignment

Round 5 - One-on-one 

(2 Questions)

  • Q1. How to interact with oni on one?
  • Ans. 

    Interacting with one on one involves clear communication, active listening, and building rapport.

    • Maintain eye contact to show attentiveness

    • Ask open-ended questions to encourage conversation

    • Practice active listening by paraphrasing and summarizing what the other person says

    • Show empathy and understanding towards their perspective

    • Build rapport by finding common ground or shared interests

  • Answered by AI
  • Q2. Is there any salary increments?
Round 6 - Technical 

(1 Question)

  • Q1. Take a test by computer skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Iam very eager to join with cognizant.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Not Selected

I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Questions was related to python only

Round 2 - Technical 

(5 Questions)

  • Q1. The 2nd round was for 15 min my interview was at 11 but interviewer didn't came i was waiting for 2-3 hrs then i leave meeting and after that i got mail that i am having interview at 5 pm then again i join...
  • Q2. What is garbage collector in java?
  • Ans. 

    Garbage collector in Java is a program that automatically manages memory by reclaiming unused memory.

    • Garbage collector is a part of Java Virtual Machine (JVM) responsible for automatic memory management.

    • It identifies and deletes objects that are no longer reachable or needed by the program.

    • Garbage collection helps prevent memory leaks and improves performance by freeing up memory for new objects.

    • Examples of garbage col...

  • Answered by AI
  • Q3. What is inheritance?
  • Ans. 

    Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.

    • Allows for code reusability and promotes a hierarchical structure

    • Derived class inherits properties and behaviors from a base class

    • Can have multiple levels of inheritance

    • Example: Class 'Dog' can inherit from class 'Animal' and inherit attributes like 'name' and methods like 'eat()'

  • Answered by AI
  • Q4. Difference between sql and non sql database?
  • Ans. 

    SQL databases are relational databases that use structured query language, while NoSQL databases are non-relational and do not use SQL.

    • SQL databases are table-based and have a predefined schema, while NoSQL databases are document-based, key-value pairs, graph databases, or wide-column stores.

    • SQL databases are good for complex queries and transactions, while NoSQL databases are better for hierarchical data storage.

    • Examp...

  • Answered by AI
  • Q5. What is graphical data?
  • Ans. 

    Graphical data refers to data that is represented visually through graphs, charts, or other visualizations.

    • Graphical data helps in easily interpreting trends, patterns, and relationships within the data.

    • Common types of graphical data include bar graphs, pie charts, line graphs, and scatter plots.

    • It is often used in data analytics to communicate insights and findings effectively to stakeholders.

    • Graphical data can be cre...

  • Answered by AI

Skills evaluated in this interview

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

(1 Question)

  • Q1. Python questions

I applied via Company Website and was interviewed in Sep 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 - Coding Test 

Basic coding questions such as Fibonacci series and Minimum odd integer in a list. SQL questions based on window functions and tableau theoretical questions

Round 3 - Aptitude Test 

A common English speaking test

Round 4 - HR 

(4 Questions)

  • Q1. Why do you want to join deloitte
  • Q2. Salary expectations and reason for leaving current company
  • Q3. What was your salary when you started working and how much it has changed since then
  • Q4. How will you resolve conflict within your team if there's a critical deadline

Interview Preparation Tips

Topics to prepare for Deloitte Analytics Specialist interview:
  • Python
  • SQL
  • Tableau
  • Team Management
  • Interpersonal Skills
Interview preparation tips for other job seekers - Try to have some solid reasons if your salary has taken massive jumps in recent times. My package went from 3.5 LPA to 28 LPA in a span of 3.5 years which irked the interviewer in the final HR round and that's why after all the good efforts in earlier rounds I was not selected.

I applied via campus placement at Shri SSVPSs BNSP Arts and Commerce College, Dhule and was interviewed in Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

Aptitude tests are often used to assess academic potential or career suitability and may be used to assess either mental or physical talent in a variety of domains.

Round 3 - Aptitude Test 

Coding testIn this Tutorial, we have Provided the Most Common Coding Interview Questions & Answers with Program Logic & Code Examples for you to Practice Programming:

Round 4 - Coding Test 

Programming tests to help you hire better developersWhat is a Coding Challenge?If you are looking to land one such job, it is important that you are well-prepared for these challenges.

Interview Preparation Tips

Topics to prepare for TCS IT (Data Analytics) interview:
  • Tableau
Interview preparation tips for other job seekers - We are all aware that answering the most basic coding or programming interview questions determines how we perform in an interview. The interview may be for Java, C++, or a Javascript requirement, but the basis remains the same, that is how strong we are in the foundations of programming logic.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Jan 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. What do you mean by women empowerment?
  • Ans. 

    Women empowerment refers to the process of providing women with the power and resources to make their own decisions and control their own lives.

    • It involves creating an environment where women can participate equally in all aspects of life

    • It includes providing access to education, healthcare, and economic opportunities

    • It also involves challenging gender stereotypes and promoting gender equality

    • Examples include initiativ...

  • Answered by AI
  • Q2. What was the most memorable day in your school life

Interview Preparation Tips

Interview preparation tips for other job seekers - improve communication skill, improve typing skill, positive attitude, leadership these are the qualities which are required for this job role.

I applied via Company Website and was interviewed in Jan 2021. There were 6 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. What are your views on Amazon Services?
  • Ans. 

    Amazon Services is a comprehensive platform offering a wide range of products and services.

    • Amazon Services provides an extensive selection of products, including electronics, books, clothing, and more.

    • It offers various services such as Amazon Prime, Amazon Web Services (AWS), and Amazon Marketplace.

    • Amazon Services has revolutionized e-commerce and logistics, providing fast and reliable delivery options.

    • The platform als...

  • Answered by AI
  • Q2. Which leadership principle you should focus on in order to improve the experiences?
  • Q3. What are the major changes you led in your roles at previous organization?
  • Q4. What are the callemges faced while making the changes?
  • Q5. How do you categorize thinking and obtaining views from a different person?
  • Q6. What could be your opinion to improve this interview?

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be confident and ready to answer quirky questions that you can only answer with a self review. We at Amazon always focus on the leadeship principle as they serve as major goals to achieve at every work we do. If you can relate any work to the goals we serve to, you would sound goal oriented, druven and passionate towards the work.

AMD Consulting Interview FAQs

How many rounds are there in AMD Consulting Data Analytics Consultant interview?
AMD Consulting interview process usually has 1 rounds. The most common rounds in the AMD Consulting interview process are Technical.

Tell us how to improve this page.

AMD Consulting Data Analytics Consultant Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.9
 • 8.1k Interviews
Infosys Interview Questions
3.7
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
View all
Compare AMD Consulting with

TCS

3.7
Compare

Accenture

3.9
Compare

Cognizant

3.8
Compare

Infosys

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