LTIMindtree Technical Lead Interview Questions, Process, and Tips

Q1. Azure cloud platform tech
Add your answer
Q2. Informatica tech stack ques
Add your answer

Q1. Adf tech stack que
Add your answer
Q2. Scd type 2 implementation
Ans. 
SCD Type 2 implementation involves tracking historical changes in data by creating new records for each change.
• Identify the columns that need to be tracked for changes

• Add effective start and end dates to track the validity of each record

• Insert new records for changes and update end dates for previous records

• Maintain a surrogate key to uniquely identify each version of the record
Answered by AI
Add your answer

Q1. Dw related que ans
Add your answer
Q2. Solution design related que
Add your answer

Q1. Aspiration from my end
Add your answer
Q2. How soon can join
Ans. 
I can join the team within 2 weeks.
• I can start within 2 weeks of receiving the offer.

• I need to give notice to my current employer.

• I may need to relocate, which could affect my start date.
Answered by AI
Add your answer

Q1. Technical Questions With respect to Domain
Add your answer
Q2. Job Duties
Add your answer

Q1. Salary, benefits and company policies
Add your answer
Q2. HR related questions
Add your answer

How did the CI CD process implemented in your current project?

Q1. General questions posed by practically every director in the final round.
Add your answer

Q1. What is bgp and metrics
Ans. 
BGP (Border Gateway Protocol) is a routing protocol used to exchange routing information between different networks. Metrics are values used to determine the best path for data to travel.
• BGP is used to route traffic between different autonomous systems (AS)

• Metrics in BGP include attributes like AS path length, local preference, and MED (Multi-Exit Discriminator)

• BGP uses these metrics to determine the best path for data...read more
Answered by AI
Add your answer
Q2. What is ospf and it’s cost
Ans. 
OSPF (Open Shortest Path First) is a routing protocol used to determine the best path for data packets in a network.
• OSPF is a link-state routing protocol

• It uses Dijkstra's algorithm to calculate the shortest path

• Cost in OSPF is a metric used to determine the best path, calculated based on bandwidth of the link

• Cost is inversely proportional to the bandwidth, higher bandwidth means lower cost

• Example: A link with bandwidt...read more
Answered by AI
Add your answer
Q3. What is stateful firewall
Ans. 
Stateful firewall is a type of firewall that keeps track of the state of active connections and makes decisions based on the context of the traffic.
• Stateful firewalls monitor the state of active connections and make decisions based on the context of the traffic

• They keep track of the state of each connection by maintaining a state table

• Stateful firewalls can filter traffic based on the state of the connection, such as a...read more
Answered by AI
Add your answer
Q4. What is tcp handshake
Ans. 
TCP handshake is a process where two devices establish a connection by exchanging synchronization and acknowledgment packets.
• Three-way process involving SYN, SYN-ACK, and ACK packets

• Initiated by client sending a SYN packet to server

• Server responds with a SYN-ACK packet

• Client acknowledges with an ACK packet to complete the handshake

• Ensures reliable and orderly connection establishment
Answered by AI
Add your answer
Q5. How you upgrade Palo Alto
Ans. 
Upgrade Palo Alto involves planning, testing, and executing the upgrade process to ensure minimal downtime and maximum security.
• Plan the upgrade by reviewing release notes and compatibility matrix

• Backup current configuration and settings

• Test the upgrade in a lab environment before applying to production

• Schedule a maintenance window for the upgrade

• Monitor the upgrade process and verify functionality post-upgrade
Answered by AI
Add your answer