i
TCS
Filter interviews by
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
I am a Senior Data Engineer with experience in building scalable data pipelines and optimizing data processing workflows.
Experience in designing and implementing ETL processes using tools like Apache Spark and Airflow
Proficient in working with large datasets and optimizing query performance
Strong background in data modeling and database design
Worked on projects involving real-time data processing and streaming analytic
Decorators in Python are functions that modify the behavior of other functions or methods.
Decorators are defined using the @decorator_name syntax before a function definition.
They can be used to add functionality to existing functions without modifying their code.
Decorators can be used for logging, timing, authentication, and more.
Example: @staticmethod decorator in Python is used to define a static method in a class.
SQL query to group by employee ID and combine first name and last name with a space
Use the GROUP BY clause to group by employee ID
Use the CONCAT function to combine first name and last name with a space
Select employee ID, CONCAT(first_name, ' ', last_name) AS full_name
Constructors in Python are special methods used for initializing objects. They are called automatically when a new instance of a class is created.
Constructors are defined using the __init__() method in a class.
They are used to initialize instance variables of a class.
Example: class Person: def __init__(self, name, age): self.name = name self.age = age person1 = Person('Alice', 30)
Indexing in SQL is a technique used to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition in a WHERE clause.
Indexes can be created using CREATE INDEX statement in SQL.
Types of indexes include clustered indexes, non-clustered indexes, unique indexes, an...
Spark works well with Parquet files due to its columnar storage format, efficient compression, and ability to push down filters.
Parquet files are columnar storage format, which aligns well with Spark's processing model of working on columns rather than rows.
Parquet files support efficient compression, reducing storage space and improving read performance in Spark.
Spark can push down filters to Parquet files, allowing f...
Rate your
company
🤫 100% anonymous
How was your last interview experience?
As a Business Process Leader, I oversee and optimize the processes within a company to improve efficiency and productivity.
Analyze current processes to identify inefficiencies
Develop and implement strategies to streamline processes
Collaborate with various departments to ensure smooth workflow
Monitor and evaluate process performance to make necessary adjustments
Train employees on new processes and technologies
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.
Various data warehousing techniques include dimensional modeling, star schema, snowflake schema, and data vault.
Dimensional modeling involves organizing data into facts and dimensions to facilitate easy querying and analysis.
Star schema is a type of dimensional modeling where a central fact table is connected to multiple dimension tables.
Snowflake schema is an extension of star schema where dimension tables are normali...
My analytics work has helped the organization make data-driven decisions, improve operational efficiency, and identify new opportunities for growth.
Developed data models and algorithms to optimize business processes
Generated insights from large datasets to drive strategic decision-making
Identified trends and patterns to improve customer experience and retention
Implemented data governance policies to ensure data quality
I would respond in various situations by remaining calm, assessing the situation, and providing a thoughtful and strategic solution.
Remain calm and composed
Assess the situation thoroughly
Provide a thoughtful and strategic solution
Communicate effectively with all parties involved
Both career and team are important, but ultimately career growth should be prioritized.
Career growth is essential for personal development and achieving professional goals.
A strong team can support career growth by providing mentorship, collaboration, and opportunities for learning.
Balancing career and team dynamics is key to long-term success in any role.
What people are saying about TCS
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
TCS interview questions for popular designations
I was interviewed in Dec 2024.
Get interview-ready with Top TCS Interview Questions
I was interviewed in Jan 2025.
On round apptitude test reasoning
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
An aptitude test that needs to be completed at the TCS iON center.
The Sieve of Eratosthenes is an optimized algorithm to generate prime numbers.
Use the Sieve of Eratosthenes algorithm to efficiently generate prime numbers.
Start by creating a list of numbers from 2 to n, where n is the maximum number you want to check for primes.
Iterate through the list and mark multiples of each number as non-prime.
The remaining unmarked numbers are prime.
Example: For n=10, the prime numbers generate
I was interviewed in Dec 2024.
Numerical aptitude test, logical reasoning test, and technical aptitude test.
Case study GD, topic based GD,Role_play GD
I am a software developer with 5 years of experience in Java, Python, and SQL.
5 years of experience in Java, Python, and SQL
Strong problem-solving skills
Experience working in Agile development environment
Familiarity with version control systems like Git
I found this role through a job posting on LinkedIn.
Saw job posting on LinkedIn
Applied through company website
Referred by a friend who works at the company
My long term career goal is to become a senior software architect and lead a team of developers to create innovative solutions.
Work towards gaining expertise in various programming languages and technologies
Take on leadership roles in projects to develop management and communication skills
Attend industry conferences and workshops to stay updated on latest trends and advancements
Seek opportunities for mentorship and pro
Your company is a leading software development firm specializing in creating innovative solutions for various industries.
Your company has a strong reputation for delivering high-quality software products.
You have a diverse portfolio of clients from different industries.
Your company values innovation and creativity in software development.
Your team is known for its expertise in cutting-edge technologies like AI and bloc...
My favorite programming language is Python because of its simplicity, readability, and versatility.
Python is known for its clean and readable syntax, making it easy to learn and understand.
Python has a large standard library with built-in modules for various tasks, reducing the need for external libraries.
Python is versatile and can be used for web development, data analysis, artificial intelligence, and more.
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
Objects are instances of classes, which define the structure and behavior of the objects.
Encapsulation is the concept of bundling data and methods that operate on the data within a single unit, such as a class.
Inheritance allows classes to inherit attribu...
I was interviewed in Jan 2025.
The aptitude test is designed to assess knowledge.
Studied technical questions related to networking, programming languages, databases, and system administration.
Networking concepts like TCP/IP, DNS, DHCP
Programming languages such as Python, Java, Shell scripting
Database management including SQL queries, normalization
System administration tasks like user management, file permissions
I studied Computer Science with core subjects in programming, algorithms, databases, and networking.
Studied Computer Science with focus on programming languages like Java, C++, Python
Core subjects included algorithms and data structures
Also studied databases and networking principles
Took courses in software engineering and system administration
I was interviewed in Dec 2024.
The duration of TCS interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 8.5k interviews
Interview experience
Anonymously discuss salaries, work culture, and many more
Get Ambitionbox App
based on 89.7k reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
66.7k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
AST Consultant
51.5k
salaries
| ₹8 L/yr - ₹25 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.8 L/yr |
Associate Consultant
29.4k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture