Etl tester Interview Questions
155
Etl Tester interview questions shared by candidates
Interview was pretty simple,good amount of basic questions were asked in the written test.
16 Answers↳
exactly what did the mail from meenakshi says
↳
0727384596
↳
meeenakshi never mailed me ...i have pinged people who mailed me((Piuyush)) .....on my office communicator..they told me meenakshi will get back to you... Less
Sql query: There is a table, called alphabet, a column in it as alpha, there are 6 rows in that column as a,b,c,d,e,f. I want to display feabcd in output
6 Answers↳
Select alpha from( select t*,row_number() over(order by alpha desc) as r from alphabet) as t where r beteen 1 and 2 UNION ALL Select alpha from( select t*,row_number() over(order by alpha ) as r from alphabet) as t where r beteen 1 and 2 Less
↳
select alpha, case when alpha='a' then 'f' when alpha='b' then 'e' when alpha='c' then 'a' when alpha='d' then 'b' when alpha='e' then 'c' when alpha='f' then 'd' end new_seq from alphabet; Less
↳
Use analytical function
Questions were on MDM testing... Process was good
1 Answers↳
Master Data management.. Explained clearly
Basic ETL process and some sql queries
1 Answers↳
Probably the worst organisation in terms of interview process. Primarily the HR Anita Singh who forgets that a person has already been interviewed and cleared. Would you imagine i have give 4 distinct but same technical interview after the 4th interview my profile was set on hold and then I got a call again saying you have to give another technical interview and given that that interview also went well as per my answers i had reviewed i was rejected. Neither they had a good salary nor a good RMG team. Also, i could tell you these interviewers never ask a proper logical questions instead they just cram whats on google and paste it on their list. Poor experience i would recommend to not waste your time in giving interviews to such organisations. All my interviews went around 40-45 minutes such a wastage of time Less
Questions was good on SQL,Unix and DW concepts. Below are some questions : 1. Difference in DM and ODS 2. Star Schema and Snowflake schema 3.Data verification process 4.Sql Queries a. Delete Query b. Duplicate Query etc 5. Union and Union all difference with the example 6. All Joins 7. Project description 8. Analytic Functions
1 Answers↳
Questions was easy ,so have given maximum answers but I think interviewer looking for Superman :p Less
Questions were completely based on SQL and that too very restricted to Joins and some DWH concepts. No informatica, teradata, unix related questions were asked.
1 Answers↳
Qualified all round and most surprised to see the Regional VP was negotiating salary instead of HR and that too with much below minimum market standard hike. Typical Indian attitude when it comes to money. They(VP) represent themselves as a market leader to me during negotiations when they are not even in market. I will not recommended to those who are already in IT, this company is only good for Non-IT people who wants to move to IT sector. Turn down the offer straight on VP face. Less
Asked a question which was not relevant to the role.
1 Answers↳
Clearly told them its not what i was expecting since its not my domain.