TCS Analyst Interview Questions, Process, and Tips

Moderate level to easy level

They asked in Moderate level

Q1. About certificate and salary
Add your answer

Basic logical reasoning

User story and use case writing

Q1. With TL and the manager
Add your answer
Q2. Resposibilities of ba
Ans. 
Business Analyst responsibilities include analyzing data, defining business requirements, and recommending solutions.
• Analyzing data to identify trends and insights

• Defining business requirements and documenting them

• Collaborating with stakeholders to understand their needs

• Creating reports and presentations to communicate findings

• Identifying opportunities for process improvement

• Participating in project planning and implem
Answered by AI
Add your answer

1.Aptitude 2. Two technical rounds and hr the first and second round was easy and they ask some basic concepts in oops

Q1. 1. What is inheritance and encapsulation
Ans. 
Inheritance is a mechanism in OOP where a new class inherits properties and behaviors from an existing class. Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
• Inheritance allows a class to inherit attributes and methods from another class, promoting code reusability.

• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• Example of ...read more
Answered by AI
Add your answer
Q2. 2. Write a program for Fibonacci
Ans. 
Program to generate Fibonacci series
• Start with two initial numbers 0 and 1

• Add the previous two numbers to get the next number in the series

• Repeat this process to generate the Fibonacci series

• Example: 0, 1, 1, 2, 3, 5, 8, 13, 21, ...
Answered by AI
Add your answer

Basic aptitude test for maths, reasoning and english

Q1. Technical questions for Windows OS
Add your answer
Q2. Windows Server 2012 question
Add your answer

Q1. How to convert an irate customer to a happy customer?
Ans. 
Listen to their concerns, empathize, offer solutions, and follow up.
• Listen actively to the customer's concerns without interrupting.

• Empathize with the customer by acknowledging their feelings and apologizing for any inconvenience.

• Offer solutions to address the customer's issues and ensure they are satisfied with the resolution.

• Follow up with the customer to ensure their satisfaction and build a positive relationship.
Answered by AI
Add your answer
Q2. Any challenging situation where you have to take a decision without any support?
Ans. 
Yes, I had to make a decision on a project deadline without team support.
• Had to prioritize tasks and allocate resources effectively

• Analyzed the situation and considered potential risks and benefits

• Communicated with stakeholders to gather necessary information

• Took responsibility for the decision and its outcomes
Answered by AI
Add your answer

Q1. Are you Ok with shift based job?
Ans. 
Yes, I am comfortable with shift based job as I am flexible with my working hours.
• I am open to working different shifts to accommodate the needs of the job

• I understand the importance of being flexible in a dynamic work environment

• I have previous experience working in shift based roles, such as customer service or healthcare

• I am willing to adapt my schedule to meet the demands of the job
Answered by AI
Add your answer
Q2. Salary discussions
Add your answer

Q1. Power bi for data analyst?
Add your answer
Q2. Tableau for data analyst?
Add your answer

Q1. What is ETL Testing
Ans. 
ETL Testing is the process of validating and verifying data extraction, transformation, and loading in a data warehouse or data mart.
• ETL Testing ensures data is accurately extracted from source systems

• It verifies data is transformed correctly according to business rules

• It validates data is loaded into the target system without any loss or corruption

• ETL Testing involves checking data completeness, correctness, and data ...read more
Answered by AI
Add your answer
Q2. What are SCD types
Ans. 
SCD types refer to slowly changing dimensions in data warehousing, used to track historical changes in data.
• SCD Type 1: Overwrites old data with new data, losing historical information.

• SCD Type 2: Creates new records for each change, preserving historical data with a separate surrogate key.

• SCD Type 3: Adds columns to the existing dimension table to track changes, keeping limited historical data.

• SCD Type 4: Uses separat...read more
Answered by AI
Add your answer