Preguntas de entrevista de Etl developer
534
Preguntas de entrevista para Etl Developer compartidas por los candidatosPrincipales preguntas de entrevista
Writing a query to find the average and the first three ranks only should come In the output
3 respuestas↳
select avg(salary) from (select name, salary,rank() over(order by salary desc) as rank from emp_tbl) where rank <= 3; Menos
↳
Could you please provide some more questions from your interview?
↳
Select empid,avg(salary) from (sel empid, salary, row-number() over(order by salary desc) as rank from emp) A Where A. Rank <=3 Group by empid; Menos
How have you worked with Delta processing?
2 respuestas↳
Hash Keys... etc
↳
I think it's mostly related to Dimension table processing. SCD type 1,2. Similar to CHANGE DATA CAPTURE (CDC) Menos
Why should i hire you?
2 respuestas↳
I am looking for a good platform to improve my technical, intellectual and leadership skills where your organization is well known for it. If given an opportunity, I will work sincerely and will put all my efforts for the growth of the company. Menos
↳
fu$k off
It tool almost one week to complete the interview process and it was good experience. The salary negotiation was excellent. They give deserving salary to fresher.
1 respuestas↳
All the questions were scenario based.. and good use of common sense is required. Menos
Describe my experience with ETL and Accounting Procedures.
1 respuestas↳
I mentioned some accounting systems that I designed, coded and implemented. Also I spoke at length about a project where I wrote and administered a large ETL project that I headed. We added clients and modified our process to accommodate client and supplier requirements. And we moved a lot of data each night. Menos
If you have a list of data that includes negative and positive values (I.E. -10, -1, 10, -20, 20), how do I switch the signs of the those values?
1 respuestas↳
Multiply the values by negative one.
This was over two years ago, so it's hard to remember a lot of details beyond my impression above (see "Describe the Interview Process") that they were not screening adequately, or at the very least, giving me softball questions.
1 respuestas↳
I answered the technical questions correctly (they were easy!), and I hope, with clarity. Menos