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

Updated 5 Sep 2024

LTIMindtree Informatica Developer Interview Experiences for Experienced

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. What are cubes and OLAP cubes
  • Ans. 

    Cubes are multidimensional structures used in OLAP (Online Analytical Processing) to analyze data from multiple perspectives.

    • Cubes store aggregated data for faster analysis

    • They allow users to drill down into data to analyze at different levels of granularity

    • OLAP cubes are used in business intelligence for complex data analysis

    • Examples include sales cubes, finance cubes, and customer analysis cubes

  • Answered by AI
  • Q2. What is ETL pipeline?
  • Ans. 

    ETL pipeline stands for Extract, Transform, Load pipeline used to extract data from various sources, transform it, and load it into a data warehouse.

    • ETL pipeline involves extracting data from multiple sources such as databases, files, APIs, etc.

    • The extracted data is then transformed by applying various operations like cleaning, filtering, aggregating, etc.

    • Finally, the transformed data is loaded into a data warehouse or...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Company Website and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is my longterm and short-term goals.
  • Ans. My short-term is to become an expert in solving queries And long term is to become valuable employee in an organisation and managing a team, also helping new recruits to learn the work.
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Excellent and friendly-nature interview

I applied via Recruitment Consulltant and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Where do we use BigInteger in java ?
  • Ans. 

    BigInteger is used for mathematical operations involving very large integers in Java.

    • BigInteger is used when the range of values supported by primitive data types like int and long is not sufficient.

    • It is commonly used in cryptography and security applications.

    • It provides methods for arithmetic, bitwise, and logical operations on large integers.

    • Example: calculating factorial of a large number, generating large prime nu

  • Answered by AI
  • Q2. Merge Sort Algo code in java
  • Ans. 

    Merge Sort Algo code in java

    • Divide the array into two halves

    • Recursively sort the two halves

    • Merge the sorted halves

    • Time complexity: O(n log n)

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Genpact Software Engineer interview:
  • Core Java
  • DSA
Interview preparation tips for other job seekers - Not a very good interview experience. I was asked 2-3 questions only. Not satisfied with interview process.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Aug 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Interfaces
  • Q2. Oop concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - I interviewed for software engineer profile. Interview process were easy 1st apti round 2nd pseudo code round 3rd technical and HR. It was quite easy.

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

Interview Questionnaire 

1 Question

  • Q1. They ask only basics of programming languages which are mentioned in resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good in communication skills and be aware of general questions.

Interview Questionnaire 

1 Question

  • Q1. In C# --> Abstraction, Interface , Abstract Method, Abstract Class, Polymorphisms, Encapsulation ,Inheritance, Serialization,
  • Ans. 

    C# concepts including abstraction, interface, abstract method, abstract class, polymorphism, encapsulation, inheritance, and serialization.

    • Abstraction: hiding implementation details

    • Interface: defining a contract for behavior

    • Abstract method: method without implementation

    • Abstract class: class with one or more abstract methods

    • Polymorphism: ability of objects to take on multiple forms

    • Encapsulation: bundling data and behavi...

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Java Basic questions and Git

Interview Preparation Tips

Interview preparation tips for other job seekers - After selection they haven't rolled the offer and put the profile on hold and then doesn't pick calls.

I applied via Recruitment Consulltant and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

1.It covers all aptitude topics, and English sentences
2.Essay writing
3.Coding

Round 2 - Technical 

(2 Questions)

  • Q1. In TR , languages which u mentioned in resume they will ask Basic programing Questions on Btech project They will say one idea , we need to tell the logic how can we develop (it may varies)
  • Q2. Testing questions Polymorphism, abstraction,constructors, SQL basics
Round 3 - HR 

(5 Questions)

  • Q1. What is your family background?
  • Q2. Why should we hire you?
  • Q3. Tell me about yourself.
  • Q4. What are your strengths and weaknesses?
  • Q5. Knowledge about updated technologies

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume is important for your TR. Mention only languages u know well.

Interview Questionnaire 

1 Question

  • Q1. All basic questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be good in basics

Interview Questionnaire 

1 Question

  • Q1. In 5 programs without effecting one by one how can you debug a particular program and how can you know tha program is calling in debug
  • Ans. 

    To debug a particular program without affecting others, use breakpoints and step through the code.

    • Set a breakpoint in the program you want to debug

    • Step through the code using a debugger to identify the issue

    • Use logging statements to track the flow of the program

    • Check the call stack to see which functions are being called

    • Use conditional breakpoints to stop the program at specific points

  • Answered by AI

Skills evaluated in this interview

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree Informatica Developer interview for experienced candidates?
LTIMindtree interview process for experienced candidates usually has 1 rounds. The most common rounds in the LTIMindtree interview process for experienced candidates are Technical.
How to prepare for LTIMindtree Informatica Developer interview for experienced candidates?
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 Cloud, DW, Data Modeling, ERwin and ETL.
What are the top questions asked in LTIMindtree Informatica Developer interview for experienced candidates?

Some of the top questions asked at the LTIMindtree Informatica Developer interview for experienced candidates -

  1. What are cubes and OLAP cu...read more
  2. What is ETL pipeli...read more

Tell us how to improve this page.

LTIMindtree Informatica Developer Interview Process for Experienced

based on 1 interview

Interview experience

5
  
Excellent
View more
LTIMindtree Informatica Developer Salary
based on 113 salaries
₹4 L/yr - ₹11 L/yr
At par with the average Informatica Developer Salary in India
View more details

LTIMindtree Informatica Developer Reviews and Ratings

based on 4 reviews

4.1/5

Rating in categories

3.3

Skill development

3.3

Work-life balance

3.3

Salary

3.9

Job security

5.0

Company culture

2.4

Promotions

4.1

Work satisfaction

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

₹5 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 - ₹36 L/yr

Module Lead
5.9k salaries
unlock blur

₹7 L/yr - ₹25.5 L/yr

Senior Engineer
4.4k salaries
unlock blur

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