NTT Data ETL Lead Interview Questions and Answers

Q1. Dataguard architecture
Add your answer
Q2. Rman backup and restoration
Add your answer

Q1. Why you join inm
Ans. 
I joined inm because of the company's reputation for innovation and growth in the tech industry.
• Attracted to company's reputation for innovation

• Excited about opportunities for growth in tech industry

• Impressed by company culture and values
Answered by AI
Add your answer

Q1. What is the uses of filter stage
Ans. 
Filter stage is used in ETL processes to selectively pass or reject data based on specified criteria.
• Filter stage helps in removing unwanted data from the input dataset.

• It can be used to apply conditions like filtering out duplicate records, selecting specific columns, or excluding certain values.

• For example, a filter stage can be used to only pass records where the sales amount is greater than $1000.
Answered by AI
Add your answer
Q2. What is the uses of transfor stage
Ans. 
Transform stage is used in ETL process to apply business rules, clean and enrich data before loading into target database.
• Transform stage is used to apply business rules to the data.

• It is used to clean and standardize data before loading into the target database.

• Transform stage can also be used to enrich data by combining multiple sources or adding calculated fields.

• Examples include converting data types, removing dupl
Answered by AI
Add your answer
Q3. What is the uses of sort stage
Ans. 
Sort stage is used in ETL processes to sort data based on specified criteria before loading it into the target system.
• Sort stage helps in arranging data in a specific order for better analysis and reporting

• It can be used to remove duplicates from data before loading

• Sorting can be done based on multiple columns or expressions

• Example: Sorting customer data based on their purchase amount before loading into a data warehou
Answered by AI
Add your answer
Q4. How to create the prallel job
Ans. 
To create a parallel job, use parallel processing techniques to divide tasks into smaller subtasks that can be executed simultaneously.
• Identify tasks that can be executed independently and in parallel

• Use parallel processing techniques such as multi-threading or distributed computing

• Implement parallel job using ETL tools like Informatica or Talend

• Monitor and optimize parallel job performance to ensure efficient executio
Answered by AI
Add your answer
Q5. Defenation of scd
Ans. 
SCD stands for Slowly Changing Dimension, a technique used in data warehousing to track changes in dimension attributes over time.
• SCD is used to maintain historical data in a data warehouse

• There are different types of SCDs - Type 1, Type 2, and Type 3

• Type 1 SCD overwrites old data with new data

• Type 2 SCD creates a new record for each change and maintains history

• Type 3 SCD keeps a limited history by adding columns to tr
Answered by AI
Add your answer

Q1. Questions related to informatica powercenter basic to mid level
Add your answer

Q1. Self intro as usual
Add your answer
Q2. What are active and passive transformations?
Ans. 
Active transformations change the number of rows that pass through them, while passive transformations do not change the number of rows.
• Active transformations can filter, update, or modify the number of rows in a data stream (e.g. Filter, Router, Update Strategy).

• Passive transformations do not change the number of rows in a data stream, they only allow data to pass through unchanged (e.g. Expression, Lookup, Sequence G
Answered by AI
Add your answer
Q3. Some basic questions on transformations like Expression, Update, Router, filter, SQ,lookup etc
Add your answer
Q4. What are different types of lookup caches
Ans. 
Different types of lookup caches include persistent cache, dynamic cache, and shared cache.
• Persistent cache stores lookup data in a flat file or database table for reuse across sessions.

• Dynamic cache dynamically loads lookup data into memory as needed during a session.

• Shared cache allows multiple sessions to share the same cache for improved performance.
Answered by AI
Add your answer
Q5. Difference between filter and router.
Ans. 
Filter is used to pass or reject data based on conditions, while router is used to route data to different targets based on conditions.
• Filter is used to include or exclude data based on specified conditions.

• Router is used to direct data to different targets based on specified conditions.

• Filter is typically used to remove unwanted data, while router is used to split data flow.

• Example: Using filter to exclude records wit...read more
Answered by AI
Add your answer

Q1. Some basic to medium level questions on transformations
Add your answer
Q2. Some real time scenario questions
Add your answer
Q3. Direct and indirect file loading
Add your answer

Q1. Asked for Mumbai location
Add your answer
Q2. 5 days Client office
Add your answer

Q1. Informtica with date functions
Ans. 
Informatica is a popular ETL tool used for data integration and transformation. It has built-in functions to handle date operations.
• Informatica is a powerful ETL tool used for extracting, transforming, and loading data.

• It provides a variety of built-in functions for handling date operations such as date calculations, formatting, and conversions.

• Examples of date functions in Informatica include TO_DATE, TO_CHAR, ADD_TO_
Answered by AI
Add your answer

Q1. SCD-2 , Flat FIle tgt processing
Add your answer
Q2. SQL table joins
Add your answer

Q1. Tell about yourself
Ans. 
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
• 5+ years of experience as an Oracle DBA

• Proficient in database management, performance optimization, and data security

• Skilled in troubleshooting and resolving database issues

• Strong knowledge of Oracle database architecture and SQL

• Certified Oracle Database Administrator (OCA/OCP)
Answered by AI
Add your answer

Q1. Basic Question Answer
Add your answer
Q2. Basic SQL , SNWOFLAKE AND ETL Concepts
Add your answer

Q1. Some in depth questions about python and java
Add your answer

Asked some problem solving questions they will allow to choose the language it's good