NTT Data ETL Lead Interview Questions and Answers

Q1. Tell me the high level overview of dataguard installation?
Add your answer
Q2. What are your daily tasks adn what things you handel in your team?
Add your answer

Q1. Explainyour job role
Ans. 
ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.
• Designing ETL processes to extract data from multiple sources

• Transforming data to meet business requirements

• Loading data into a data warehouse or other target systems

• Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS
Answered by AI
Add your answer
Q2. Explain implementation of SCD 1 in IICS
Ans. 
SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.
• In IICS, use the Mapping Designer to create a mapping that loads data from source to target.

• Use a Lookup transformation to check if the record already exists in the target table.

• If the record exists, update the existing record with new data using an Update Strategy transformation.

• If the record does not exist, inse...read more
Answered by AI
Add your answer

Q1. Analytical functions difference
Ans. 
Analytical functions are used to perform calculations across a set of rows related to the current row.
• Analytical functions operate on a group of rows and return a single result for each row

• They can be used to calculate running totals, moving averages, rank, percentiles, etc.

• Examples include ROW_NUMBER(), RANK(), SUM() OVER(), AVG() OVER()
Answered by AI
Add your answer
Q2. Which transformation uses in scd2?
Ans. 
The Slowly Changing Dimension Type 2 (SCD2) transformation is used for handling historical data changes in a data warehouse.
• SCD2 transformation is used to track historical changes in dimension tables.

• It maintains multiple versions of a record by adding new rows with updated information and end-dating the previous record.

• Commonly used in scenarios where historical data needs to be preserved and queried.

• Example: When a c...read more
Answered by AI
Add your answer
Q3. Unix basic, how to find particular file in directory?
Add your answer
Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join?
Ans. 
To find the count of different types of joins between two tables A and B.
• Left join: Includes all records from table A and matching records from table B.

• Right join: Includes all records from table B and matching records from table A.

• Inner join: Includes only the matching records from both tables.

• Full outer join: Includes all records when there is a match in either table A or table B.
Answered by AI
Add your answer
Q5. Incremental load
Add your answer

Database Management system SQL and PlSQL

Database Base Management system SQL and PlSQL

Database Management system

Database Management system

Database Management system

Database Management system

Database Base Management system

Q1. Database Management system
Add your answer
Q2. SQL and PlSQL Mango Data And Manu Database Management system
Add your answer
Q3. C Language and C++Language and Java
Add your answer
Q4. Data Analysis and Data entry
Add your answer
Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Add your answer

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. 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