Add office photos
Filter interviews by
Xpans IT Services Interview Questions and Answers
Xpans IT Services Interview Experiences
1 interview found
Interview Questionnaire
3 Questions
- Q1. Basics about your work and practice experience discussion and also about you future plan and communication skill
- Q2. My communication skill they have checked and confidence level and also my subject. Knowledge for which position I am apply for
- Q3. Related to your practical work and current requirement the question will be asked
Interview Preparation Tips
Experience: Final discuss in conclusion of all other rounds
Top trending discussions
Interview questions from similar companies
Business Intelligence Developer Analyst Interview Questions & Answers
Dilyt
Anonymous
posted on 29 Jun 2024
I applied via Walk-in and was interviewed in May 2024. There were 3 interview 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.
(2 Questions)
- Q1. Self introduction
- Q2. Okay with the SLA
- Ans.
SLA stands for Service Level Agreement, which outlines the level of service expected from a vendor.
SLA defines the agreed upon level of service between a provider and a customer.
It includes metrics like response time, uptime, and resolution time.
SLAs are important for ensuring accountability and quality of service.
Example: An SLA might specify that the vendor will respond to support tickets within 24 hours.
(7 Questions)
- Q1. What is the difference between DDL and DML?
- Ans.
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
DDL is used to create, modify, and delete database objects such as tables, indexes, and views.
DML is used to insert, update, delete, and retrieve data from database tables.
Examples of DDL statements include CREATE TABLE, ALTER TABLE...
- Q2. How to fetch a employee record with the second highest salary from the employees table?
- Q3. What was one of the trickiest incident you have faced and how did you counter it?
- Q4. How SQL is divided?
- Ans.
SQL is divided into Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).
Data Definition Language (DDL) - used to define the structure of database objects like tables, indexes, and views. Examples include CREATE, ALTER, DROP.
Data Manipulation Language (DML) - used to manipulate data stored in the database. Examples include SELECT, INSERT, ...
- Q5. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
- Ans.
To prepare an employee's attendance record, I would gather data on their attendance, create charts and graphs to visualize trends and patterns.
Gather attendance data including dates, times, and reasons for absence or tardiness
Create a spreadsheet or database to organize the data
Use software like Excel or Tableau to create charts and graphs showing attendance trends
Include metrics such as overall attendance rate, late a...
- Q6. Difference between SQL and MYSQL
- Ans.
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
SQL is a standard language used to interact with databases, while MySQL is a specific database management system.
SQL is an ANSI (American National Standards Institute) standard language, while MySQL is an open-source relational database management system.
SQL can be used with various database ma...
- Q7. Define joins using examples.
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Joins are used in SQL to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: INNER JOIN retrieves rows from both tables where the join condition is met.
Example: LEFT JOIN retrieves all rows from the left table and the matched rows ...
Interview Preparation Tips
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
Senior Automation Engineer Interview Questions & Answers
Zebra Technologies
Anonymous
posted on 10 Jan 2025
(2 Questions)
- Q1. How do agile methodologies function in B2B projects?
- Ans.
Agile methodologies in B2B projects involve frequent communication, adaptability, and collaboration with stakeholders.
Agile methodologies in B2B projects prioritize customer collaboration and responding to change over following a strict plan.
Regular feedback from stakeholders helps in adjusting project scope and priorities in real-time.
Cross-functional teams work together closely to deliver incremental value to the B2B...
- Q2. What is your experience with barcode scanners?
- Ans.
I have extensive experience working with barcode scanners in various automation projects.
Implemented barcode scanning functionality in warehouse management system to track inventory
Integrated barcode scanners with automated testing tools for regression testing
Utilized barcode scanners in manufacturing processes to improve efficiency and accuracy
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
(1 Question)
- Q1. Can implicit and explicit waits be used within the framework?
- Ans.
Yes, implicit and explicit waits can be used within the framework.
Implicit waits are used to wait for a certain amount of time before throwing an exception if the element is not found immediately.
Explicit waits are used to wait for a certain condition to be met before proceeding further.
Both types of waits can be used in test automation frameworks like Selenium for better synchronization and handling of dynamic element
(1 Question)
- Q1. What are your professional aspirations?
- Ans.
My professional aspiration is to become a lead AQA engineer and contribute to the development of cutting-edge software products.
Advance to a lead AQA engineer role
Contribute to the development of innovative software products
Continuously improve my skills and knowledge in AQA
Senior Software Developer Interview Questions & Answers
ElectrifAi
Mohammad Zain Shaikh
posted on 23 Oct 2024
I applied via Naukri.com and was interviewed in Sep 2024. There were 5 interview rounds.
Easy Level DS Questions - 30 mins
(2 Questions)
- Q1. Cloud Services related questions
- Q2. ETL Based question
A comprehensive coding test which included job role simulation.
Advanced Cloud Services questions
(2 Questions)
- Q1. Introduce yourself
- Ans.
I am a Senior Software Developer with 8 years of experience in full-stack development, specializing in Java and Angular.
8 years of experience in full-stack development
Specialize in Java and Angular
Strong problem-solving skills
Experience working in agile environments
- Q2. Why did you leave your last organisation
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.
Full c concept MCQ with IQ and Computaional Thinking
(2 Questions)
- Q1. Number system convertion in c
- Ans.
Number system conversion in C involves converting numbers between different bases, such as decimal to binary or hexadecimal.
Use functions like itoa() to convert integers to strings in different bases
Use strtol() to convert strings to integers in different bases
Remember to specify the base when converting numbers
- Q2. Pointers, struct, Data Structure
(2 Questions)
- Q1. Decimal to Binary Convertion
- Q2. Hexa Decimal to Binary convertion
Skills evaluated in this interview
Medical Coding Associate Interview Questions & Answers
Starmark Software
Anonymous
posted on 11 Jan 2025
Selected
(1 Question)
- Q1. What is the purpose of medical coding?
Virtual Relationship Manager Interview Questions & Answers
Plada Infotech Services
Anonymous
posted on 2 Sep 2024
Selected
I applied via Walk-in
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a dedicated and experienced Virtual Relationship Manager with a passion for building strong connections and providing excellent customer service.
Over 5 years of experience in virtual relationship management
Skilled in communication, problem-solving, and relationship-building
Proven track record of exceeding customer satisfaction goals
Proficient in CRM software and virtual communication tools
- Q2. Why do you want to join
- Ans.
I am passionate about leveraging technology to enhance customer relationships and provide personalized solutions.
Passionate about using technology to improve customer relationships
Excited about providing personalized solutions
Believe in the importance of virtual communication in today's digital world
Interview Preparation Tips
Financial Planning Analyst Interview Questions & Answers
Unitedlayer
Anonymous
posted on 18 Jun 2024
I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.
1. Excel Test and preparation of Cash flow.
2. Prepare a financial Model on any company of our choice.
(3 Questions)
- Q1. Explain the work flow in current company?
- Q2. Walk me through your resume?
- Q3. Explain how you made financial model in detail.
- Ans.
I create financial models by gathering historical data, making assumptions, building projections, and analyzing the results.
Gather historical financial data such as income statements, balance sheets, and cash flow statements.
Make assumptions about future performance based on industry trends, company strategy, and economic conditions.
Build projections using tools like Excel or financial modeling software to forecast rev...
(3 Questions)
- Q1. Walk me through you resume?
- Q2. Why are you looking for a job change?
- Q3. What is your expected salary?
Interview Preparation Tips
Talent Acquisition Specialist Interview Questions & Answers
Oasis TechnoSoft
Rahul Tripathi
posted on 24 Dec 2024
Selected
I applied via Approached by Company and was interviewed in Jun 2024. There were 3 interview rounds.
(1 Question)
- Q1. Overall experience and familiarity with best recruitment practices
- Ans.
I have 5+ years of experience in talent acquisition and am familiar with best recruitment practices.
Utilizing social media platforms for sourcing candidates
Implementing diversity and inclusion initiatives in recruitment processes
Leveraging data analytics for improving recruitment strategies
(1 Question)
- Q1. Round with Direct of IT
(1 Question)
- Q1. Final Discussion
Interview Preparation Tips
Xpans IT Services Interview FAQs
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 3 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 |
Primus Global Technologies
TriGeo Technologies
Plada Infotech Services
CGS
- Home >
- Interviews >
- Xpans IT Services Interview Questions
