Etl Developer sollicitatievragen
592
Sollicitatievragen voor Etl Developer gedeeld door sollicitantenMeest gestelde sollicitatievragen
Writing a query to find the average and the first three ranks only should come In the output
3 antwoorden↳
select avg(salary) from (select name, salary,rank() over(order by salary desc) as rank from emp_tbl) where rank <= 3; Minder
↳
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; Minder
How have you worked with Delta processing?
2 antwoorden↳
Hash Keys... etc
↳
I think it's mostly related to Dimension table processing. SCD type 1,2. Similar to CHANGE DATA CAPTURE (CDC) Minder
Why should i hire you?
2 antwoorden↳
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. Minder
↳
fu$k off
Describe my experience with ETL and Accounting Procedures.
1 antwoorden↳
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. Minder
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 antwoorden↳
All the questions were scenario based.. and good use of common sense is required. Minder
Overall experience and previous project details
1 antwoorden↳
Explained my project details that worked on
How to implement scd2 using informatica tool?
1 antwoorden↳
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. Minder