Preguntas de entrevista de Etl tester

152

Preguntas de entrevista para Etl Tester compartidas por los candidatos

Principales preguntas de entrevista

Ordenar: Relevancia|Popular|Fecha
Capgemini
A un ETL Tester le preguntaron...16 de septiembre de 2012

Interview was pretty simple,good amount of basic questions were asked in the written test.

16 respuestas

exactly what did the mail from meenakshi says

0727384596

meeenakshi never mailed me ...i have pinged people who mailed me((Piuyush)) .....on my office communicator..they told me meenakshi will get back to you... Menos

Mostrar más respuestas
Capgemini

Sql query: There is a table, called alphabet, a column in it as alpha, there are 6 rows in that column as a,b,c,d,e,f. I want to display feabcd in output

6 respuestas

I tried using order by and row_number function.

Select alpha from( select t*,row_number() over(order by alpha desc) as r from alphabet) as t where r beteen 1 and 2 UNION ALL Select alpha from( select t*,row_number() over(order by alpha ) as r from alphabet) as t where r beteen 1 and 2 Menos

select alpha, case when alpha='a' then 'f' when alpha='b' then 'e' when alpha='c' then 'a' when alpha='d' then 'b' when alpha='e' then 'c' when alpha='f' then 'd' end new_seq from alphabet; Menos

Mostrar más respuestas
IDC Technologies
A un ETL Tester le preguntaron...4 de noviembre de 2019

Questions were on MDM testing... Process was good

1 respuestas

Master Data management.. Explained clearly

Hexaware Technologies

1. Describe your experience as an ETL tester

1 respuestas

Mostly I answered based on my resume

Synechron

Mainly on SQL

1 respuestas

to be frank, i didn't perform that well

Bank of America

Basic ETL process and some sql queries

1 respuestas

Probably the worst organisation in terms of interview process. Primarily the HR Anita Singh who forgets that a person has already been interviewed and cleared. Would you imagine i have give 4 distinct but same technical interview after the 4th interview my profile was set on hold and then I got a call again saying you have to give another technical interview and given that that interview also went well as per my answers i had reviewed i was rejected. Neither they had a good salary nor a good RMG team. Also, i could tell you these interviewers never ask a proper logical questions instead they just cram whats on google and paste it on their list. Poor experience i would recommend to not waste your time in giving interviews to such organisations. All my interviews went around 40-45 minutes such a wastage of time Menos

Wipro

Questions was good on SQL,Unix and DW concepts. Below are some questions : 1. Difference in DM and ODS 2. Star Schema and Snowflake schema 3.Data verification process 4.Sql Queries a. Delete Query b. Duplicate Query etc 5. Union and Union all difference with the example 6. All Joins 7. Project description 8. Analytic Functions

1 respuestas

Questions was easy ,so have given maximum answers but I think interviewer looking for Superman :p Menos

Medsource Ozone Biomedicals

How to conduct various testing methods for ETL data transformation ?

1 respuestas

How to prepare various test scenarios so as to make sure complete ranges of user ETL requirements? Menos

Rolta

Questions were completely based on SQL and that too very restricted to Joins and some DWH concepts. No informatica, teradata, unix related questions were asked.

1 respuestas

Qualified all round and most surprised to see the Regional VP was negotiating salary instead of HR and that too with much below minimum market standard hike. Typical Indian attitude when it comes to money. They(VP) represent themselves as a market leader to me during negotiations when they are not even in market. I will not recommended to those who are already in IT, this company is only good for Non-IT people who wants to move to IT sector. Turn down the offer straight on VP face. Menos

Tech Mahindra

Asked a question which was not relevant to the role.

1 respuestas

Clearly told them its not what i was expecting since its not my domain.

Viendo 1-10 de 152 preguntas de entrevista

Consultar preguntas de entrevista para empleos similares

etl developerdata warehouse qa analystqa testermanual testerdata warehouse analystab initio developermanual test engineer