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 Developer Interview Questions and Answers

Updated 23 Jan 2023

LTIMindtree ETL Developer Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 23 Jan 2023

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

I applied via Campus Placement and was interviewed before Jan 2022. There were 4 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 - Assignment 

It's an assignment for apti, verbal

Round 3 - Technical 

(1 Question)

  • Q1. It's like an what are u mentioned in resume skills.
Round 4 - HR 

(1 Question)

  • Q1. Just like interaction with candidate like personal details.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare on what u mentioned in resume skills and self confidence..

Interview questions from similar companies

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

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Which version of talend you are using
  • Ans. 

    I am using Talend version 7.3.1 for ETL development.

    • I am currently using Talend version 7.3.1 for ETL development.

    • The specific version of Talend being used is 7.3.1.

    • Talend 7.3.1 offers various features and improvements for ETL processes.

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

4 Questions

  • Q1. Whats is mapping
  • Ans. 

    Mapping is the process of defining the relationship between source and target data in ETL.

    • Mapping involves identifying the source and target data structures.

    • It also involves defining the transformation rules to be applied to the source data.

    • Mappings can be simple or complex depending on the complexity of the data.

    • Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target

  • Answered by AI
  • Q2. What is sesson
  • Ans. 

    Session refers to a period of time during which a user interacts with a computer system or application.

    • A session is created when a user logs into a system or application.

    • It is used to track user activity and maintain user-specific data.

    • Sessions can be terminated manually or automatically after a certain period of inactivity.

    • Session management is important for security purposes.

    • Examples of session management techniques

  • Answered by AI
  • Q3. Which role u did
  • Q4. Oracle sqi pl sqi
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Introduce yourself
  • Ans. 

    I am an experienced ETL Developer with a strong background in data integration and transformation.

    • Over 5 years of experience in ETL development

    • Proficient in using tools like Informatica, Talend, and SSIS

    • Strong SQL skills for data querying and manipulation

    • Experience in designing and implementing data warehouses

    • Familiar with data modeling and ETL best practices

  • Answered by AI
  • Q2. What is SCD type2
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Greatest challenge faced while migrating to cloud from onpremise DB
  • Ans. 

    The greatest challenge faced during migration to cloud from on-premise DB is ensuring data security and compliance.

    • Ensuring data security during transit and at rest

    • Maintaining compliance with regulations and industry standards

    • Minimizing downtime and ensuring data integrity

    • Optimizing performance and cost efficiency in the cloud environment

  • Answered by AI

Skills evaluated in this interview

ETL Developer Interview Questions & Answers

TCS user image Vikash Kumar

posted on 21 Oct 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
Selected Selected

I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Lookup transformation
  • Q2. Joiner transformation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Informatica power centre transformation questions

I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Introduction, projects worked, technology stack, scenario based questions, challenges
Round 2 - HR 

(1 Question)

  • Q1. Salary negotiation and general discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay confident and be open with the answers.

ETL Developer Interview Questions & Answers

Tech Mahindra user image RAMAVATHULA CHANDRA NAIK

posted on 4 Feb 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. They were asking very logical and technical questions on interview time
  • Q2. They were test our skills and time punctuation
Round 2 - HR 

(1 Question)

  • Q1. They were discussed with some technical questions and based on knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - They were asking technical questions and based on our resume mentioned questions

I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. General, project overview, technology stack, scenario based questions, challenges and experiences
Round 2 - HR 

(1 Question)

  • Q1. General, salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be genuine and share your experiences

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree ETL Developer interview?
LTIMindtree interview process usually has 4 rounds. The most common rounds in the LTIMindtree interview process are Resume Shortlist, Assignment and Technical.

Tell us how to improve this page.

LTIMindtree ETL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
LTIMindtree ETL Developer Salary
based on 187 salaries
₹2.5 L/yr - ₹10.8 L/yr
At par with the average ETL Developer Salary in India
View more details

LTIMindtree ETL Developer Reviews and Ratings

based on 4 reviews

3.8/5

Rating in categories

3.8

Skill development

4.3

Work-life balance

3.8

Salary

3.7

Job security

4.4

Company culture

3.3

Promotions

4.0

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