Tech Mahindra Technical Lead Interview Questions, Process, and Tips

REST API is a web service that uses HTTP methods to interact with resources. GET, PUT, POST, DELETE, MERGE, PATCH are different methods.

• REST API is a stateless architecture that uses HTTP methods to interact with resources.

• GET method is used to retrieve data from a server.

• PUT method is used to update an existing resource on the server.

• POST method is used to create a new resource on the server.

• DELETE method is used to d...read more

Caching can speed up request response. Popular caches include Redis, Memcached, and browser caching.

• Caching stores frequently accessed data in memory for faster retrieval

• Browser caching stores static assets like images and CSS files

• Redis and Memcached are popular in-memory caching solutions for web applications

• Cache invalidation is important to ensure data consistency

JWT token is used to secure endpoints in REST APIs by providing authentication and authorization.

• JWT stands for JSON Web Token

• It is a compact, URL-safe means of representing claims to be transferred between two parties

• It is used for authentication and authorization

• It contains three parts: header, payload, and signature

• The header contains the algorithm used to sign the token

• The payload contains the claims or information...read more

Angular code to fetch and display JSON response in tabular format.

• Use HttpClient module to make an HTTP GET request to the given URL.

• Subscribe to the response and extract the JSON data.

• Create an Angular component to display the data in a tabular format using HTML and CSS.

Table with Joins

• Joins are used to combine rows from two or more tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

Date Trunc in Tableau is used to truncate date values to a specified level of granularity.

• Date Trunc function is used to truncate date values to a specific level of granularity, such as year, quarter, month, etc.

• It helps in aggregating data at a higher level of detail than the original date field.

• Example: DATE_TRUNC('month', [Order Date]) will truncate the date values to the month level.

4G attach procedures involve multiple messages exchanged between the UE and the network.

• UE sends attach request to the network

• Network validates the request and assigns temporary identities to the UE

• Network sends attach accept message to UE

• UE sends attach complete message to network to complete the attach procedure

Facing real-time KPI issues related to data accuracy and system performance

• Data inconsistency leading to inaccurate KPI calculations

• System lag affecting real-time updates of KPI metrics

• Difficulty in integrating data from multiple sources for comprehensive KPI analysis