Skip to contentSkip to footer

Etl Engineer Interview Questions

Salaries
Interviews

1,581 etl engineer interview questions shared by candidates

1. What are the types of lookup cache and explain them 2. What are the types of look up? 3. When do you use connected lookup and unconnected lookup 4. List the transformations you have used 5. In your project, in which scenario you have used Java transformation (I had used for splitting a comma separated value) 6. How to convert 1 row to 3 rows 7.How to fetch distinct records using Informatica PC 8. Explain connected and unconnected stored procedure transformation in informatica 9. How to read history log files/ read log files for previously run sessions 10. Difference between router and filter 11. Scenario: I get files for each region. The regions are not known in prior. How to load data from each regional source file to a separate file i.e. one file for each region using a single mapping. (Dynamically create target file for each region) 12. Have you used Data driven property in sessions? If yes, why did you use it? 13. In how many levels sorter handles NULL values? 14. Scenario: I have a file. I want to load only 1st, 3rd, 9th and the last record into target. How do you achieve this? 15. What is the unix command to find a file in the filesystem? 16. What is the difference between '>' and '>>' in unix? 17. How to handle aggregator transformation for better performance? 18. What is the difference between bulk load and normal load? 19. Why bulk load is faster than normal load? (Bulk load will not create indexes and check for constraints. The records bypass the data base management system and get loaded). What is the prerequisite for bulk load? 20. When do we use having clause in sql queries? 21. What is the difference between where clause and having clause? 22. If a query has where clause and having clause, which clause will get executed first, where or having? 23. Merge. I do not know if it is in Informatica or UNIX 24. How to improve performance of an sql query in oracle? 25. How will you find out which job is running using unix command? How will you move a process to background? 26. Since the mode of work has become 'work from home' now, how will you manage to work to balance your work life and professional life?
avatar

ETL Developer

Interviewed at Infosys

3.6★
Sep 18, 2020

1. What are the types of lookup cache and explain them 2. What are the types of look up? 3. When do you use connected lookup and unconnected lookup 4. List the transformations you have used 5. In your project, in which scenario you have used Java transformation (I had used for splitting a comma separated value) 6. How to convert 1 row to 3 rows 7.How to fetch distinct records using Informatica PC 8. Explain connected and unconnected stored procedure transformation in informatica 9. How to read history log files/ read log files for previously run sessions 10. Difference between router and filter 11. Scenario: I get files for each region. The regions are not known in prior. How to load data from each regional source file to a separate file i.e. one file for each region using a single mapping. (Dynamically create target file for each region) 12. Have you used Data driven property in sessions? If yes, why did you use it? 13. In how many levels sorter handles NULL values? 14. Scenario: I have a file. I want to load only 1st, 3rd, 9th and the last record into target. How do you achieve this? 15. What is the unix command to find a file in the filesystem? 16. What is the difference between '>' and '>>' in unix? 17. How to handle aggregator transformation for better performance? 18. What is the difference between bulk load and normal load? 19. Why bulk load is faster than normal load? (Bulk load will not create indexes and check for constraints. The records bypass the data base management system and get loaded). What is the prerequisite for bulk load? 20. When do we use having clause in sql queries? 21. What is the difference between where clause and having clause? 22. If a query has where clause and having clause, which clause will get executed first, where or having? 23. Merge. I do not know if it is in Informatica or UNIX 24. How to improve performance of an sql query in oracle? 25. How will you find out which job is running using unix command? How will you move a process to background? 26. Since the mode of work has become 'work from home' now, how will you manage to work to balance your work life and professional life?

I found every last question they asked me on this site!! "tell me about a time..." Just be sure to use the STAR method. Tell the situation, the actions you took and remember the results! Always use examples that show your leadership! Be comfortable, and confident, sit up straight, rest your arms on the arm rest if you don't know what to do with your hands so that you appear confident. Try and lead the conversation that puts them in the position to do most of the talking and shows that you are really interested. (Ask most of the questions) OH, have good questions to ask at the end. When you see that they are elaborating on the job and what it offers and side barring that's usually a good sign. Just make the experience a good conversation. I took the assessment, always answer with strong agree strong disagree! DO NOT tell the truth (sadly) answer as if you were NED FLanders! Ex, No, I dont know thieves( saying you know someone who steals says that you hang with them and you might be one) Yes, I like big crowds! Yes, I like ppl to bother me while I'm working! etc. Stay consistent with your responses. They use a red, yellow, and green method. As long as you are in the yellow and green you're fine. I was told that salary was 49k-52 for entry level etls. I plan to negotiate ( Look up "the briefcase effect tips on negotiating) BE PREPARED! What every you don't know google it!
avatar

ETL

Interviewed at Target

3.5★
Mar 14, 2013

I found every last question they asked me on this site!! "tell me about a time..." Just be sure to use the STAR method. Tell the situation, the actions you took and remember the results! Always use examples that show your leadership! Be comfortable, and confident, sit up straight, rest your arms on the arm rest if you don't know what to do with your hands so that you appear confident. Try and lead the conversation that puts them in the position to do most of the talking and shows that you are really interested. (Ask most of the questions) OH, have good questions to ask at the end. When you see that they are elaborating on the job and what it offers and side barring that's usually a good sign. Just make the experience a good conversation. I took the assessment, always answer with strong agree strong disagree! DO NOT tell the truth (sadly) answer as if you were NED FLanders! Ex, No, I dont know thieves( saying you know someone who steals says that you hang with them and you might be one) Yes, I like big crowds! Yes, I like ppl to bother me while I'm working! etc. Stay consistent with your responses. They use a red, yellow, and green method. As long as you are in the yellow and green you're fine. I was told that salary was 49k-52 for entry level etls. I plan to negotiate ( Look up "the briefcase effect tips on negotiating) BE PREPARED! What every you don't know google it!

Viewing 1261 - 1270 interview questions

Glassdoor has 1,581 interview questions and reports from Etl engineer interviews. Prepare for your interview. Get hired. Love your job.