Upload Button Icon Add office photos

Filter interviews by

Telecall Technology Interview Questions, Process, and Tips

Updated 13 Feb 2025

Top Telecall Technology Interview Questions and Answers

View all 13 questions

Telecall Technology Interview Experiences

Popular Designations

3 interviews found

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

I was interviewed before Feb 2024.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself.
  • Q2. What is your notice period and why do you want to leave your current organization.
  • Ans. 

    Notice period is 2 months. Seeking new challenges and growth opportunities.

    • Notice period is 2 months

    • Looking for new challenges and growth opportunities

    • Current organization lacks opportunities for career advancement

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. Fetch second highest salary of an employee in oracle SQL.
  • Ans. 

    Use SQL query with subquery to fetch second highest salary of an employee in Oracle.

    • Use ORDER BY and LIMIT to get the second highest salary.

    • Use a subquery to exclude the highest salary and then find the maximum from the remaining salaries.

    • Example: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

  • Answered by AI
  • Q2. Fetch and delete duplicate records in oracle SQL.
  • Ans. 

    Use a subquery to fetch and delete duplicate records in Oracle SQL.

    • Use a subquery to identify duplicate records based on a unique identifier

    • Use the DELETE statement with the subquery to remove the duplicate records

    • Ensure to backup the data before deleting duplicates

  • Answered by AI
  • Q3. Difference between primary and foreign key.
  • Ans. 

    Primary key uniquely identifies a record in a table, while foreign key establishes a link between two tables.

    • Primary key is a column in a table that uniquely identifies each record.

    • Foreign key is a column in a table that refers to the primary key in another table.

    • Primary key cannot have NULL values, while foreign key can have NULL values.

    • Primary key ensures data integrity and enforces uniqueness, while foreign key main...

  • Answered by AI
  • Q4. What will you do when application is down?
  • Ans. 

    I will investigate the root cause, communicate with stakeholders, and work on resolving the issue as quickly as possible.

    • Investigate the logs to identify the root cause of the issue

    • Communicate with stakeholders about the downtime and expected resolution time

    • Work on resolving the issue by troubleshooting and fixing the underlying problem

    • Implement preventive measures to avoid similar downtime in the future

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and comfortable with your answers.

Software Engineer Interview Questions asked at other Companies

Q1. Bridge and torch problem : Four people come to a river in the night. There is a narrow bridge, but it can only hold two people at a time. They have one torch and, because it's night, the torch has to be used when crossing the bridge. Person... read more
View answer (196)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Nth Highest Salary in SQL. Fetch Duplicate records in SQL. Write shell script to print febonicci series.
  • Ans. 

    SQL query to find Nth highest salary, fetch duplicate records, and shell script for Fibonacci series.

    • To find Nth highest salary in SQL, use the 'ROW_NUMBER()' function with 'ORDER BY' and 'LIMIT'. Example: SELECT salary FROM (SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rn FROM employees) AS temp WHERE rn = N;

    • To fetch duplicate records in SQL, use the 'GROUP BY' and 'HAVING' clauses. Example: SELECT colum...

  • Answered by AI
  • Q2. Use dense rank function
  • Ans. 

    Dense rank function assigns a rank to each row within a partition of a result set, with no gaps in the ranking values.

    • Use the DENSE_RANK() function in SQL to assign a unique rank to each row within a partition

    • It is similar to the RANK() function but does not leave gaps in the ranking values

    • Example: SELECT column1, DENSE_RANK() OVER (PARTITION BY column2 ORDER BY column3) AS dense_rank FROM table_name

  • Answered by AI
  • Q3. Use Having Clause
  • Ans. 

    The HAVING clause is used in SQL to filter groups based on a specified condition.

    • HAVING clause is used with the GROUP BY clause to filter groups based on a specified condition

    • It is used to filter the results after grouping has been done

    • It is similar to the WHERE clause but operates on grouped records

  • Answered by AI
  • Q4. Use For loop to fetch febonnici series
  • Ans. 

    Using a for loop to fetch the Fibonacci series.

    • Initialize variables for the first two numbers in the series (0 and 1).

    • Use a for loop to calculate the next number in the series by adding the previous two numbers.

    • Store each number in the series in an array.

    • Continue the loop until reaching the desired length of the series.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on you confidence and communication skills.

Skills evaluated in this interview

Top Telecall Technology Application Support Engineer Interview Questions and Answers

