Skip to contentSkip to footer

Etl Engineer Interview Questions

Salaries
Interviews

1,581 etl engineer interview questions shared by candidates

Questions asked in F2F. 1) Tell about yourself on professional experience, tools used and current project working on. 2) Explain about the Type 2 SCD model 3) we have 10 mapping in different folder, all these 10 mapping has same target table (lets say employee table). Using Sequence Generator transformation we need to generate the (employee id) surrogate key. Now the scenario is, when First mapping executed 10 records passed to TGT table. When second mapping executed another 5 records passed to TGT table. In this scenario how the surrogate key is handled. 4) Question on flat file as below SOURCE (FLAT FILE) EMP_NO DEPT_NO SALARY 10 101 1000 20 102 2000 30 103 3000 40 102 4000 50 101 5000 60 104 6000 TARGET(FLAT FILE) EMP_NO DEPT_NO SALARY 10 101 1000 50 101 5000 6000 20 102 2000 40 102 4000 6000 30 103 3000 3000 60 104 6000 6000 so in the target salary column, we need to sum up the salary based upon the dept_no. 5)SOURCE (FLAT FILE) ID VALUE 1 A 2 B 3 C 4 D 5 E TARGET(FLAT FILE) ID VALUE PRE_VALUE 1 A B 2 B C 3 C D 4 D E 5 E NULL How we can achieve this using Informatica? 6) SQL Scenario Question COL_A COL_B 10 A 20 B 30 C 40 D When we select 10 from COL_A using WHERE clause filter, the output should display A from COL_B. When we select 30 from COL_A using WHERE clause filter, the output should display C from COL_B. Similarly when we select 50(which is not available in COL_A) then it should display "Invalid Number". How to achieve this using Sql.
avatar

Informatica ETL Developer

Interviewed at BNP Paribas

3.8★
Jan 21, 2018

Questions asked in F2F. 1) Tell about yourself on professional experience, tools used and current project working on. 2) Explain about the Type 2 SCD model 3) we have 10 mapping in different folder, all these 10 mapping has same target table (lets say employee table). Using Sequence Generator transformation we need to generate the (employee id) surrogate key. Now the scenario is, when First mapping executed 10 records passed to TGT table. When second mapping executed another 5 records passed to TGT table. In this scenario how the surrogate key is handled. 4) Question on flat file as below SOURCE (FLAT FILE) EMP_NO DEPT_NO SALARY 10 101 1000 20 102 2000 30 103 3000 40 102 4000 50 101 5000 60 104 6000 TARGET(FLAT FILE) EMP_NO DEPT_NO SALARY 10 101 1000 50 101 5000 6000 20 102 2000 40 102 4000 6000 30 103 3000 3000 60 104 6000 6000 so in the target salary column, we need to sum up the salary based upon the dept_no. 5)SOURCE (FLAT FILE) ID VALUE 1 A 2 B 3 C 4 D 5 E TARGET(FLAT FILE) ID VALUE PRE_VALUE 1 A B 2 B C 3 C D 4 D E 5 E NULL How we can achieve this using Informatica? 6) SQL Scenario Question COL_A COL_B 10 A 20 B 30 C 40 D When we select 10 from COL_A using WHERE clause filter, the output should display A from COL_B. When we select 30 from COL_A using WHERE clause filter, the output should display C from COL_B. Similarly when we select 50(which is not available in COL_A) then it should display "Invalid Number". How to achieve this using Sql.

Viewing 751 - 760 interview questions

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