i
Xoriant
Compare
Filter interviews by
Xoriant Team Member/Team Leader Interview Questions and Answers
Xoriant Team Member/Team Leader Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consultant and was interviewed in Jun 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Write a program for printing even and odd number up to 10 using two different threads. Where thread one will print only even number and thread 2 will print only odd.
- Ans.
Program to print even and odd numbers up to 10 using two threads.
Create two threads, one for even numbers and one for odd numbers.
Use a loop to iterate through numbers 1 to 10.
In each iteration, check if the number is even or odd.
If the number is even, print it using the even thread.
If the number is odd, print it using the odd thread.
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
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.
Interview Preparation Tips
- Experience
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Azure Scenario based questions
- Q2. Pyspark Coding based questions
(2 Questions)
- Q1. ADF, Databricks related question
- Q2. Spark Performance problem and scenarios
(2 Questions)
- Q1. SCD questions. Iceberg questions
- Q2. Basic python programing, pyspark architechture.
I was interviewed in Aug 2024.
(5 Questions)
- Q1. Questions on Pyspark
- Q2. Questions on SQL
- Q3. Transformations
- Q4. Questions on Sql optimizations
- Q5. Questions About my current Project
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- Q1. Incremental load in pyspark
- Ans.
Incremental load in pyspark refers to loading only new or updated data into a dataset without reloading the entire dataset.
Use the 'delta' function in pyspark to perform incremental loads by specifying the 'mergeSchema' option.
Utilize the 'partitionBy' function to optimize incremental loads by partitioning the data based on specific columns.
Implement a logic to identify new or updated records based on timestamps or uni...
- Q2. Drop duplicates
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed in Mar 2024. There were 4 interview rounds.
(1 Question)
- Q1. Based on SQL, python and Aws.
(1 Question)
- Q1. Based on Advance SQL, Python.
(1 Question)
- Q1. Some logical questions. Project overview and architecture. SQL Questions handson. Python Hands-on.
(1 Question)
- Q1. Background and projects overview.
I applied via LinkedIn and was interviewed in Jan 2024. There was 1 interview round.
(4 Questions)
- Q1. What is Pyspark?
- Ans.
Pyspark is a Python API for Apache Spark, a powerful open-source distributed computing system.
Pyspark is used for processing large datasets in parallel across a cluster of computers.
It provides high-level APIs in Python for Spark programming.
Pyspark allows seamless integration with other Python libraries like Pandas and NumPy.
Example: Using Pyspark to perform data analysis and machine learning tasks on big data sets.
- Q2. What is Pyspark SQL?
- Ans.
Pyspark SQL is a module in Apache Spark that provides a SQL interface for working with structured data.
Pyspark SQL allows users to run SQL queries on Spark dataframes.
It provides a more concise and user-friendly way to interact with data compared to traditional Spark RDDs.
Users can leverage the power of SQL for data manipulation and analysis within the Spark ecosystem.
- Q3. How to merge 2 dataframes of different schema?
- Ans.
To merge 2 dataframes of different schema, use join operations or data transformation techniques.
Use join operations like inner join, outer join, left join, or right join based on the requirement.
Perform data transformation to align the schemas before merging.
Use tools like Apache Spark, Pandas, or SQL to merge dataframes with different schemas.
- Q4. What is Pyspark streaming?
- Ans.
Pyspark streaming is a scalable and fault-tolerant stream processing engine built on top of Apache Spark.
Pyspark streaming allows for real-time processing of streaming data.
It provides high-level APIs in Python for creating streaming applications.
Pyspark streaming supports various data sources like Kafka, Flume, Kinesis, etc.
It enables windowed computations and stateful processing for handling streaming data.
Example: C...
Interview Preparation Tips
- Pyspark
Skills evaluated in this interview
I was interviewed in Jan 2024.
(2 Questions)
- Q1. What joins you used
- Ans.
I have used various types of joins including inner join, left join, right join, and full outer join.
Used inner join to retrieve records that have matching values in both tables
Utilized left join to retrieve all records from the left table and matching records from the right table
Employed right join to retrieve all records from the right table and matching records from the left table
Utilized full outer join to retrieve ...
- Q2. Write query for joins
- Ans.
Query for joins in SQL to combine data from multiple tables
Use JOIN keyword to combine data from two or more 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.id = table2.id
Skills evaluated in this interview
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
Just focus on the basics of pyspark.
Tell us how to improve this page.
Xoriant Interviews By Designations
- Xoriant Software Engineer Interview Questions
- Xoriant Senior Software Engineer Interview Questions
- Xoriant Associate Software Engineer Interview Questions
- Xoriant Senior Test Engineer Interview Questions
- Xoriant Test Lead Interview Questions
- Xoriant Software Developer Interview Questions
- Xoriant Technical Lead Interview Questions
- Xoriant Automation Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Consulting Manager Interview Questions
- Accountant Cashier Interview Questions
- Package Solution Consultant Interview Questions
- Senior Technical Lead Interview Questions
- Switch Engineer Interview Questions
- Operations Executive Interview Questions
- Cash Officer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Xoriant Team Member/Team Leader Reviews and Ratings
based on 1 review
Rating in categories
|
Software Engineer
1.7k
salaries
|  ₹3.9 L/yr - ₹16 L/yr |
|
Senior Software Engineer
1.7k
salaries
| ₹9 L/yr - ₹33 L/yr |
|
Softwaretest Engineer
626
salaries
| ₹2.8 L/yr - ₹8.7 L/yr |
|
Technical Lead
621
salaries
| ₹12 L/yr - ₹40 L/yr |
|
Senior Test Engineer
522
salaries
| ₹7.9 L/yr - ₹33 L/yr |
TCS
Infosys
Wipro
Tech Mahindra
- Home >
- Interviews >
- Xoriant Interview Questions >
- Xoriant Team Member/Team Leader Interview Questions
