Etl Developer Interview Questions
596
Etl Developer interview questions shared by candidates
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
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
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