Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by LTIMindtree Team. If you also belong to the team, you can get access from here

LTIMindtree Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

LTIMindtree ETL Tester Interview Questions and Answers

Updated 23 Dec 2024

LTIMindtree ETL Tester Interview Experiences

7 interviews found

ETL Tester Interview Questions & Answers

user image Lavanya Shankar

posted on 2 Dec 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Nov 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Append a item in tuple
  • Q2. How to validate response body in api in restapi

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 5 May 2024

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Apr 2024. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Questions on ETL concepts
  • Q2. Find the nth row. Find the top 50% records, string function
  • Ans. 

    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

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. Agile ceremonies
  • Q2. SQL to find age from dob
  • Ans. 

    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.

  • Answered by AI
  • Q3. SQL on string function
  • Q4. Row number, Rank, Dense Rank
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion, Niche skills
Round 4 - Technical 

(1 Question)

  • Q1. Questions on MDM testing

Interview Preparation Tips

Interview preparation tips for other job seekers - It is the worst experience ever with LTIMindtree. After having so many rounds, they have offer me to join on 60% on my current CTC. The asks is very clear from the day one. They have wasted my 1 month on the whole process. If they couldn’t afford me why they have even initiated the process. I would recommend don’t waste your time for LTIMindtree. Better to find other opportunities.

Skills evaluated in this interview

ETL Tester Interview Questions Asked at Other Companies

asked in Cognizant
Q1. If we have 200 staging tables, 40 dimensions tables and 20 facts ... read more
asked in Cognizant
Q2. 2.Difference between Union and union all,drop and Truncate,star s ... read more
Q3. What is the difference between Test Plan and Test strategy
asked in Cognizant
Q4. Which type of Validation you will do at Landing and staging area.
asked in Infosys
Q5. How do you get data integrity between source and destination, how ... read more

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 23 Mar 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Feb 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. What is Slowly Changing Dimensions?
  • Ans. 

    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...

  • Answered by AI
  • Q2. What are the joins you have used in your project?

Interview Preparation Tips

Interview preparation tips for other job seekers - Difficulty level average.

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 8 Oct 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Introduce Yourself
  • Ans. 

    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

  • Answered by AI
  • Q2. Project description and sql queries

LTIMindtree interview questions for designations

 ETL Developer

 (1)

 Tester

 (2)

 Software Tester

 (4)

 Automation Tester

 (4)

 Selenium Automation Tester

 (2)

 Senior Software Tester

 (2)

 Software Automation Tester

 (1)

 ETL Abinitio Developer

 (1)

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 23 Dec 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Coding Test 

It was a coding test with multiple advance SQL queries and ETL testing technology.

ETL Tester Interview Questions & Answers

user image Srinivasulu B

posted on 12 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Rank, row_number
  • Q2. Union union all

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 12 Dec 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed before Dec 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

SQL based and aws based

Round 3 - Technical 

(1 Question)

  • Q1. More on azure data factory

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions only ... regarding job and experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident ... always say the truth ... never try to fake your details

I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Why Java is platform independent?
  • Ans. 

    Java is platform independent due to its bytecode and JVM.

    • Java code is compiled into bytecode which is platform-independent.

    • JVM (Java Virtual Machine) interprets the bytecode and executes it on any platform.

    • JVM acts as an abstraction layer between the Java code and the underlying hardware.

    • This allows Java programs to run on any platform that has a JVM installed.

    • For example, a Java program written on a Windows machine ca...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Java is platform-independent because it does not depend on any type of platform. Hence, Java is platform-independent language. In Java, programs are compiled into byte code and that byte code is platform-independent. ... Any machine to execute the byte code needs the Java Virtual Machine.

Skills evaluated in this interview

I applied via Walk-in and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Its for FP&A process and the major questions were from the basics of FP&A. How it starts and how its ends and Previous job roles.

Interview Preparation Tips

Interview preparation tips for other job seekers - It's quite a moderate interview but be prepare for more rounds of technical interviews.

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree ETL Tester interview?
LTIMindtree interview process usually has 1-2 rounds. The most common rounds in the LTIMindtree interview process are Technical, Coding Test and Resume Shortlist.
How to prepare for LTIMindtree ETL Tester interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at LTIMindtree. The most common topics and skills that interviewers at LTIMindtree expect are Database Testing, DWH Testing, ETL Testing, SQL and Bi Testing.
What are the top questions asked in LTIMindtree ETL Tester interview?

Some of the top questions asked at the LTIMindtree ETL Tester interview -

  1. Find the nth row. Find the top 50% records, string funct...read more
  2. What is Slowly Changing Dimensio...read more
  3. SQL to find age from ...read more

Tell us how to improve this page.

LTIMindtree ETL Tester Interview Process

based on 7 interviews

1 Interview rounds

  • Technical Round
View more
LTIMindtree ETL Tester Salary
based on 215 salaries
₹2.7 L/yr - ₹11.5 L/yr
At par with the average ETL Tester Salary in India
View more details

LTIMindtree ETL Tester Reviews and Ratings

based on 4 reviews

4.1/5

Rating in categories

3.4

Skill development

3.8

Work-life balance

4.4

Salary

3.8

Job security

3.8

Company culture

2.8

Promotions

3.8

Work satisfaction

Explore 4 Reviews and Ratings
Senior Software Engineer
21.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
16.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
6.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Module Lead
5.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Engineer
4.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare LTIMindtree with

Cognizant

3.7
Compare

Capgemini

3.7
Compare

Accenture

3.8
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview