AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
TCS
Compare
Filter interviews by
TCS Informatica ETL Developer Interview Questions, Process, and Tips
TCS Informatica ETL Developer Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. What is the difference between delete , truncate and drop?
- Ans.
Delete removes specific rows from a table, truncate removes all rows, and drop removes the entire table.
Delete is a DML operation, while truncate and drop are DDL operations.
Delete is slower as it logs individual row deletions, while truncate and drop are faster.
Delete can be rolled back, while truncate and drop cannot be rolled back.
Delete can have conditions to specify which rows to delete, while truncate and drop af...
- Q2. Write a SQL query to find the duplicates?
- Ans.
A SQL query to find duplicates in a table.
Use the GROUP BY clause to group the records by the columns that may have duplicates.
Use the HAVING clause to filter the groups that have more than one record.
Select the columns that you want to display in the result.
Order the result if necessary.
- Q3. Difference between union and union all
- Ans.
Union combines the result sets of two or more SELECT statements, while Union All combines all rows from two or more SELECT statements.
Union removes duplicate rows from the result set, while Union All does not.
Union requires the number and order of columns in all SELECT statements to be the same, while Union All does not have this requirement.
Union is slower than Union All because it performs a distinct operation, while...
- Q4. Write any analytical syntax.
- Ans.
An analytical syntax example is SELECT COUNT(*) FROM table_name;
Analytical syntax is used to retrieve and analyze data from databases
Commonly used in business intelligence and data warehousing
Other examples include GROUP BY, ORDER BY, and JOIN statements
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I appeared for an interview in Apr 2021.
Interview Questionnaire
1 Question
- Q1. Questions were basic and advanced level of questions.basically you will have two set of rounds technical and managerial round.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2022. There were 3 interview rounds.
(6 Questions)
- Q1. What is filter transformation
- Ans.
Filter transformation is used to filter rows from a data source based on specified conditions.
Filter transformation is an active transformation in Informatica PowerCenter.
It allows you to define conditions to filter rows from the source data.
Rows that meet the filter conditions are passed to the next transformation, while others are dropped.
Filter transformation can be used to eliminate unwanted data or select specific...
- Q2. Difference between connected and unconnected lookup
- Ans.
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup receives input values directly from the pipeline, while unconnected lookup receives input values from the calling transformation.
Connected lookup returns a value to the pipeline, while unconnected ...
- Q3. Diff between active and passive transformation
- Ans.
Active transformations change the number of rows that pass through it, while passive transformations do not.
Active transformations change the data stream by adding, deleting, or modifying rows
Passive transformations do not change the data stream, but may change the data within the stream
Active transformations include Filter, Router, Update Strategy, and Expression
Passive transformations include Aggregator, Joiner, Look
- Q4. How to improve performance
- Q5. What is pushdown automata
- Ans.
Pushdown automata is a type of automata that can recognize context-free languages.
Pushdown automata is a theoretical model of computation.
It has a stack that can be used to store and retrieve information.
It is used to recognize context-free languages.
It is more powerful than finite automata but less powerful than Turing machines.
Examples of context-free languages include arithmetic expressions and programming languages
- Q6. How to update table without using update startegy
- Ans.
Use SQL merge statement to update table without update strategy
Use SQL merge statement to update table
Specify the source and target tables
Define the join condition
Specify the columns to update
Use WHEN MATCHED THEN UPDATE statement
Use WHEN NOT MATCHED THEN INSERT statement
More on informatica and SQL code
(1 Question)
- Q1. Nothing difficult just discuss about pay scale
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. About informatica,SQL,dwa
Interview Preparation Tips
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Numerical ability and logical reasoning followed by some coding mcqs
(1 Question)
- Q1. Print 1 to 100 without for loop
- Ans.
Printing 1 to 100 without for loop
Use recursion to print numbers from 1 to 99
Print 100 outside the recursion
Use a base case to stop recursion at 100
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Simple aptitude test
(1 Question)
- Q1. General questions as per your cv
Interview Preparation Tips
- Aptitude
I applied via Company Website and was interviewed before Apr 2021. There were 3 interview rounds.
(1 Question)
- Q1. Oops About c++ Dbms Data structures
Interview Preparation Tips
Interview Preparation Tips
Experience: I had sent my resume to the hiring group, Selection through telephonic interviews. I was interviewed by three different research groups (once by each).
Tips: Factors in decreasing order of importance: CGPA each stage. Ability to explain your projects precisely. Ability to solve ''standard" logarithmic problems. The way you think and put down your Answer is the most important. The final answer .s not so I important, and they prod you when you think out aloud anyway.
Round: Technical Interview
Experience: Almost- by default they ask about your previous projects/internships if they are relevant to the group. Ofher questions depend on the group you are interviewed by and your own profile, In my case it was machine learning, text mining etc. I was told about the research problem they were dealing with then and asked f or comments/suggestions/.inputs and a discussion followed.
Tips: Basically these are specialized Interviews so it's good to have sound knowledge of your domain (analytical and application skills are very much required).
Skill Tips: CGPA>9.0, 1f not (like me) relevant work done in the domain and in past internship.A recommendation from the professor is also a good add on.
College Name: IIT Madras
Interview Preparation Tips
Experience: There was an apititude test basically in line with CAT pattern. It was conducted online for about 45 min duration. The questions were rather simple but each question was time bound (around 45 sec or so).
Tips: As such I did not have any structured study plan. I did refresh some of my basics in mechanics and analysis. I was more inclined to get a job in aerospace division. Read as per your interest.
Duration: 45 minutes
Round: Group Discussion
Experience: Initially, we are seated randomly in a circular manner and each one was given two minutes to describe the topic. It was followed by an tense debate where participants converged and diverged on different sets of issue. They were particularly looking for interpersonal skills and out of the box thinking.
Round: Interview
Experience: The interview was purely management type.More questions were thrown at team building, bio-data, why this company? , project, what you Can contribute for the firm?, where you see yourself in next 5 -10 years, ambitions, some amount of optimization tools and techniques, concluding remarks....Interpersonal skills and clarity in answering where mainly
IBM was a more relaxed interview, which basically dealt with management and interpersonal skills. Questions like “if one of our team mate is very stubborn, lazy, adamant, how will you tackle the situation” were asked.
Tips: College (B Tech) curricular activities, NTSC certificate, Math Olympiad certificate, all India quiz competition awards were noted and appreciated. That really was a booster. That helps in implanting an idea that you are not just blah blah blah.
Skill Tips: Be very sure about your mechanics, analysis and design. These three are the fundamentals.
I haven prepared for placements exclusively. Here were combined discussions. However, it really helps if you can revise and make your fundamentals were clear. The basic understanding should be there. An hour every day for two months will do the trick.
Be really choosy of the company you want to be in. Learn a lot more of the company and get an idea of what they are actually looking for. But still don’t freeze your mind to those realms alone.. Be open minded and cheerful. The first few questions will set the mood of the interview. If you are bale to crack that, then things will be really smooth. Really concentrate on your fundamentals, especially analysis and design.
Skills: Mechanics, Analysis , Design
College Name: IIT-Madras
Interview Preparation Tips
Experience: CGPA > 8 is necessary
Round: Test
Experience: Online Test + Written Test
Online Test - Duration 90 minutes + Written Test 30 minutes for Hardware profile
Online Test -Quants, Number Series ; Calculators were not allowed
Written Test - Semiconductor Basics
Round: Interview
Experience: Interview is held in either 1 round for non-core profile or several rounds of technical interviews for Hardware.
Technical round consisted of questions form topics like VLSI, Semiconductors (BJT, MOS), ASIC Design Flow, CMOS Process Flow.
Round: Group Discussion
Experience: Group Discussion is held for non-core profilesDuration varies from 20-30 minutes with 11 members.
General Tips: Never ever mention GRE or MS or any higher studies, for that matter, in any placement interview if you want to get placed in that company
Practicing quant, puzzle solving and GD from early in the semester would definitely help
Core placement: be thorough with the core fundaes
Practice general quant questions without a calculator
Skills: Quants, Puzzle Solving
College Name: IIT MADRAS
TCS Interview FAQs
Tell us how to improve this page.
TCS Interviews By Designations
- TCS System Engineer Interview Questions
- TCS Software Developer Interview Questions
- TCS Software Engineer Interview Questions
- TCS Assistant System Engineer Interview Questions
- TCS Assistant System Engineer Trainee Interview Questions
- TCS IT Analyst Interview Questions
- TCS Ninja Interview Questions
- TCS Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Informatica Developer Interview Questions
- ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- ETL Lead Interview Questions
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
TCS Informatica ETL Developer Reviews and Ratings
based on 16 reviews
Rating in categories
|
System Engineer
1.1L
salaries
|  ₹1 L/yr - ₹9 L/yr |
|
IT Analyst
66.1k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
|
AST Consultant
51.8k
salaries
| ₹8 L/yr - ₹25.1 L/yr |
|
Associate Consultant
30.1k
salaries
| ₹9 L/yr - ₹32 L/yr |
|
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.8 L/yr |
Amazon
Wipro
Infosys
Accenture
- Home >
- Interviews >
- TCS Interview Questions >
- TCS Informatica ETL Developer Interview Questions
