As a DataStage ETL developer, you can expect a minimum of 2 scenario-based questions in any DataStage interview. This is common across all organization’s interviews. The interviewer might want to assess your problem-solving skills by throwing scenario-based questions.
The interviewer might judge your 50% of technical knowledge by looking at your answers to scenario-based questions.
So if you know different ways (you might have more than one solution for the same problem) to answer that scenario problem, it would be better to explain all the ways or the best/optimized way.
Don’t try to answer in a hurry, take few minutes to design your job and explain the ETL job stage by stage or draw your ETL job design on a piece of paper.
Sometimes you might have to face complex ETL job design scenarios also.
So to help everyone out there who is going to attend the DataStage interviews, I am trying to gather all the DataStage scenario-based questions and solutions for them.
Below I have given some of the scenario-based questions and solutions for them. I will add few more scenarios in the future whenever I come across them.