Hitachi Consulting Interview Questions and Answers

Q1. What are the key topics related to Generative AI, specifically focusing on Retrieval-Augmented Generation (RAG) and Large Language Models (LLM)?
Add your answer
Q2. What is your understanding of the existing project and the technology stacks used?
Add your answer

Q1. What has been your contribution to existing work and the technologies used in that context?
Add your answer
Q2. ML, DL, Gen AI implementation and flow
Add your answer
Q3. Python Coding logic and semantics
Add your answer

Q1. What are the existing work challenges you face, and what solutions have you implemented to address them?
Add your answer
Q2. What is your understanding of Generative AI and Natural Language Processing (NLP), and can you provide examples of their use cases?
Add your answer

I got several invitation calls from 3 different persons for the same interview at Xebia Bangalore Brigade office.I attended an interview at Xebia on January 11, 2025, and the experience was disappointing. Despite reading several negative reviews beforehand, I chose to give the company a fair chance, but unfortunately, the concerns expressed in those reviews turned out to be valid.

From the very beginning, the process was poorly managed. I waited for over three hours before being called, while candidates who arrived after me were invited for their interviews earlier. This inconsistency immediately raised questions about the fairness of their process.

When my turn finally came, the interview began with a moderately challenging SQL question: I was asked to fetch all invalid December month transaction IDs (which is coming in ooo hours) from a dataset, applying conditions such as working hours from Monday to Friday (9 AM to 4 PM), excluding weekends and specific holidays (24th and 25th December). While I attempted to solve this, the interviewer interrupted repeatedly with casual, unrelated remarks. These interruptions disrupted my concentration and added unnecessary pressure, making it difficult to focus on solving the query effectively.

Following this, the interviewer moved to a Python question, which involved determining whether a given number was a perfect square. Although the problem itself was simple, it included irrelevant details, such as pre-imported libraries in a web-based IDE. This added an unnecessary layer of complexity and confusion. Again, the interviewer’s interruptions and casual talk distracted me further. Instead of focusing on assessing my logic and problem-solving skills, he seemed more interested in making irrelevant comments.

What stood out most negatively was the interviewer’s unprofessional behavior. At one point, he made an inappropriate remark about my name, comparing it to his own, which he claimed was not as "weighted."
I asked his name politely and he replied " Vaibhav Gupta"

While I attempted to steer the conversation back to technical discussions, his attitude remained dismissive and unfocused. He even questioned my leadership skills but turned it into an argument instead of allowing me to explain.

I also noticed disparities in how candidates were treated. For instance, a female candidate before me was given over an hour for her interview, while mine felt rushed and dismissive. While this is my personal observation, it raised concerns about bias in their evaluation process.

The interview ended abruptly and on a negative note. When I tried to discuss architectural patterns for data pipelines, the interviewer dismissed my points outright, stating that they did not need data architects. Without providing proper closure, he left the room, leaving me feeling disrespected and undervalued.

Overall, the experience was frustrating and insulting. The interviewer’s behavior was unprofessional and dismissive, and the process lacked the basic respect and fairness expected in a professional setting. Based on my experience, I strongly believe that Xebia needs to overhaul their interview practices, ensuring a more structured, unbiased, and respectful approach toward candidates.

I am relieved I was not selected, as this experience highlighted what could likely be a toxic work environment. I would not recommend Xebia to anyone, as their lack of professionalism and courtesy reflects poorly on their organizational culture.

Q1. HTML, CSS fundamentals
Add your answer
Q2. Javascript event loop and array methods
Add your answer
Q3. Javascript coding for operation on object array
Add your answer
Q4. React benefits and Redux implementations
Add your answer
Q5. How to create slice and combine reducers
Add your answer

Q1. Questions based on projects, role, responsibilities and initiative at work place
Add your answer
Q2. How to create and optimize a react application
Add your answer

Q1. Day to day activity of workplace and salary negotiation
Add your answer

Q1. Given an array of non-negative integers.Find the length of the longest subsequence such that elements in the subsequence are contiguous integers. The consecutive numbers can be in any order. Example n=7 nu...read more
Ans. 
Find the length of the longest subsequence of contiguous integers in an array.
• Sort the array

• Iterate through the array and check for consecutive integers

• Keep track of the longest subsequence found
Answered by AI
Add your answer
Q2. Get list of pincodes from these objects Employee{ id Long, name String, Addresses : List
} Addresses{ houseNo long, pindcode long, state String, country String, } Ans. Use flatMap to flatten and then use m...read more
Ans. 
Use flatMap and map to extract list of pincodes from Employee objects
• Use flatMap to flatten the list of Addresses in each Employee object

• Use map to iterate over the flattened list and extract the pincodes

• Example: employeeList.stream().flatMap(emp -> emp.getAddresses().stream()).map(address -> address.getPincode()).collect(Collectors.toList())
Answered by AI
Add your answer
Q3. What is Database Pooling, Hikari and its configurations. Java 8 to current enchancements and current java version Factory and Builder design patterns to explain and code Project expalantion and details, Cr...read more
Ans. 
Database pooling is a technique used to manage a pool of database connections for efficient resource utilization. HikariCP is a popular database connection pooling library in Java.
• HikariCP is a high-performance database connection pooling library for Java applications.

• It is known for its low latency and high throughput.

• Configurations for HikariCP include settings such as maximum pool size, connection timeout, and idle ...read more
Answered by AI
Add your answer

Q1. Types of job in kotlin coroutine
Ans. 
Types of jobs in Kotlin coroutine include launch, async, withContext, and runBlocking.
• launch: starts a new coroutine without blocking the current thread

• async: starts a new coroutine and returns a Deferred object with a result

• withContext: switches the coroutine context within a coroutine

• runBlocking: blocks the current thread until the coroutine inside it is completed
Answered by AI
Add your answer
Q2. What is Flow, Channel diffrent between StateFlow and SharedFlow
Ans. 
Flow is a cold asynchronous data stream, Channel is a hot asynchronous data stream. StateFlow is a hot asynchronous data stream with a state, SharedFlow is a hot asynchronous data stream without a state.
• Flow is a cold asynchronous data stream that emits values one by one.

• Channel is a hot asynchronous data stream that can have multiple subscribers.

• StateFlow is a hot asynchronous data stream that retains the most recent ...read more
Answered by AI
Add your answer
Q3. If Flow lifecycle aware
Ans. 
Flow lifecycle aware means using Kotlin Flow with lifecycle awareness in Android development.
• Flow lifecycle aware helps manage data streams in Android apps

• It ensures that data emissions are only observed when the lifecycle is in the appropriate state

• Example: Using Flow with LiveData to update UI components based on lifecycle events
Answered by AI
Add your answer
Q4. What is inline function and highorder function?
Ans. 
Inline functions are functions that are expanded in place at the call site, while high-order functions are functions that can take other functions as parameters or return them.
• Inline functions are expanded in place at the call site to improve performance.

• High-order functions can take other functions as parameters or return them.

• Example of high-order function: map() function in Kotlin.
Answered by AI
Add your answer

Q1. Tableau Questions 1. Difference between dimensions and measures. 2. What is RLS? 3. What are the functions you can assign in RLS? 4. Explain what is drill down approach. 5. What is LOD? 6. What is a calcul...read more
Add your answer
Q2. SQL Questions 1. In employee table find the 2nd highest salary. 2. Find the highest average salary in department 3. Given two tables(sales & product) find total sales per category 4. Two questions to find ...read more
Add your answer