Q1. Nth Highest Salary in SQL. Fetch Duplicate records in SQL. Write shell script to print febonicci series.
View answer (1)

Application Support Engineer Interview Questions asked at other Companies

Q1. what do you know about SQL , Unix , explain in brief
View answer (2)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(5 Questions)

  • Q1. Write a shell script to check system health.
  • Ans. 

    A shell script to check system health

    • Check CPU usage using 'top' or 'ps' command

    • Check memory usage using 'free' or 'top' command

    • Check disk usage using 'df' command

    • Check network connectivity using 'ping' command

    • Check system load using 'uptime' command

    • Check running processes using 'ps' command

  • Answered by AI
  • Q2. Highest salary in SQL
  • Ans. 

    The highest salary in SQL can vary depending on factors such as location, experience, and industry.

    • The highest salary in SQL is typically found in roles such as database administrators, data engineers, and data architects.

    • Factors that can influence the highest salary include the candidate's level of experience, the location of the job, and the industry.

    • For example, a senior database administrator in a major tech hub li...

  • Answered by AI
  • Q3. Duplicate records delete In sql
  • Ans. 

    To delete duplicate records in SQL, you can use the DELETE statement with a subquery.

    • Identify the duplicate records using a SELECT statement with GROUP BY and HAVING clause.

    • Create a subquery to select the duplicate records.

    • Use the DELETE statement with the subquery to delete the duplicate records.

  • Answered by AI
  • Q4. Grep command in unjx
  • Ans. 

    Grep command is used in Unix to search for specific patterns in files.

    • Grep stands for Global Regular Expression Print.

    • It is a powerful command-line tool for searching text files.

    • It uses regular expressions to match patterns.

    • Grep can search for patterns in a single file or multiple files.

    • It can also search recursively in directories.

    • Grep has various options to control the search behavior.

    • Some common options include -i (...

  • Answered by AI
  • Q5. Awk command in unux
  • Ans. 

    Awk command in Unix is a powerful text processing tool used for extracting and manipulating data.

    • Awk command is used for pattern scanning and processing of text files.

    • It allows you to specify patterns and actions to be performed on those patterns.

    • Awk operates on a line-by-line basis, processing one line at a time.

    • It can be used to extract specific columns from a file, perform calculations, and generate reports.

    • Awk uses...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and focus on communication skills.

Skills evaluated in this interview

Top Telecall Technology Application Support Engineer Interview Questions and Answers

Q1. Nth Highest Salary in SQL. Fetch Duplicate records in SQL. Write shell script to print febonicci series.
View answer (1)

Application Support Engineer Interview Questions asked at other Companies

Q1. what do you know about SQL , Unix , explain in brief
View answer (2)

Interview questions from similar companies

Interview Questionnaire 

3 Questions

  • Q1. Do u have done any work in appkication support
  • Q2. How u can improve ur skills
  • Q3. Are u able to speak english

I applied via Naukri.com and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Introduction, qualification, experience, and family background

Interview Preparation Tips

Interview preparation tips for other job seekers - Just one telephonic round and one video call round with the recruiter and they selected me without any complications.

I applied via Approached by Company and was interviewed in Jul 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(5 Questions)

  • Q1. Which technology you have worked ,explain in brief your day to day roles and responsibilities
  • Q2. What do you know about SQL , Unix , explain in brief
  • Ans. 

    SQL is a database language used to manage data. Unix is an operating system used for servers and workstations.

    • SQL is used to create, modify, and query databases.

    • Unix is a command-line interface used for file management, process control, and networking.

    • SQL can be used with various database management systems like MySQL, Oracle, and SQL Server.

    • Unix commands include ls, cd, grep, and chmod.

    • SQL and Unix are commonly used i

  • Answered by AI
  • Q3. Tell all unix commands which are mostly used
  • Ans. 

    Commonly used Unix commands

    • ls - list directory contents

    • cd - change directory

    • mkdir - make directory

    • rm - remove files or directories

    • cp - copy files or directories

    • mv - move or rename files or directories

    • grep - search for patterns in files

    • cat - concatenate and display files

    • chmod - change file permissions

    • ssh - secure shell remote login

  • Answered by AI
  • Q4. What you will do if application perform slow,
  • Ans. 

    I will investigate the root cause of the slow performance and take appropriate actions.

    • Check server resources usage

    • Analyze application logs

    • Identify bottleneck areas

    • Optimize database queries

    • Implement caching mechanisms

    • Upgrade hardware or software if necessary

  • Answered by AI
  • Q5. Tell all SQL commands which you know
  • Ans. 

    Common SQL commands for data manipulation and retrieval

    • SELECT - retrieve data from a table

    • INSERT - insert data into a table

    • UPDATE - update existing data in a table

    • DELETE - delete data from a table

    • CREATE - create a new table or database

    • ALTER - modify the structure of a table

    • DROP - delete a table or database

    • JOIN - combine data from multiple tables

    • GROUP BY - group data based on a specific column

    • ORDER BY - sort data based

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Tech Mahindra Application Support Engineer interview:
  • MS SQL Server
  • Unix scripting
  • Cloud
  • Devops
  • Redhat Linux
Interview preparation tips for other job seekers - Keep confidence and polite be honest do not try to cheat if their is video call interview

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Share technical questions regarding interview
Round 3 - One-on-one 

(1 Question)

  • Q1. Share several level questions and Linux, Unix and Android
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Feb 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. General scripting, SQL and troubleshooting approaches
Round 3 - Coding Test 

DSA and stakeholder management

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Regarding application
  • Q2. Regarding program
Round 2 - One-on-one 

(2 Questions)

  • Q1. Related to manage customer
  • Q2. How to tackle end users
  • Ans. 

    Tackling end users involves effective communication, patience, and problem-solving skills.

    • Listen actively to understand their issues

    • Communicate clearly and patiently

    • Provide step-by-step instructions or guidance

    • Empathize with their frustrations

    • Offer solutions or workarounds

    • Follow up to ensure the issue is resolved

  • Answered by AI
Round 3 - Coding Test 

How to write code regarding customer

Round 4 - Case Study 

Case study regarding related to project

Round 5 - One-on-one 

(1 Question)

  • Q1. HR manager one on one round
Round 6 - Assignment 

Application project management

Interview Preparation Tips

Interview preparation tips for other job seekers - Plz guide regarding issue

I applied via Referral and was interviewed in Oct 2021. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. I was asked about technical questions regarding the work of which I need to provide application support ...
  • Q2. WHAT YOU KNOW ABOUT CGST ?
  • Ans. 

    CGST stands for Central Goods and Services Tax.

    • CGST is a tax levied on the supply of goods and services within a state.

    • It is a part of the Goods and Services Tax (GST) system in India.

    • The revenue collected from CGST is shared between the central and state governments.

    • CGST rates vary depending on the type of goods or services being supplied.

    • For example, the CGST rate for essential goods like food items is lower than tha

  • Answered by AI
  • Q3. What you Know about work of application support engineer
  • Ans. 

    Application Support Engineers are responsible for troubleshooting and resolving technical issues related to software applications.

    • Provide technical support to end-users and clients

    • Identify and resolve software bugs and errors

    • Collaborate with development teams to enhance application functionality

    • Document and maintain knowledge base articles for troubleshooting

    • Monitor application performance and identify areas for improv

  • Answered by AI
  • Q4. What is experience in customer support services ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be Positive and always be honest in answering questions ...
Contribute & help others!
anonymous
You can choose to be anonymous

Telecall Technology Interview FAQs

How many rounds are there in Telecall Technology interview?
Telecall Technology interview process usually has 1-2 rounds. The most common rounds in the Telecall Technology interview process are Technical, Resume Shortlist and HR.
What are the top questions asked in Telecall Technology interview?

Some of the top questions asked at the Telecall Technology interview -

  1. Nth Highest Salary in SQL. Fetch Duplicate records in SQL. Write shell script t...read more
  2. What will you do when application is do...read more
  3. Fetch second highest salary of an employee in oracle S...read more

Recently Viewed

COMPANY BENEFITS

Fractal Analytics

No Benefits

SALARIES

Jindal Stainless

SALARIES

Tiger Analytics

JOBS

Crayon Data

No Jobs

SALARIES

Ugam Solution

INTERVIEWS

Vipro Lifescience

No Interviews

INTERVIEWS

Noodle Analytics

No Interviews

REVIEWS

Fractal Analytics

No Reviews

REVIEWS

Fractal Analytics

No Reviews

REVIEWS

Fractal Analytics

No Reviews

Tell us how to improve this page.

Telecall Technology Interview Process

based on 4 interviews

Interview experience

4.8
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
View all

Telecall Technology Reviews and Ratings

based on 10 reviews

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 10 Reviews and Ratings
Compare Telecall Technology with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent