I applied through a recruiter. The process took 1 day. I interviewed at LTIMindtree (Sat home) in Nov 2024
Interview
Screening: HR called and asked about current project, past assignments, technologies & tools worked upon etc
Technical Round:
30 mins
Questions were easy and related to ETL Testing, SQL and relational databases. I answered all questions correctly.
Interview questions [1]
Question 1
ETL Scenario based questions
Describe data warehousing, and it's components.
OLTP, OLAP, SCD, Normalisation, Denormalisation
Basic SQL queries including outer joins, pattern matching etc
I applied through a staffing agency. I interviewed at LTIMindtree (Bengaluru) in Oct 2024
Interview
- 1. Interview was scheduled for 30 mins.
2. Interviewer joined 2 mins late and first question was asked about program. Due to syntax mistakes, I didn't get proper output. But I have explained the logic. Later asked 2 more questions in selenium and told interview was done. For the above process it took 20 mins.
3. I have asked why only 3 questions. Interviewer told like she is running out of time but till 10 mins is available according to the schedule time.
4. I am not sure; how come she is going to decide based 3 questions whether i am capable or not.
If they don't have time, then they can schedule interviews based on availability.
5. Don't waste your time by attending such interviews.
Interview questions [3]
Question 1
Write a program to count number of vowels in a string?
I applied through a recruiter. I interviewed at LTIMindtree (Bengaluru) in Mar 2023
Interview
It was very professional yet good experience. Total 3 rounds happened and one more client interview round also happened. Entire procedure was very smooth and also got a lot of co operation from recruiting HR.