Desenvolvedor De Etl Interview Questions

1,581 desenvolvedor de etl interview questions shared by candidates

L1 technical round - basic sql , whole project concept and working. ( 30 mins ) L2 technical round - Thorough technical discussion, very less questions from informatica , more from dwh and sql. (30-45 mins) Mangerial Round - The interviewer asked a hell lot of questions and explained well about the role and firm. This is where you come to know that they will take you ( an experienced professional with more than 3 years of experience) and train as a fresher on different technologies and deploy you as shadow in project . In case if you agree and even if the whole process appears to have gone well, the contact person calls you and tells you that they want to conduct another managerial round as they think your skillset is different . I don't understand the concept of one more managerial round for skill assessment.
avatar

ETL Developer

Interviewed at Tredence

3.9
Oct 11, 2021

L1 technical round - basic sql , whole project concept and working. ( 30 mins ) L2 technical round - Thorough technical discussion, very less questions from informatica , more from dwh and sql. (30-45 mins) Mangerial Round - The interviewer asked a hell lot of questions and explained well about the role and firm. This is where you come to know that they will take you ( an experienced professional with more than 3 years of experience) and train as a fresher on different technologies and deploy you as shadow in project . In case if you agree and even if the whole process appears to have gone well, the contact person calls you and tells you that they want to conduct another managerial round as they think your skillset is different . I don't understand the concept of one more managerial round for skill assessment.

Tell me about a time when you had to coach someone for something. Name a time when you acted without thinking about the consequences. Tell me about a time when you had to make a tough decision based on a lot of data. Describe a time when you knew your boss was wrong about something, what did you do? Tell me about a time that you came across an unforseen problem. What did you do, and how did you handle it?
avatar

ETL

Interviewed at Target

3.5
Dec 3, 2018

Tell me about a time when you had to coach someone for something. Name a time when you acted without thinking about the consequences. Tell me about a time when you had to make a tough decision based on a lot of data. Describe a time when you knew your boss was wrong about something, what did you do? Tell me about a time that you came across an unforseen problem. What did you do, and how did you handle it?

Discussion started with ETL flow to SQL Queries. Testing questions were : difference between star and snowflax, ETL flow in current project. SQL questions were : Set operators, Difference between union and union all, Delete,drop and truncate. Asked to write queries on given scenarios. scenarios were based on Sub string, In string, Replace, Translate, Minus. Gave 3 select statements and asked how it works. group by and having function flow
avatar

ETL Tester

Interviewed at Synechron

4.1
Mar 1, 2020

Discussion started with ETL flow to SQL Queries. Testing questions were : difference between star and snowflax, ETL flow in current project. SQL questions were : Set operators, Difference between union and union all, Delete,drop and truncate. Asked to write queries on given scenarios. scenarios were based on Sub string, In string, Replace, Translate, Minus. Gave 3 select statements and asked how it works. group by and having function flow

Viewing 241 - 250 interview questions

Glassdoor has 1,581 interview questions and reports from Desenvolvedor de etl interviews. Prepare for your interview. Get hired. Love your job.