Upload Button Icon Add office photos

Filter interviews by

TCS Communications Informatica Developer Interview Questions, Process, and Tips

Updated 24 Aug 2024

TCS Communications Informatica Developer Interview Experiences

1 interview found

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

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

Round 1 - Technical 

(5 Questions)

  • Q1. What is mapplet
  • Ans. 

    A mapplet is a reusable object in Informatica PowerCenter that contains a set of transformations.

    • Mapplets can be used in multiple mappings to perform the same set of transformations.

    • They can simplify mapping development by encapsulating common logic.

    • Mapplets can have input and output ports to connect with other transformations.

  • Answered by AI
  • Q2. What is hive database
  • Ans. 

    Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.

    • Hive is used for managing and querying large datasets stored in Hadoop Distributed File System (HDFS).

    • It provides a SQL-like interface called HiveQL for querying data.

    • Hive organizes data into tables, partitions, and buckets to optimize queries.

    • It supports custom MapReduce scripts for complex data process...

  • Answered by AI
  • Q3. Difference between look up and joiner
  • Ans. 

    Look up is used to retrieve data from a single source, while joiner is used to combine data from multiple sources.

    • Look up is used to search for a value in a data source and return a corresponding value from the same row.

    • Joiner is used to combine data from two or more sources based on a common key.

    • Look up is used for one-to-one mapping, while joiner is used for many-to-one or one-to-many mapping.

  • Answered by AI
  • Q4. Explain scd2 logic in informatica
  • Ans. 

    SCD2 logic in Informatica is used to track historical changes in data by creating new records for each change.

    • SCD2 stands for Slowly Changing Dimension Type 2

    • It involves creating new records for each change in data, while maintaining a link to the previous record

    • It typically includes effective start and end dates to track the validity of each record

    • SCD2 logic is commonly used in data warehousing to maintain historical

  • Answered by AI
  • Q5. Difference between router and filter transformation
  • Ans. 

    Router transformation sends data to multiple targets based on conditions, while filter transformation filters rows based on conditions.

    • Router transformation can send data to multiple targets based on conditions

    • Filter transformation filters rows based on conditions

    • Router transformation can be used to route data to different tables based on certain criteria

    • Filter transformation can be used to remove unwanted rows from th

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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

Interview Questionnaire 

1 Question

  • Q1. Everything in your resume questions from your domain and 1 quizzes

Interview Preparation Tips

Interview preparation tips for other job seekers - Completely prepare your resume

I applied via Recruitment Consultant and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Java questions
  • Q2. Stream questions
  • Q3. Collections sorting

Interview Preparation Tips

Interview preparation tips for other job seekers - Core java, spring, spring boot microservices

Interview Questionnaire 

1 Question

  • Q1. Introduce yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't learn anything byheart before attending an interview
Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. About yourself,project,and basic java concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Just know all the skills u mentioned in resume
Round 1 - Technical 

(2 Questions)

  • Q1. Explain bean life cycle
  • Ans. 

    Bean life cycle refers to the stages a Java bean goes through from creation to destruction.

    • Bean is instantiated using a constructor or a factory method

    • Bean properties are set using setters or dependency injection

    • Bean is initialized using the init method

    • Bean can be used for its intended purpose

    • Bean is destroyed using the destroy method

  • Answered by AI
  • Q2. Container created ,bean instantiated dependency injection ,custom init() method,custom utility methods and destroy

Interview Preparation Tips

Interview preparation tips for other job seekers - Just focus on technical skills for experience

Skills evaluated in this interview

Interview Questionnaire 

4 Questions

  • Q1. About your self
  • Q2. About java
  • Q3. Phython
  • Q4. Project details

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong ont losse ur hope
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

IT WAS BASIC AND EASY TO SOLVE

Round 2 - Technical 

(2 Questions)

  • Q1. OOPS CONCEPT OF JAVA
  • Ans. 

    OOPS concepts in Java refer to the principles of Object-Oriented Programming such as inheritance, encapsulation, polymorphism, and abstraction.

    • Inheritance: Allows a class to inherit properties and behavior from another class. Example: class B extends class A.

    • Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.

    • Polymorphism...

  • Answered by AI
  • Q2. JAVA SPRING BOOT

Interview Preparation Tips

Interview preparation tips for other job seekers - COVER YOUR BASIC PROPERLY

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Data types in SQL. Write prime number logical code in SQL
  • Ans. 

    SQL data types and prime number logic code

    • SQL data types include integer, float, varchar, etc.

    • To write prime number logic in SQL, use a loop to check if a number is divisible by any number less than itself

    • Example: DECLARE @num INT = 7; SELECT CASE WHEN COUNT(*) = 2 THEN 'Prime' ELSE 'Not Prime' END FROM (SELECT 1 AS num UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6) AS n

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Why do you want to join us?

Skills evaluated in this interview

I applied via Job Portal

Round 1 - Technical 

(1 Question)

  • Q1. How can we break singleton pattern in java?
  • Ans. 

    Singleton pattern can be broken using reflection, serialization, and cloning.

    • Reflection can be used to access the private constructor and create multiple instances.

    • Serialization can create multiple instances when the object is deserialized.

    • Cloning can create a new instance of the singleton object.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please update the resume frequently and try to learn and make note of all the questions asked in interview.

Skills evaluated in this interview

TCS Communications Interview FAQs

How many rounds are there in TCS Communications Informatica Developer interview?
TCS Communications interview process usually has 1 rounds. The most common rounds in the TCS Communications interview process are Technical.
What are the top questions asked in TCS Communications Informatica Developer interview?

Some of the top questions asked at the TCS Communications Informatica Developer interview -

  1. Difference between router and filter transformat...read more
  2. Difference between look up and joi...read more
  3. What is hive datab...read more

Tell us how to improve this page.

TCS Communications Informatica Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Tata Technologies Interview Questions
3.6
 • 260 Interviews
TCE Interview Questions
3.8
 • 248 Interviews
Saint-Gobain Interview Questions
4.0
 • 173 Interviews
AECOM Interview Questions
4.2
 • 116 Interviews
Apco Infratech Interview Questions
3.7
 • 114 Interviews
Worley Interview Questions
4.1
 • 112 Interviews
View all
Software Engineer
9 salaries
unlock blur

₹2.5 L/yr - ₹9 L/yr

Software Developer
9 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

System Engineer
9 salaries
unlock blur

₹4 L/yr - ₹8.5 L/yr

Software Development Engineer
8 salaries
unlock blur

₹11 L/yr - ₹30 L/yr

Senior Software Engineer
7 salaries
unlock blur

₹4.8 L/yr - ₹12.3 L/yr

Explore more salaries
Compare TCS Communications with

Megha Engineering & Infrastructures

3.9
Compare

Shapoorji Pallonji Group

4.1
Compare

Alstom Transportation

3.7
Compare

Tata Technologies

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