AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
TCS
Compare
Filter interviews by
TCS Analyst Interview Questions and Answers
37 Interview questions
Partitioning in SQL is a database design technique that divides large tables into smaller, manageable pieces for improved performance.
Improves query performance by reducing the amount of data scanned.
Can be done using range, list, hash, or composite partitioning methods.
Example: Range partitioning can separate sales data by year.
Facilitates easier data management, such as archiving old data.
Allows for parallel pro...
An automation fuse works by detecting excessive current flow and breaking the circuit to prevent damage.
Detects excessive current flow in a circuit
Breaks the circuit to prevent damage
Automatically resets once the fault is cleared
Commonly used in electrical systems to protect against overloads
I want to work with TCS for its innovation, global exposure, and commitment to employee growth and development.
TCS is a leader in technology and innovation, providing opportunities to work on cutting-edge projects.
The company's global presence allows for diverse experiences and collaboration with international teams.
TCS emphasizes continuous learning and development, offering various training programs to enhance s...
Dataframe is a two-dimensional data structure in pandas that stores data in rows and columns.
Dataframe is a key data structure in the pandas library for data manipulation and analysis
It is similar to a table in a relational database or a spreadsheet in Excel
Dataframes can be created from various data sources such as CSV files, databases, or dictionaries
What people are saying about TCS
Data visualization tools are software that help in creating visual representations of data to aid in understanding and analysis.
Tableau
Power BI
QlikView
Google Data Studio
D3.js
Azure Key Vault integration is a feature that allows users to securely store and manage sensitive information such as keys, passwords, certificates, etc.
Azure Key Vault helps to safeguard cryptographic keys and secrets used by cloud applications and services
It provides centralized management of keys, secrets, and certificates
Integrating Azure Key Vault with applications ensures secure access to sensitive informati...
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 i...
SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) are processes used in software development and testing.
SDLC involves planning, designing, coding, testing, and maintenance of software.
STLC involves test planning, test design, test execution, and test closure.
SDLC focuses on the development of software, while STLC focuses on the testing of software.
Both SDLC and STLC are essential for d...
OOPs stands for Object-Oriented Programming. It has 4 pillars: Encapsulation, Inheritance, Polymorphism, and Abstraction.
Encapsulation: Wrapping data and methods into a single unit (class).
Inheritance: Acquiring properties and behavior of a parent class by a child class.
Polymorphism: Ability of an object to take many forms. Method overloading and overriding are examples.
Abstraction: Hiding implementation details a...
OOPs stands for Object-Oriented Programming. The four pillars of OOPs are Abstraction, Encapsulation, Inheritance, and Polymorphism.
Abstraction: Hiding the implementation details and showing only the necessary information to the user.
Encapsulation: Wrapping data and functions together in a single unit (class) and restricting access to them.
Inheritance: Creating a new class from an existing class, inheriting all th...
TCS Analyst Interview Experiences
106 interviews found
Anonymous
Selected
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(5 Questions)
- Q1. What is data analysis and data science?
- Ans.
Data analysis involves examining, cleaning, transforming, and modeling data to discover useful information, while data science involves using scientific methods, algorithms, and systems to extract knowledge and insights from data.
Data analysis focuses on examining and interpreting data to make informed decisions.
Data science involves using various techniques and algorithms to extract insights and knowledge from data.
Da...
- Q2. What is array explain numpy in python?
- Ans.
An array in numpy is a grid of values, all of the same type, and is indexed by a tuple of nonnegative integers.
Numpy is a popular Python library for numerical computing.
Arrays in numpy can be created using the np.array() function.
Arrays can have multiple dimensions, such as 1D, 2D, or even higher dimensions.
Numpy arrays are more efficient than Python lists for numerical operations.
Example: import numpy as np arr = np.a...
- Q3. What is dataframe?
- Ans.
Dataframe is a two-dimensional data structure in pandas that stores data in rows and columns.
Dataframe is a key data structure in the pandas library for data manipulation and analysis
It is similar to a table in a relational database or a spreadsheet in Excel
Dataframes can be created from various data sources such as CSV files, databases, or dictionaries
- Q4. What is Power Bi
- Q5. What are the data visulaztion tools?
- Ans.
Data visualization tools are software that help in creating visual representations of data to aid in understanding and analysis.
Tableau
Power BI
QlikView
Google Data Studio
D3.js
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Walk-in and was interviewed in Dec 2024. There were 3 interview rounds.
(1 Question)
- Q1. Match functionality in mainframes
- Ans.
Mainframes provide high-performance computing for large-scale data processing and transaction processing.
Mainframes are known for their reliability, security, and scalability.
They are commonly used in industries such as banking, healthcare, and government.
Examples of mainframe functionality include batch processing, online transaction processing (OLTP), and virtualization.
Mainframes can handle massive amounts of data a...
(1 Question)
- Q1. Why do you want to join TCS
- Ans.
I want to join TCS because of its reputation for innovation and growth opportunities.
TCS is known for its cutting-edge technology solutions and innovative projects.
I am impressed by TCS's global presence and diverse client portfolio.
I believe TCS offers excellent career growth opportunities and professional development.
I am excited about the chance to work with talented professionals at TCS.
Rushikesh Patil
Selected
I applied via Company Website and was interviewed in Dec 2024. There were 3 interview rounds.
The basic aptitude test is Ninja. And it was very tough.
They provide us test code based on test SQL, java and some testing area case studies.
(1 Question)
- Q1. Technical interview
Selected
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. Why BPO payroll not changed to IT payroll?
- Ans.
BPO payroll remains distinct from IT payroll due to differing operational focuses and skill requirements.
BPO (Business Process Outsourcing) focuses on managing business processes, while IT payroll deals with technology and software development.
BPO roles often require skills in customer service and process management, whereas IT roles demand technical expertise in programming and systems.
For example, a BPO payroll speci...
- Q2. Why RMG compressing BPS associate only to get the project in short span time?
- Ans.
RMG compresses BPS associates to expedite project timelines, enhancing efficiency and responsiveness to client needs.
RMG aims to streamline processes, allowing for quicker project initiation and completion.
By compressing BPS associates, RMG can allocate resources more effectively, reducing bottlenecks.
For example, in a recent project, RMG reduced the onboarding time for BPS associates, leading to a faster delivery of s...
Mishti Doi
(2 Questions)
- Q1. Tell me about your self
- Q2. Tell me about yourself
(1 Question)
- Q1. Tell me about your self
HP
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. Testing questions
- Q2. Automate testing
VIVEK SINGH
(2 Questions)
- Q1. What is lookup transformation?
- Ans.
Lookup transformation is used in data integration to look up data from a source based on a key and insert it into the target.
Lookup transformation is used in ETL processes to search for a value in a reference dataset and return a matching value.
It can be used to perform tasks like updating existing records, inserting new records, or flagging records based on lookup results.
Commonly used in data warehousing and business...
- Q2. What is update strategy?
- Ans.
Update strategy is a plan or method used to update data in a database or system.
Update strategy determines how changes to data are handled, such as insert, update, delete operations.
It can involve specifying conditions for updating data, like only updating records that meet certain criteria.
Common update strategies include 'update if exists, insert if not' and 'update all records'.
Skills evaluated in this interview
(2 Questions)
- Q1. What is sap Aribaa
- Ans.
SAP Ariba is a cloud-based procurement solution that helps businesses streamline their procurement processes.
SAP Ariba provides tools for procurement, sourcing, supplier management, and invoice management.
It helps businesses connect with suppliers, manage contracts, and automate procurement processes.
The platform offers spend visibility, supplier collaboration, and risk management capabilities.
SAP Ariba is used by many...
- Q2. Core componenets of SAP Ariba
- Ans.
Core components of SAP Ariba include Sourcing, Contracts, Procurement, Supplier Management, and Invoice Management.
Sourcing: Allows organizations to manage sourcing events and negotiations with suppliers.
Contracts: Helps in creating and managing contracts with suppliers.
Procurement: Streamlines the procurement process by automating purchase orders and approvals.
Supplier Management: Manages supplier information, perform...
Selected
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
(2 Questions)
- Q1. ETL Process Pipelines and Explanations
- Ans.
ETL process pipelines involve extracting, transforming, and loading data from source systems to target systems.
ETL stands for Extract, Transform, Load
Data is extracted from source systems, transformed according to business rules, and loaded into target systems
ETL pipelines are used to move data between systems efficiently and reliably
Common ETL tools include Informatica, Talend, and Apache NiFi
- Q2. Database SQL Queries
(1 Question)
- Q1. Expected CTC and why quitting previous company
- Ans.
Expected CTC and reason for leaving previous company
Expected CTC is based on my experience, skills, and market standards
I left my previous company due to lack of growth opportunities
I am looking for a challenging role with better compensation
Skills evaluated in this interview
Diksha Anand
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There was 1 interview round.
(5 Questions)
- Q1. Which type of custom GA4 reports you have created?
- Ans.
I have created custom GA4 reports for tracking user behavior, conversion rates, and campaign performance.
Created custom reports to track user engagement on specific pages
Developed reports to analyze conversion rates for different marketing channels
Built reports to measure the performance of specific ad campaigns
- Q2. What custom user activities you track on client website?
- Ans.
We track custom user activities such as login/logout, product views, purchases, and form submissions.
Login/logout events
Product views
Purchases
Form submissions
- Q3. Explain the process of creating tags and triggers in GTM.
- Ans.
Creating tags and triggers in GTM involves defining actions and conditions for tracking events on a website.
Tags are used to define what actions should be taken when a specific event occurs on the website.
Triggers are used to define the conditions under which a tag should be fired.
Tags can be set up to track various events such as button clicks, form submissions, pageviews, etc.
Triggers can be based on URL, click class...
- Q4. Which type of industry projects you have worked on?
- Q5. Have you set up GTM on the website?
- Ans.
Yes, I have set up Google Tag Manager (GTM) on the website.
Yes, I have experience setting up GTM for tracking website analytics.
Implemented various tags, triggers, and variables within GTM.
Ensured proper data tracking and integration with other tools like Google Analytics.
Regularly monitored and tested GTM setup for accuracy and efficiency.
Interview Preparation Tips
Skills evaluated in this interview
TCS Interview FAQs
Some of the top questions asked at the TCS Analyst interview -
The duration of TCS Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
TCS Interviews By Designations
- TCS System Engineer Interview Questions
- TCS Software Developer Interview Questions
- TCS Software Engineer Interview Questions
- TCS Assistant System Engineer Interview Questions
- TCS Assistant System Engineer Trainee Interview Questions
- TCS IT Analyst Interview Questions
- TCS Ninja Interview Questions
- TCS Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Analyst Interview Questions
- Data Analyst Interview Questions
- Senior Analyst Interview Questions
- Financial Analyst Interview Questions
- Quality Analyst Interview Questions
- Programmer Analyst Interview Questions
- Research Analyst Interview Questions
- Senior Business Analyst Interview Questions
- Show more
Overall Interview Experience Rating
based on 91 interview experiences
Difficulty level
Duration
Analyst Interview Questions from Similar Companies
TCS Analyst Reviews and Ratings
based on 799 reviews
Rating in categories
|
System Engineer
1.1L
salaries
|  ₹1 L/yr - ₹9 L/yr |
|
IT Analyst
65.7k
salaries
| ₹5.1 L/yr - ₹17 L/yr |
|
AST Consultant
53.3k
salaries
| ₹8 L/yr - ₹25.2 L/yr |
|
Assistant System Engineer
33.2k
salaries
| ₹2.6 L/yr - ₹6.4 L/yr |
|
Associate Consultant
32.5k
salaries
| ₹9 L/yr - ₹33 L/yr |
Amazon
Wipro
Infosys
Accenture
- Home >
- Interviews >
- TCS Interview Questions >
- TCS Analyst Interview Questions
