i
LTIMindtree
Filter interviews by
Clear (1)
I was interviewed in Nov 2024.
I applied via Referral and was interviewed in Apr 2024. There were 4 interview rounds.
Use SQL query to find the nth row and top 50% records using string function
To find the nth row, use LIMIT and OFFSET in SQL query
To find top 50% records, use PERCENTILE_CONT function in SQL
String functions like SUBSTRING can be used to manipulate string data
Use SQL DATEDIFF function to calculate age from date of birth.
Use DATEDIFF function to calculate the difference in years between current date and date of birth.
Example: SELECT DATEDIFF(year, '2000-01-01', GETDATE()) AS Age;
Make sure to handle leap years and edge cases like birthdate being in the future.
I was interviewed in Feb 2024.
Slowly Changing Dimensions (SCD) are techniques used in data warehousing to track changes to dimension data over time.
SCD Type 1: Overwrites old data with new data, losing historical information.
SCD Type 2: Creates new records for each change, preserving historical data.
SCD Type 3: Creates additional columns to track changes, allowing limited history.
SCD Type 4: Uses separate tables to store historical and current data...
What people are saying about LTIMindtree
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
I am a dedicated ETL Tester with 5 years of experience in testing data integration processes and ensuring data quality.
5 years of experience in ETL testing
Proficient in testing data integration processes
Skilled in ensuring data quality
Strong attention to detail
Excellent problem-solving skills
LTIMindtree interview questions for designations
I applied via Walk-in and was interviewed in Jun 2024. There was 1 interview round.
It was a coding test with multiple advance SQL queries and ETL testing technology.
I applied via Naukri.com and was interviewed before Dec 2022. There were 3 interview rounds.
SQL based and aws based
I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.
based on 7 interviews
1 Interview rounds
based on 4 reviews
Rating in categories
Senior Software Engineer
21.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
16.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
6.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Module Lead
5.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Engineer
4.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
Capgemini
Accenture
TCS