Add office photos
Filter interviews by
Xpans IT Services Interview Questions and Answers
Updated
3 May 2019
1 interview found
Sort by:
Popular
6 Interview Rounds
Interview Questions
- Q1. Basics about your work and practice experience discussion and also about you future plan and communication skill
Add Answer
- Q2. My communication skill they have checked and confidence level and also my subject. Knowledge for which position I am apply for
Add Answer
- Q3. Related to your practical work and current requirement the question will be asked
Add Answer
Interview Preparation Tips
Round: Skype interview or face to face
Experience: Final discuss in conclusion of all other rounds
Experience: Final discuss in conclusion of all other rounds
Interview questions from similar companies
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Walk-in and was interviewed in May 2024.
3 Interview Rounds
1
Aptitude Test Round
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
2
HR Round (2 Questions)
- Q1. Self introduction Add Answer
- Q2. Okay with the SLA View Answers (1)
3
Technical Round (7 Questions)
- Q1. What is the difference between DDL and DML? View Answers (1)
- Q2. How to fetch a employee record with the second highest salary from the employees table? Add Answer
- Q3. What was one of the trickiest incident you have faced and how did you counter it? Add Answer
- Q4. How SQL is divided? View Answers (1)
- Q5. How would prepare an emplyees attendance record? Create charts and graphs regarding it. View Answers (1)
- Q6. Difference between SQL and MYSQL View Answers (1)
- Q7. Define joins using examples. View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Got the invite through naukri.com
On day 1 there were 3 rounds.
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
2nd round was HR round where resume related questions like qualification and projects are asked along with a basic question of interest in this field. This round will be of 5 to 15 minutes max.
3rd round was technical round where questions related to the technical expertise is asked. This round is a bit tough but if prepared well in advanced can be done easily. This round will last upto somewhere around 30 to 45 mins on an avg.
All the rounds were of basic level but the wait time is more as there were many candidates for the post.
Tip: prepare well with basic SQL queries as they are mostly asked and if answered well gives an advantage.
After these three rounds was asked to wait for 1 week for the results.
Qs
1. What is the difference between DDL and DML?
2. How to fetch a employee record with the second highest salary from the employees table?
3. What was one of the trickiest incident you have faced and how did you counter it?
4. How SQL is divided?
5. Difference between SQL and MYSQL
6. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
7. Define SQL set using some examples.
8. Define joins using examples.
9. What is a constraint?
10. What is primary key?
11. What is foreign key?
12. What is tableau?
13. How tableau connection is established?
14. How many types of filters are there in tableau?
15. How KPI metrics can be depicted in tableau?
16. How dashboards are made?
17. What is the difference between dashborading and report generation?
18. What is storytelling?
19. Difference between Power BI and tableau
20. Which one do you prefer tableau or Power BI and why?
21. Data types in SQL
On day 1 there were 3 rounds.
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
2nd round was HR round where resume related questions like qualification and projects are asked along with a basic question of interest in this field. This round will be of 5 to 15 minutes max.
3rd round was technical round where questions related to the technical expertise is asked. This round is a bit tough but if prepared well in advanced can be done easily. This round will last upto somewhere around 30 to 45 mins on an avg.
All the rounds were of basic level but the wait time is more as there were many candidates for the post.
Tip: prepare well with basic SQL queries as they are mostly asked and if answered well gives an advantage.
After these three rounds was asked to wait for 1 week for the results.
Qs
1. What is the difference between DDL and DML?
2. How to fetch a employee record with the second highest salary from the employees table?
3. What was one of the trickiest incident you have faced and how did you counter it?
4. How SQL is divided?
5. Difference between SQL and MYSQL
6. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
7. Define SQL set using some examples.
8. Define joins using examples.
9. What is a constraint?
10. What is primary key?
11. What is foreign key?
12. What is tableau?
13. How tableau connection is established?
14. How many types of filters are there in tableau?
15. How KPI metrics can be depicted in tableau?
16. How dashboards are made?
17. What is the difference between dashborading and report generation?
18. What is storytelling?
19. Difference between Power BI and tableau
20. Which one do you prefer tableau or Power BI and why?
21. Data types in SQL
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Hard
Duration
2-4 weeks
Result
Selected
I applied via Referral and was interviewed in May 2024.
5 Interview Rounds
1
HR Round (3 Questions)
- Q1. Tell me about yourself? Add Answer
- Q2. Why did you living your current organization? Add Answer
- Q3. What is your expected CTC? View Answers (1)
2
One-on-one Round (7 Questions)
- Q1. Tell me about yourself? View Answers (1)
- Q2. Why did you living your current organization? Add Answer
- Q3. How did you manage the night shift and traveling? View Answers (1)
- Q4. What do you know about the EXL? View Answers (1)
- Q5. What is Insurance? View Answers (1)
- Q6. What do you know about the premium? View Answers (1)
- Q7. What is your current CTC and expectation? View Answers (1)
3
Aptitude Test Round
Aptitude test to check grammar and English fluency. It has different types of questions like passage reading and give the answers of questions from the passage, email writing, essay, grammar sections with fill in the blanks and picture based scenario in which you have to write the steps.
4
Typing Test Round (2 Questions)
- Q1. Speed minimum 30. Add Answer
- Q2. Accuracy minimum 90 percent. Add Answer
5
HR Round (2 Questions)
- Q1. Discussion about the salary. Add Answer
- Q2. Fixing the package. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - When I was cleared my all round of interview and then HR comes to me and said 'congratulations you are selected ' and please come tomorrow for the documentation. Tomorrow the HR assign me the task of assessment, that was not acceptable 😑 because I was cleared my all round off interview and they told me to come for the documentation. On the last day I was resigned my last company because I got selected. But this situation is very difficult for me whether I failed assessment then they reject me. I did my assessment and have cleared 🙌 and then they told me for typing test which results is passes and then they started the documentation. It takes approx 21 days to get offer letter.
Interview experience
Poor
Difficulty level
Hard
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Oct 2024.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. The Knowledge and Skills Add Answer
2
Technical Round (1 Question)
- Q1. The interviewer asked about the process, which differs from company to company. As my current company does not follow the process, the interviewer rejected me. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Go through the companies that see the candidates' knowledge, experience, and skills rather than the bookies' knowledge and processes.
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Referral and was interviewed in Nov 2024.
2 Interview Rounds
1
One-on-one Round (1 Question)
- Q1. Can implicit and explicit waits be used within the framework? View Answers (1)
2
HR Round (1 Question)
- Q1. What are your professional aspirations? View Answers (1)
Mohammad Zain Shaikh
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Sep 2024.
5 Interview Rounds
1
Coding Test Round
Easy Level DS Questions - 30 mins
2
Technical Round (2 Questions)
- Q1. Cloud Services related questions Add Answer
- Q2. ETL Based question Add Answer
3
Coding Test Round
A comprehensive coding test which included job role simulation.
4
Coding Test Round
Advanced Cloud Services questions
5
HR Round (2 Questions)
- Q1. Introduce yourself View Answers (1)
- Q2. Why did you leave your last organisation Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Remote work although partially supported, is highly discouraged.
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Campus Placement and was interviewed in Jul 2024.
3 Interview Rounds
1
Coding Test Round
Full c concept MCQ with IQ and Computaional Thinking
2
Technical Round (2 Questions)
- Q1. Number system convertion in c View Answers (1)
- Q2. Pointers, struct, Data Structure Add Answer
3
One-on-one Round (2 Questions)
- Q1. Decimal to Binary Convertion Add Answer
- Q2. Hexa Decimal to Binary convertion Add Answer
Skills evaluated in this interview
Virtual Relationship Manager Interview Questions
Plada Infotech Services
Anonymous
posted on 2 Sep 2024
Interview experience
Bad
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Walk-in
1 Interview Round
1
One-on-one Round (2 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Why do you want to join View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Very bad experience till date.. no response from the employer for any kind of queries. No formal documents are provided for company policies. Misleaded on the interview.
Interview experience
Average
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in May 2024.
3 Interview Rounds
1
Assignment Round
1. Excel Test and preparation of Cash flow.
2. Prepare a financial Model on any company of our choice.
2
Technical Round (3 Questions)
- Q1. Explain the work flow in current company? Add Answer
- Q2. Walk me through your resume? Add Answer
- Q3. Explain how you made financial model in detail. View Answers (1)
3
HR Round (3 Questions)
- Q1. Walk me through you resume? Add Answer
- Q2. Why are you looking for a job change? Add Answer
- Q3. What is your expected salary? Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Just explain the assignment in well defined manner.
Interview experience
Poor
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Jul 2024.
2 Interview Rounds
1
Group Discussion Round
JAM just introduce yourself or speak on sometime topic shared
2
Aptitude Test Round
English knowledge pen n paper
Interview Preparation Tips
Interview preparation tips for other job seekers - First of all very prolonged interview they don’t have proper schedule.
And they literally call out interviewer names aloud and say leave ( unprofessional - at least take them in hall tell them the reason which them better luck next time, may be this boosts them for other take) mostly freshers
. HR -doesn’t share proper feedback or reason
. No decision on salary manager seems talkative juz seems unnecessary
. Every candidate has to go for 2days no matter he will be selected/rejected.
.I wasted my whole day just to give typing test and written test and that to being experienced and later they asked to come tomorrow for another round
And they literally call out interviewer names aloud and say leave ( unprofessional - at least take them in hall tell them the reason which them better luck next time, may be this boosts them for other take) mostly freshers
. HR -doesn’t share proper feedback or reason
. No decision on salary manager seems talkative juz seems unnecessary
. Every candidate has to go for 2days no matter he will be selected/rejected.
.I wasted my whole day just to give typing test and written test and that to being experienced and later they asked to come tomorrow for another round
Xpans IT Services Interview FAQs
How to prepare for Xpans IT Services 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 Xpans IT Services. The most common topics and skills that interviewers at Xpans IT Services expect are Data Modeling, SQL, Communication Skills, Consulting and Data Integration.
Tell us how to improve this page.
Interview Questions for Popular Designations
Interview Questions from Similar Companies
Xpans IT Services Reviews and Ratings
based on 2 reviews
Rating in categories
|
Information Technology Recruiter
5
salaries
|  ₹2 L/yr - ₹3.7 L/yr |
|
Software Developer
3
salaries
| ₹10.5 L/yr - ₹10.5 L/yr |
|
Senior Software Engineer
3
salaries
| ₹9 L/yr - ₹14 L/yr |
|
Senior IT Recruiter
3
salaries
| ₹3.5 L/yr - ₹4.2 L/yr |
Explore more salaries
Compare Xpans IT Services with
Exl India
Compare
Primus Global Technologies
Compare
TriGeo Technologies
Compare
CGS
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Xpans IT Services Interview Questions
Share an Interview