HCLTech Datastage Developer Interview Questions and Answers

Q1. Senario based question
Add your answer

Q1. Basic questions about datastage Like difference between lookup,merge,join Questions with dataset and sequential stage. Then few questions asked on transformer stage.
Add your answer
Q2. Remove duplicate using datastage
Ans. 
Use Datastage to remove duplicates from a dataset
• Use a Remove Duplicates stage in Datastage to eliminate duplicate records

• Configure the Remove Duplicates stage to identify and remove duplicates based on specific key columns

• Ensure that the dataset is sorted properly before applying the Remove Duplicates stage
Answered by AI
Add your answer

Q1. In second round most they focused on scenario based questions in both datastage and SQL.
Add your answer

Q1. Salary and location discussion
Add your answer

Q1. Explain transformer stage
Ans. 
Transformer stage is a Datastage stage used for data transformation and manipulation.
• Transformer stage is used to perform complex data transformations and manipulations.

• It allows users to define custom logic using graphical mapping.

• It supports various functions and operators for data manipulation.

• Transformer stage can be used to filter, aggregate, join, and sort data.

• It can also be used to perform calculations, convers...read more
Answered by AI
Add your answer

Q1. Discuss 4 case study related to supply chain management.
Add your answer

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

Q1. 
Sum of Two Numbers Represented as Arrays
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...read more
Ans. 
Given two numbers represented as arrays, calculate their sum and return the result as an array.
• Iterate through the arrays from right to left, adding digits and carrying over if necessary

• Handle cases where one array is longer than the other by considering the remaining digits

• Ensure the final sum array does not have any leading zeros
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.