Tata Indicom Interview Questions and Answers

Q1. Could you elaborate on your roles and responsibilities in your previous employment?
Add your answer
Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
Add your answer
Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
Add your answer
Q4. Guesstimates like how many traffic signals are there in Noida.
Add your answer
Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Add your answer

Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...read more
Add your answer

Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Add your answer

Q1. Final round will be an HR round.
Add your answer

Q1. Asked about Dotnet Core Questions about Program.cs file use case, DI, Services, Architectural patterns, and jumped to Linq complex queries and SQL queries. Before that Deep analysis of background work
Add your answer
Q2. Use of Program.cs
Add your answer
Q3. Middleware and Services
Add your answer
Q4. Dependency Injection
Add your answer
Q5. Authentication & Authorization
Add your answer

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Q1. Clustering and partition difference in data warehousing solutions
Ans. 
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
• Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

• Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

• Clustering is often used for data a...read more
Answered by AI
Add your answer
Q2. What are the different approaches to Optimising SQL
Ans. 
Different approaches to optimizing SQL include indexing, query optimization, and database design.
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate functions

• Design the database schema efficiently to reduce redundancy and improve data retrieval speed
Answered by AI
Add your answer
Q3. Spark and it’s architecture
Add your answer
Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
Ans. 
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
• Aggregate the data by customer and item purchased

• Filter out transactions from February

• Count the number of items bought by each customer
Answered by AI
Add your answer

Q1. What is Object-Oriented Programming (OOP), and can you explain its fundamental concepts?
Add your answer
Q2. What is the definition of an array, and what are the different types of arrays?
Add your answer
Q3. What is the clr
Add your answer

The content is based on HTML, Windows, and ADO.NET.

Q1. What motivates you to pursue this job?
Add your answer
Q2. What is your expected salary?
Add your answer

Q1. Are you willing to do this job
Add your answer
Q2. U have to manage ur team
Add your answer
Q3. Salary expectation
Add your answer

Q1. About myself and family
Add your answer
Q2. Regarding the job
Add your answer

First time interview given by me

First time interview given by me

First time interview given by me

Q1. Only up west location required
Add your answer

Q1. What is the sallery
Add your answer

Q1. What is Job security
Add your answer

Q1. Need Only fiber execution job
Add your answer

Q1. Pcap analysis and log analysis
Add your answer
Q2. Feature testing
Add your answer

Q1. Kubernetes and docker
Add your answer
Q2. Amazon web service
Add your answer

Q1. 100k feet over view
Ans. 
A high-level overview of a topic or project, typically focusing on key points and goals.
• Summarize the main objectives and goals of the project

• Highlight key milestones and deliverables

• Provide a brief overview of the team structure and roles

• Discuss any potential challenges or risks

• Outline the overall impact and benefits of the project
Answered by AI
Add your answer
Q2. Technical overview of all technology
Add your answer

Q1. Difference between concepts
Ans. 
Difference between concepts refers to the distinctions or contrasts between two or more ideas, theories, or principles.
• Concepts are abstract ideas or mental representations, while differences are variations or distinctions between them.

• Understanding the difference between concepts helps clarify their meanings and applications.

• For example, the difference between velocity and speed in physics is that velocity includes di
Answered by AI
Add your answer
Q2. Basic understanding of concepts and technology
Add your answer

Q1. Salary expectation
Add your answer
Q2. Why you want to jump
Add your answer

Q1. What are the different optimization techniques used in your project
Add your answer
Q2. SQl logic question regarding joins
Add your answer

Q1. Related to the optical fibre cable
Add your answer
Q2. OTDR traces
Add your answer

A test that measures your ability to succeed at something

Q1. Hard work, dedication, potential,
Add your answer
Q2. Master mind for the ofc work
Ans. 
The mastermind for the office work is someone who is highly skilled, organized, and able to effectively manage and coordinate various tasks and projects.
• Strong technical skills in networking and IT infrastructure

• Excellent problem-solving abilities

• Effective communication and teamwork skills

• Ability to prioritize and multitask

• Experience with project management tools and software

• Examples: Cisco Certified Network Profession...read more
Answered by AI
Add your answer

Team work any planning work discussed our team for clearing our work and complete our task