AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
TCS
Compare
Filter interviews by
TCS Assistant System Analyst Interview Questions, Process, and Tips
Top TCS Assistant System Analyst Interview Questions and Answers
- Q1. How to form query in sql
- Q2. Are you aware about agile?
- Q3. What is SDLC cycle.
TCS Assistant System Analyst Interview Experiences
5 interviews found
Selected
I applied via Campus Placement and was interviewed before Jul 2023. There were 2 interview rounds.
Basic logical reasoning and Quantitative Aptitude
I applied via Job Fair and was interviewed before Oct 2021. There were 3 interview rounds.
Normal Aptitude test consisting of time, age, profit loss and integrals - 60 minutes
3 coding questions 1 easy 1 medium and 1 difficult
(5 Questions)
- Q1. Asked me about DBMS and project related
- Q2. Basic HR question too
- Q3. Are you willing to relocate
- Q4. Curd rules in database
- Ans.
Curd rules are constraints that ensure data integrity in a database.
Curd rules are used to enforce data consistency and accuracy.
They prevent invalid data from being entered into the database.
Examples of curd rules include unique constraints, foreign key constraints, and check constraints.
- Q5. Normalizations - 1nf, 2nf, 3nf
Interview Preparation Tips
- Data base
- Java
- Python
- Project
- Operating Systems
Skills evaluated in this interview
Interview Preparation Tips
Your complete interview will be based on these 3-4 points.
What people are saying about TCS
I applied via Referral and was interviewed before Jul 2020. There were 3 interview rounds.
Interview Questionnaire
5 Questions
- Q1. Tell me about yourself
- Ans. I tried to explain my work as a story. Also, based on JD i highlighted the part they were looking for
- Q2. What is SDLC cycle.
- Ans.
SDLC cycle is a process followed by software development teams to design, develop and test high-quality software.
SDLC stands for Software Development Life Cycle
It consists of several phases including planning, analysis, design, implementation, testing, and maintenance
Each phase has its own set of deliverables and goals
The cycle is iterative, meaning that each phase may be revisited multiple times
The goal is to produce ...
- Q3. Are you aware about agile?
- Ans.
Yes, Agile is a project management methodology that emphasizes on iterative and incremental development.
Agile is based on the Agile Manifesto which values individuals and interactions, working software, customer collaboration, and responding to change.
It involves breaking down the project into smaller chunks called sprints and delivering a working product incrementally.
Scrum, Kanban, and Extreme Programming (XP) are so...
- Q4. How to form query in sql
- Ans.
To form a query in SQL, use the SELECT statement followed by the columns to retrieve and the table to retrieve from.
Use the SELECT statement to specify the columns to retrieve
Use the FROM keyword to specify the table to retrieve from
Use the WHERE keyword to specify any conditions for the query
Use the ORDER BY keyword to specify the order of the results
Use the GROUP BY keyword to group the results by a specific column
Us...
- Q5. I told about select attributes, from table name and where conditions required.
Interview Preparation Tips
Skills evaluated in this interview
TCS interview questions for designations
I applied via Walk-in and was interviewed before Sep 2021. There was 1 interview round.
(6 Questions)
- Q1. Its a sitting job so are you able to comfortable to do this job as you came from background which having field job?
- Q2. Which location you prefer?
- Q3. Are you aware that there will be a bond for one year of employment?
- Q4. Why you want to join TCS
- Q5. You have done MBA and yours CGPA us very good? How to bring this much CGPA
- Q6. Anything you want to ask from me?
Interview Preparation Tips
Interview questions from similar companies
I applied via InfyTQ and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. What is difference between ML and IOT
- Ans.
ML and IoT are different technologies. ML focuses on data analysis and prediction, while IoT focuses on connecting devices and collecting data.
ML stands for Machine Learning, which is a subset of Artificial Intelligence that focuses on algorithms and models to analyze and interpret data.
ML is used to train models and make predictions or decisions based on patterns and trends in data.
Examples of ML applications include ...
Interview Preparation Tips
Skills evaluated in this interview
Linux System Administrator Interview Questions & Answers
LTIMindtree
Anonymous
posted on 19 Dec 2024
Selected
I applied via campus placement at NBKR Institute of Science and Technology, Vidyanagar and was interviewed in Nov 2024. There were 4 interview rounds.
It was about an aptitude test which is on English grammar and athematic reasoning.
The Fibonacci series can be applied to alphabets, and the same should be printed.
(2 Questions)
- Q1. Fibonancci series to print the alphabets?
- Q2. Print the numbers in descending order 123456?
- Ans.
Print numbers in descending order 123456
Create an array of strings containing the numbers 1 to 6
Sort the array in descending order
Print the sorted array
(3 Questions)
- Q1. Why are you choosing our organization?
- Ans.
I am choosing your organization because of its reputation for innovation, strong company culture, and opportunities for growth.
Reputation for innovation in the industry
Strong company culture that values employee development
Opportunities for growth and advancement within the organization
- Q2. Are you open to relocation?
- Ans.
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for the right job opportunity that aligns with my career goals.
I am open to exploring new locations and experiencing different cultures.
I understand that relocation may be necessary for career advancement and personal growth.
- Q3. Are you comfortable with rotational shifts?
- Ans.
Yes, I am comfortable with rotational shifts as I have prior experience working in such shifts.
I have previous experience working in rotational shifts at my previous job.
I am adaptable and can easily adjust my schedule to accommodate rotational shifts.
I understand the importance of being available during different shifts to ensure smooth operations.
I am willing to work in rotational shifts to support the team and meet
Interview Preparation Tips
Selected
(6 Questions)
- Q1. Describe microservice architecture for an e-commerce platform
- Ans.
Microservice architecture for e-commerce platform involves breaking down the application into smaller, independent services.
Each service is responsible for a specific business function, such as inventory management or payment processing.
Services communicate with each other through APIs, allowing for flexibility and scalability.
Each service can be developed, deployed, and scaled independently, making it easier to mainta...
- Q2. What is the SAGA pattern?
- Ans.
The SAGA pattern is a design pattern used in distributed systems for managing long-lived transactions.
SAGA pattern breaks down a long transaction into a series of smaller, more manageable transactions.
Each smaller transaction is executed independently and can be compensated if needed.
SAGA pattern helps maintain consistency and reliability in distributed systems.
Example: In an e-commerce system, the SAGA pattern can be ...
- Q3. How Apache Kafka can be used to across multiple producers and consumers across Kafka cluster ?
- Ans.
Apache Kafka can be used to enable communication between multiple producers and consumers across a Kafka cluster.
Producers can publish messages to specific topics in the Kafka cluster.
Consumers can subscribe to these topics and receive messages in real-time.
Kafka ensures fault tolerance and scalability by distributing data partitions across multiple brokers.
Producers and consumers can be distributed across different no...
- Q4. Core Java Questions like Streams API, few problems to solve with flat mapping
- Q5. Core Spring Boot questions
- Q6. DS questions : 2sum problems ,(solve using compliment method), mergesort pseudo code
Interview Preparation Tips
Skills evaluated in this interview
Selected
I was interviewed in Oct 2024.
(2 Questions)
- Q1. Design patterns
- Q2. Sql interview questions
(2 Questions)
- Q1. Case study about the given requirement
- Q2. Springboot basic questions
Interview Preparation Tips
First round > General aptitude and versant test.
(3 Questions)
- Q1. How to manage VDI?
- Ans.
VDI can be managed by monitoring performance, updating software, optimizing resources, and ensuring security.
Monitor performance regularly to identify any issues or bottlenecks.
Update VDI software and patches to ensure system stability and security.
Optimize resources by balancing workloads and adjusting configurations as needed.
Ensure security measures are in place, such as encryption, access controls, and regular back...
- Q2. O365 services and it's related questions.
- Q3. Questions on cloud computing, cloud services.
Interview Preparation Tips
Skills evaluated in this interview
TCS Interview FAQs
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
- System Engineer Interview Questions
- System Administrator Interview Questions
- Senior Systems Engineer Interview Questions
- Assistant System Engineer Interview Questions
- System Analyst Interview Questions
- System Engineer Hardware Interview Questions
- Associate Systems Engineer Interview Questions
- Linux System Administrator Interview Questions
- Show more
TCS Assistant System Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
TCS Assistant System Analyst Reviews and Ratings
based on 75 reviews
Rating in categories
|
System Engineer
1.1L
salaries
|  ₹1 L/yr - ₹9 L/yr |
|
IT Analyst
67.4k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
|
AST Consultant
51.3k
salaries
| ₹8 L/yr - ₹25 L/yr |
|
Assistant System Engineer
29.9k
salaries
| ₹2.2 L/yr - ₹8 L/yr |
|
Associate Consultant
29k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture
- Home >
- Interviews >
- TCS Interview Questions >
- TCS Assistant System Analyst Interview Questions
