LTIMindtree Data Engineer Interview Questions, Process, and Tips

Q1. Questions related to spark and hadoop
Add your answer

Q1. How can you optimize SSIS package
Ans. 
Optimizing SSIS package involves reducing memory usage, improving data flow, and using efficient transformations.
• Use data flow task instead of multiple transformations

• Use buffer size optimization

• Use fast load option for bulk data transfer

• Avoid using unnecessary columns in data flow

• Use parallelism for faster execution

• Use appropriate data types for columns

• Use indexes for faster lookup

• Use logging and error handling for de
Answered by AI
Add your answer

Basic aptitude questions

Q1. They ask basic questions for f oops programs and different between c++ and c
Add your answer

Q1. They ask basic questions of education background
Add your answer
Q2. Why did you choose lti
Add your answer

Quants, psychological questions, basic programming and syntax along with a program to solve

Twelve members groups discussion on general topics

Q1. Questions regarding relocation
Add your answer
Q2. Tel me something interesting about yourself
Ans. 
I am an avid traveler and have visited over 20 countries.
• I love exploring new cultures and experiencing different cuisines.

• Some of my favorite travel destinations include Japan, Italy, and Thailand.

• I enjoy documenting my travel experiences through photography and blogging.

• Traveling has taught me to be adaptable and open-minded, which are valuable skills in the data engineering field.
Answered by AI
View 1 more answer