Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

Abana

Compare button icon Compare button icon Compare
4.0

based on 4 Reviews

Filter interviews by

Abana Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

Business Intelligence Developer Analyst Interview Questions & Answers

Dilyt user image Anonymous

posted on 29 Jun 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in May 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

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.

Round 2 - HR 

(2 Questions)

  • Q1. Self introduction
    • Add your answer
  • 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.

    • Answered by AI
    Add your answer
Round 3 - Technical 

(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...

    • Answered by AI
    Add your answer
  • Q2. How to fetch a employee record with the second highest salary from the employees table?
    • Add your answer
  • Q3. What was one of the trickiest incident you have faced and how did you counter it?
    • Add your answer
  • 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, ...

    • Answered by AI
    Add your answer
  • 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...

    • Answered by AI
    Add your answer
  • 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...

    • Answered by AI
    Add your answer
  • 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 ...

    • Answered by AI
    Add your answer

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

Skills evaluated in this interview

Executive Interview Questions & Answers

Exl India user image Anonymous

posted on 25 Nov 2024

Interview experience
3
Average
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Tell me about yourself?
    • Add your answer
  • Q2. Why did you living your current organization?
    • Add your answer
  • Q3. What is your expected CTC?
  • Ans. 

    I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.

    • Research industry standards for similar positions

    • Consider cost of living in the area

    • Factor in benefits and bonuses offered by the company

    • Be prepared to negotiate based on your value to the organization

    • Answered by AI
    Add your answer
Round 2 - One-on-one 

(7 Questions)

  • Q1. Tell me about yourself?
  • Ans. 

    I am a results-driven executive with over 10 years of experience in leading teams and driving business growth.

    • Experienced executive with a proven track record of success

    • Skilled in team leadership and business development

    • Strong focus on achieving results and driving growth

    • Answered by AI
    Add your answer
  • Q2. Why did you living your current organization?
    • Add your answer
  • Q3. How did you manage the night shift and traveling?
  • Ans. 

    I managed the night shift and traveling by prioritizing rest, staying organized, and utilizing technology.

    • Prioritized rest by ensuring adequate sleep during the day

    • Stayed organized by planning ahead and packing essentials in advance

    • Utilized technology for efficient communication and navigation while traveling

    • Answered by AI
    Add your answer
  • Q4. What do you know about the EXL?
  • Ans. 

    EXL is a leading operations management and analytics company that helps businesses improve performance.

    • EXL offers services in areas such as finance and accounting, healthcare, insurance, and more

    • They use advanced analytics and technology to drive business transformation

    • EXL has a global presence with offices in multiple countries

    • Answered by AI
    Add your answer
  • Q5. What is Insurance?
  • Ans. 

    Insurance is a financial product that provides protection against potential risks and losses.

    • Insurance involves an agreement between an individual or entity and an insurance company.

    • The individual or entity pays a premium in exchange for coverage against specific risks, such as property damage, illness, or liability.

    • Examples of insurance include health insurance, car insurance, life insurance, and property insurance.

    • Answered by AI
    Add your answer
  • Q6. What do you know about the premium?
  • Ans. 

    Premium refers to the amount of money an individual or business pays for an insurance policy.

    • Premium is the cost of purchasing an insurance policy

    • It is typically paid on a regular basis, such as monthly or annually

    • The premium amount is determined by factors such as the type of insurance, coverage amount, and the individual's risk profile

    • Answered by AI
    Add your answer
  • Q7. What is your current CTC and expectation?
  • Ans. 

    My current CTC is $100,000 and I am looking for a 15% increase in my next role.

    • Current CTC: $100,000

    • Expectation: 15% increase

    • Looking for opportunities in the range of $115,000 - $120,000

    • Answered by AI
    Add your answer
Round 3 - Aptitude Test 

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.

Round 4 - Typing Test 

(2 Questions)

  • Q1. Speed minimum 30.
    • Add your answer
  • Q2. Accuracy minimum 90 percent.
    • Add your answer
Round 5 - HR 

(2 Questions)

  • Q1. Discussion about the salary.
    • Add your answer
  • Q2. Fixing the package.
    • Add your 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.

Mid/Senior AQA Interview Questions & Answers

Intellias user image Anonymous

posted on 11 Dec 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(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

    • Answered by AI
    Add your answer
Round 2 - HR 

(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

    • Answered by AI
    Add your answer

Senior Software Developer Interview Questions & Answers

ElectrifAi user image Mohammad Zain Shaikh

posted on 23 Oct 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Sep 2024. There were 5 interview rounds.

Round 1 - Coding Test 

Easy Level DS Questions - 30 mins

Round 2 - Technical 

(2 Questions)

  • Q1. Cloud Services related questions
    • Add your answer
  • Q2. ETL Based question
    • Add your answer
Round 3 - Coding Test 

A comprehensive coding test which included job role simulation.

Round 4 - Coding Test 

Advanced Cloud Services questions

Round 5 - HR 

(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

    • Answered by AI
    Add your answer
  • Q2. Why did you leave your last organisation
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Remote work although partially supported, is highly discouraged.

Virtual Relationship Manager Interview Questions & Answers

Plada Infotech Services user image Anonymous

posted on 2 Sep 2024

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in

Round 1 - One-on-one 

(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

    • Answered by AI
    Add your answer
  • 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

    • Answered by AI
    Add your answer

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.

Financial Planning Analyst Interview Questions & Answers

Unitedlayer user image Anonymous

posted on 18 Jun 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.

Round 1 - Assignment 

1. Excel Test and preparation of Cash flow.
2. Prepare a financial Model on any company of our choice.

Round 2 - Technical 

(3 Questions)

  • Q1. Explain the work flow in current company?
    • Add your answer
  • Q2. Walk me through your resume?
    • Add your answer
  • 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...

    • Answered by AI
    Add your answer
Round 3 - HR 

(3 Questions)

  • Q1. Walk me through you resume?
    • Add your answer
  • Q2. Why are you looking for a job change?
    • Add your answer
  • Q3. What is your expected salary?
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Just explain the assignment in well defined manner.

QA/TL/TRAINER Interview Questions & Answers

CGS user image Anonymous

posted on 6 Aug 2024

Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Group Discussion 

JAM just introduce yourself or speak on sometime topic shared

Round 2 - Aptitude Test 

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

Analyst Interview Questions & Answers

Pioneer e Solutions user image Anonymous

posted on 16 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Quantitative Aptitude

Round 2 - Group Discussion 

Stakeholders vs Shareholders

Round 3 - Assignment 

Analysis of financial time series

Junior Inspector Interview Questions & Answers

Parsons International user image Anonymous

posted on 28 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Tell us about yourself
    • Add your answer
  • Q2. How much do you know about inspection and what would you refer for doing inspection work
  • Ans. 

    I have a strong understanding of inspection processes and recommend thorough documentation, attention to detail, and adherence to regulations.

    • Understanding of inspection procedures and protocols

    • Attention to detail in identifying issues and discrepancies

    • Thorough documentation of findings and recommendations

    • Adherence to regulations and standards

    • Utilization of appropriate tools and equipment for inspections

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic HR questions, understand basic terminology that goes in inspection duties and be confident in showing your learning ability and communication skills

Senior Test Engineer Interview Questions & Answers

eTouch - Virtusa user image Anonymous

posted on 23 Mar 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Coding Test 

HashMap vs HashTable difference
Program for fibonnaci series

Round 2 - Technical 

(3 Questions)

  • Q1. About selenium project framework structure
    • Add your answer
  • Q2. Explained about framework
    • Add your answer
  • Q3. Created Maven project with TestNG pluggin
    • Add your answer
More about working at Abana

Tell us how to improve this page.

Interview Questions for Popular Designations

Interview Questions from Similar Companies

CGS Interview Questions
3.5
 • 26 Interviews
TriGeo Technologies Interview Questions
3.2
 • 25 Interviews
Primus Global Technologies Interview Questions
4.0
 • 23 Interviews
ElectrifAi Interview Questions
2.6
 • 17 Interviews
Infosys Public Services Interview Questions
3.7
 • 8 Interviews
Plada Infotech Services Interview Questions
3.5
 • 8 Interviews
Parsons International Interview Questions
4.4
 • 7 Interviews
Ricoh Interview Questions
3.8
 • 7 Interviews
PruTech Solutions Interview Questions
4.0
 • 7 Interviews
Ind Innovations Interview Questions
3.6
 • 7 Interviews
View all

Abana Reviews and Ratings

based on 4 reviews

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-Life balance

3.9

Salary & Benefits

4.0

Job Security

4.0

Company culture

3.0

Promotions/Appraisal

4.0

Work Satisfaction

Explore 4 Reviews and Ratings
Compare Abana with

Primus Global Technologies

4.0
Compare

TriGeo Technologies

3.2
Compare

Ricoh

3.8
Compare

Plada Infotech Services

3.5
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
write
Share an Interview