Add office photos
Filter interviews by
Data Unveil ETL Tester Interview Questions and Answers
Updated
4 Jan 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Bad
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via LinkedIn and was interviewed in Dec 2023.
1 Interview Round
1
One-on-one Round (3 Questions)
- Q1. 1. Fetch last record of the column.
2. Dense rank vs rank
3. Fetch end of 5 character from the string of the column View Answers (1)
- Q2. What type of data validation you performed. View Answers (1)
- Q3. What customer do with data. View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Interviewer (CTO - Asif Ali) was not aware of Left(), Last(), top 1, etc. functions in SQL. He said "is these functions exist in SQL". 🤣
If I get selected also, I will not be joining this company where basic technical knowledge is lacking.
If I get selected also, I will not be joining this company where basic technical knowledge is lacking.
Skills evaluated in this interview
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about Data Unveil?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. What is the Difference Between Drop and Truncate Command ? View Answers (1)
- Q2. What are the Validations you Perform in your Project ? View Answers (1)
- Q3. What is Star Schema and Snow flake schema ? View Answers (1)
- Q4. What is Fact and Dimension Tables View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Be Clear on Basics in First Round then go more Deeper in SQL Part for ETL Testers in Round 2
Skills evaluated in this interview
Lavanya Shankar
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Append a item in tuple Add Answer
- Q2. How to validate response body in api in restapi Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
No response
I applied via Naukri.com and was interviewed in Aug 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Explain project architecture? View Answers (1)
- Q2. Explain challenges you faced in etl testing? View Answers (1)
- Q3. What are roles and responsibilities? View Answers (1)
- Q4. How to find duplicate values in python? View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - ETL Concepts, Datawarehouse concepts and Python also must required
Skills evaluated in this interview
Interview experience
Average
Difficulty level
-
Duration
-
Result
Selected
I applied via Naukri.com and was interviewed in Jul 2024.
2 Interview Rounds
1
Technical Round (10 Questions)
- Q1. Write an SQL query to fetch 5th ,10th,15th .. records from a table? View Answers (1)
- Q2. What are constraints? View Answers (1)
- Q3. What is Low Priority , Medium Priority & High priority defects? View Answers (1)
- Q4. White box , Black Box ,regression , Retesting? View Answers (1)
- Q5. Joins ? with example View Answers (1)
- Q6. Window function queries? Add Answer
- Q7. Domain name from an email ? View Answers (1)
- Q8. Rank dense_rank() ,row_numebr with example? View Answers (1)
- Q9. SCD Types , Star Schema Vs SnowFlake Schema View Answers (1)
- Q10. Group by clause and how it work with a query View Answers (1)
2
HR Round (4 Questions)
- Q1. Salary expectations Add Answer
- Q2. Where do you see yourself in 5 years Add Answer
- Q3. Reason for job switch? View Answers (1)
- Q4. Strengths & weakness ? View Answers (1)
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via LinkedIn and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. What is deferred bug View Answers (1)
- Q2. Query to get 4th highest row based on a column View Answers (1)
Interview experience
Average
Difficulty level
Easy
Duration
2-4 weeks
Result
-
I applied via Naukri.com and was interviewed in Mar 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Explain inner join with an example View Answers (1)
- Q2. Explain cross join with an example View Answers (1)
- Q3. Provided Employee Table and asked to do a self join Add Answer
- Q4. Explain different types of data validation and checks performed in ETL testing View Answers (1)
Skills evaluated in this interview
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (4 Questions)
- Q1. What are scd types View Answers (1)
- Q2. How you identify duplicates and how to find latest duplicate View Answers (1)
- Q3. What is the difference between star schema and snowflake schme View Answers (1)
- Q4. What are the test articrafts View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Etl tools and technologies Add Answer
- Q2. Types of scd dimensions View Answers (2)
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
No response
I applied via Naukri.com and was interviewed in Jan 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Difference between snowflake schema and star schema View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Stay clam and tell me the truth.
Data Unveil Interview FAQs
How many rounds are there in Data Unveil ETL Tester interview?
Data Unveil interview process usually has 1 rounds. The most common rounds in the Data Unveil interview process are One-on-one Round.
What are the top questions asked in Data Unveil ETL Tester interview?
Tell us how to improve this page.
Data Unveil Interviews By Designations
Interview Questions for Popular Designations
- Software Tester Interview Questions
- Manual Tester Interview Questions
- QA Tester Interview Questions
- Automation Tester Interview Questions
- ETL Test Engineer Interview Questions
- Senior Software Tester Interview Questions
- Selenium Automation Tester Interview Questions
- Game Tester Interview Questions
- Show more
People are getting interviews through
based on 1 Data Unveil interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
ETL Tester Interview Questions from Similar Companies
|
Operations Analyst
6
salaries
|  ₹4 L/yr - ₹7.5 L/yr |
|
Data Analyst
4
salaries
| ₹5 L/yr - ₹11 L/yr |
|
Senior Business Analyst
4
salaries
| ₹14 L/yr - ₹18 L/yr |
|
IT Operations Analyst
3
salaries
| ₹3 L/yr - ₹4.6 L/yr |
Explore more salaries
Compare Data Unveil with
Fractal Analytics
Compare
Mu Sigma
Compare
Tiger Analytics
Compare
LatentView Analytics
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Data Unveil Interview Questions >
- Data Unveil ETL Tester Interview Questions
Share an Interview