Etl Developer Interview Questions


Etl Developer interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
ETL Solutions Developer was asked...May 29, 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


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


Inbox Business Technologies

About database and sql

1 Answers

I give him answer relevant to topic


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 Answers

All the questions were scenario based.. and good use of common sense is required. Less

HTC Global Services

Overall experience and previous project details

1 Answers

Explained my project details that worked on


How to implement scd2 using informatica tool?

1 Answers

Create the source and dimension tables in the database. Open the mapping designer tool, source analyzer and either create or import the source definition. Go to the Warehouse designer or Target designer and import the target definition. Go to the mapping designer tab and create new mapping. Less

Viewing 1 - 10 of 596 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 596 interview questions and reports from Etl developer interviews. Prepare for your interview. Get hired. Love your job.