i
LTIMindtree
Filter interviews by
I appeared for an interview 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 appeared for an interview 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 LinkedIn and was interviewed before Sep 2021. There were 3 interview rounds.
Good problemtic Skills and knowledge check and sharpness
C Language use for programs and Oracle and Java in learning process
Yes, there are many operators and logical programs used in various fields.
Operators like +, -, *, / are used in mathematical calculations.
Logical programs like if-else, switch-case are used in programming.
Operators like AND, OR, NOT are used in boolean logic.
Operators like >, <, == are used in comparisons.
Examples of logical programs include sorting algorithms, search algorithms, etc.
based on 7 interviews
1 Interview rounds
based on 4 reviews
Rating in categories
Senior Software Engineer
21.4k
salaries
| ₹5.1 L/yr - ₹19 L/yr |
Software Engineer
16.2k
salaries
| ₹2 L/yr - ₹10 L/yr |
Technical Lead
6.4k
salaries
| ₹9.4 L/yr - ₹30 L/yr |
Module Lead
5.9k
salaries
| ₹7 L/yr - ₹25 L/yr |
Senior Engineer
4.4k
salaries
| ₹4.2 L/yr - ₹16.5 L/yr |
Cognizant
Capgemini
Accenture
TCS