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

Clear (1)

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 Resume 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 Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic communication skills were tested. Sone techical questn too. Versant test is mandatory

Interview Preparation Tips

Interview preparation tips for other job seekers - Please never go for these third party vendors. They misguide you regarding profile . I went for this third party vendor named savantis solution and it really misguided me

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - just basic questions from my cv

Analyst Interview Questions & Answers

Wipro user image Anonymous

posted on 23 Feb 2021

Interview Questionnaire 

1 Question

  • Q1. Previous Project Experience
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

LIST OF COMPANIES

Prayagraj Power Generation

Overview

REVIEWS

Sierra Instrumentation & Controls

No Reviews

INTERVIEWS

Raymond Lifestyle Limited

No Interviews

INTERVIEWS

Sun Metal Industries

No Interviews

INTERVIEWS

NTT Data

No Interviews

INTERVIEWS

Capgemini

No Interviews

INTERVIEWS

ReachLocal Services

No Interviews

INTERVIEWS

MiQ Digital

No Interviews

REVIEWS

6D Technologies

No Reviews

INTERVIEWS

Finulent Solutions

No Interviews

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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent