Etl developer Interview Questions

540

Etl Developer interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Numerify
ETL Solutions Developer was asked...29 May 2015

Writing a query to find the average and the first three ranks only should come In the output

3 Answers

select avg(salary) from (select name, salary,rank() over(order by salary desc) as rank from emp_tbl) where rank <= 3; Less

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; Less

Philips

How have you worked with Delta processing?

2 Answers

Hash Keys... etc

I think it's mostly related to Dimension table processing. SCD type 1,2. Similar to CHANGE DATA CAPTURE (CDC) Less

Why should i hire you?

2 Answers

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. Less

fu$k off

Habitat for Humanity

What makes a good ETL design?

1 Answers

Good reject processing and logging; easy to maintain.

Gunther Douglas

Describe my experience with ETL and Accounting Procedures.

1 Answers

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. Less

Legends Incorporated

About yourself your dreams and goals.

1 Answers

Directly

Inbox Business Technologies

About database and sql

1 Answers

I give him answer relevant to topic

Frost-Arnett

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 Answers

Multiply the values by negative one.

UDig

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 Answers

I answered the technical questions correctly (they were easy!), and I hope, with clarity. Less

Longos

What is your overall experience like?

1 Answers

While answering this question , I stressed on my experience which was very relevant to the job and also about the overall experience that I had. Less

Viewing 1 - 10 of 540 interview questions