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 appeared for an interview 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 appeared for an interview 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)

 Senior Software Tester

 (2)

 Selenium Automation 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

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 30 Sep 2022

I applied via LinkedIn and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Good problemtic Skills and knowledge check and sharpness

Round 2 - Coding Test 

C Language use for programs and Oracle and Java in learning process

Round 3 - HR 

(3 Questions)

  • Q1. Any coding Question and stay for job purpose
  • Q2. Any operators working or any logical program tell
  • Ans. 

    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.

  • Answered by AI
  • Q3. Check my comutication with others

Interview Preparation Tips

Topics to prepare for TCS Analyst interview:
  • c and
Interview preparation tips for other job seekers - good guide for my job purpose so best choose to our qualification

Interview Questionnaire 

1 Question

  • Q1. Related to my subject

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 17 Oct 2021

Interview Questionnaire 

1 Question

  • Q1. About ur self

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well.... prepare well

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.4k salaries
unlock blur

₹5.1 L/yr - ₹19 L/yr

Software Engineer
16.2k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Technical Lead
6.4k salaries
unlock blur

₹9.4 L/yr - ₹30 L/yr

Module Lead
5.9k salaries
unlock blur

₹7 L/yr - ₹25 L/yr

Senior Engineer
4.4k salaries
unlock blur

₹4.2 L/yr - ₹16.5 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