HCL Group ETL Developer Interview Questions and Answers

Q1. Self introduction
Add your answer

Q1. Package discussion
Add your answer

It's an assignment for apti, verbal

Q1. It's like an what are u mentioned in resume skills.
Add your answer

Q1. Just like interaction with candidate like personal details.
Add your answer

Q1. What is loads in informatica
Ans. 
Loads in Informatica refer to the process of moving data from source to target in a data warehouse.
• Loads involve extracting data from source systems

• Transforming the data as needed

• Loading the data into the target data warehouse or database

• Loads can be full, incremental, or delta depending on the requirements

• Example: Loading customer data from a CRM system into a data warehouse for analysis
Answered by AI
Add your answer
Q2. Query to find duplicates in table
Ans. 
Use GROUP BY and HAVING clause to find duplicates in a table.
• Use GROUP BY to group rows with same values together

• Use HAVING COUNT(*) > 1 to filter out duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Performance tuning of ssis packages
Ans. 
Performance tuning of SSIS packages involves optimizing data flow, memory usage, and parallelism.
• Optimize data flow by using efficient data sources and destinations

• Minimize memory usage by using appropriate buffer sizes and reducing unnecessary data transformations

• Increase parallelism by using multiple threads and optimizing task execution order

• Use performance monitoring tools like SSIS logging and performance counters...read more
Answered by AI
Add your answer

Q1. Basics,ETL Process and performance tuning
Add your answer

Q1. Past experience
Add your answer

Q1. About the ETL Process
Add your answer

Q1. What are your salary expectations?
Add your answer

Q1. How to delete files older than 30 days?
Ans. 
Use a script to find and delete files older than 30 days.
• Use a script to identify files older than 30 days based on their creation or modification date

• Utilize a command like find or PowerShell to search for files older than 30 days

• Combine the script with a delete command to remove the identified files
Answered by AI
Add your answer