Upload Button Icon Add office photos

Filter interviews by

Horizon Architects ETL Tester Interview Questions and Answers

Updated 25 Jun 2024

Horizon Architects ETL Tester Interview Experiences

1 interview found

ETL Tester Interview Questions & Answers

user image Rafire s

posted on 25 Jun 2024

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about your last project
  • Q2. How do you delete duplicates from each department
  • Ans. 

    Use SQL query with GROUP BY and HAVING clause to delete duplicates from each department

    • Use GROUP BY clause to group the records by department

    • Use HAVING clause to filter out the duplicates within each department

    • Write a DELETE statement to remove the duplicate records

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - study well in sql intermediate queries

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
1w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Horizon Architects?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be focused and concentrated during the interview and read and try to understand your role and responsibility. Be calm and patience during your interview, it will help you to clear interview.

ETL Tester Interview Questions Asked at Other Companies

asked in Cognizant
Q1. If we have 200 staging tables, 40 dimension tables, and 20 fact t ... read more
asked in Cognizant
Q2. 2.Difference between Union and union all,drop and Truncate,star s ... read more
asked in Cognizant
Q3. What type of validation will you perform in the landing and stagi ... read more
Q4. What is the difference between a Test Plan and a Test Strategy?
asked in Infosys
Q5. How do you get data integrity between source and destination, how ... read more

I applied via Campus Placement and was interviewed before Jun 2020. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Why EY
  • Q2. Your strength
  • Q3. Your weakness
  • Q4. Long term and short term goals

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't stress be honest and give your 100%

I applied via Campus Placement and was interviewed before May 2021. There were 3 interview rounds.

Round 1 - Case Study 

Internal case of a biscuit manufacturing company. Details about company background, sales, figures are given and based on those 3 questions were asked.

Round 2 - Case Study 

Part 2 of the same case study was asked where the company should go for IPO or expansion in local market. based on the facts, decision and justification had to be given

Round 3 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Confidence is key for this job. Even if the background is not an exact match they are willing to give you a shot if you think you are better.

I applied via Naukri.com and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Case Study 

Global warming

Round 2 - Group Discussion 

General with companies details

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Calm and compose, don't too excited not to be too excited.

I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I was asked the basic Core java questions along with the OOPS concepts as well as Springboot and REST API with some database basic questions. The next round will be a managerial round where you will be ask...

Interview Preparation Tips

Interview preparation tips for other job seekers - Some tips that worked for me :
1. Don’t mention the things in your resume that you are not confident about. Doesn’t matter if your resume is not full of skills, it should be crisp and on-point
2. If you don’t know answer to any of the questions then politely say you are not sure about this question . Its better than giving gibberish answers.
3. Be confident and have faith in yourself.
ALL THE BEST

I applied via Naukri.com and was interviewed in Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Technical which relates to your experience and profile
  • Q2.  other than technical questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared
Are these interview questions helpful?

I applied via Naukri.com and was interviewed before Nov 2018. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Mainly fully technical skills -2technical +1 HR round

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be prepared completely as they will completely focus on what is written on your resume. Please do not write fake experience on any skills . You will be caught. HR compensations provided are really pretty good if your technical round goes really outstanding.

Interview Preparation Tips

Round: Resume Shortlist
Experience: Didn't read any material saw resumes of my friends who pass out last year to see how to organize my points. Prepare my resume and refine it with the help of my friends several times

Round: HR Interview
Experience: Saw common HR questions from the websites and prepare answers for that .worked in groups in which one person acted as an interviewer.

Round: Case Study Interview
Experience: For the case studies, I referred many e-books available to learn the basic procedure to solve case studies. Sample case studies are also available on sites of these companies (Mckinsey.com, BCG.com or Bain.com)

Round: Puzzle Interview
Experience: Some companies asked puzzles. Common puzzles can be found on internet (pagalguy.com, brainvista.com , or orkut)

College Name: IIT BOMBAY

Interview Questionnaire 

6 Questions

  • Q1. Resume-based questions
  • Q2. What is the color of door from which you entered?
  • Ans. 

    The door from which I entered was brown.

    • The door was made of wood.

    • The color was a dark shade of brown.

    • There were no decorations or patterns on the door.

  • Answered by AI
  • Q3. Did you attend the ppt? What did you like the most about ppt?
  • Ans. 

    Yes, I attended the ppt and found the case studies presented to be the most interesting.

    • Attended the ppt

    • Found the case studies to be the most interesting

    • Impressed by the data presented

    • Liked the interactive nature of the presentation

  • Answered by AI
  • Q4. Intern-based questions
  • Q5. If you start a startup of selling books to IITK students through e-commerce what will be the annual demand you can expect from IITK students?
  • Ans. 

    The annual demand for selling books to IITK students through e-commerce depends on various factors such as the number of students, their course curriculum, and their reading habits.

    • The demand can be estimated by conducting a survey among the students to understand their reading habits and preferences.

    • The demand can also be influenced by the availability of books in the campus library and bookstores.

    • The demand may vary ...

  • Answered by AI
  • Q6. In your hostel every girl plays badminton atleast once a month. The probability of one playing badminton in 1st week is a, probability that if one doesn’t play in 1st week than she will play in 2nd week is...
  • Ans. 

    Calculating the probability of two friends playing badminton in the same week given certain probabilities.

    • Calculate the probability of both playing in the first week (a*a)

    • Calculate the probability of both playing in the second week ((1-a)*b*(1-c))

    • Calculate the probability of both playing in the third week ((1-a)*(1-b)*c)

    • Calculate the probability of both playing in the last week ((1-a-b-c)*(1-a-b-c))

    • Add up all the proba...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 1. Number of Questions: 30 (10 each from mathematics, English and DI).
2. Type of questions and details Questions of Mathematics and DI were mainly from previous years CAT papers. 
3. The time was very limited and so speed was very important while solving the questions. 
4. Moreover there was cut off for individual sections so keeping that in mind one had give time to each section.
Duration: 30-40 minutes
Total Questions: 10+10+10

Round: HR Interview
Experience: Most of the questions were resume based. The interviewer also tried to confuse me sometimes. While I was answering he looked at the ceiling and here and there but I ensured that I was still answering everything very confidently not diverting my attention.

Round: Case Study Interview
Experience: It was a HR + puzzle + casestudy interview and lasted for 20-25 minutes and had a panel of only one.

General Tips: 1. Don’t leave everything for the end. As December approaches it becomes more and more hectic with end sems, project deadlines, BTP, ppts to attend, test of companies etc. Start preparing early.
2. Do attend ppt and write down points whatever they mention in the ppt. generally one can prepare the questions like why this sector or why this company from the points they mention in ppt. 
3. They generally mention that they are looking for in the candidates in the ppt so this helps in preparing the answers in interview. Moreover do spend some time in preparing for HR. 
4. At least think and write down few basic points of the questions that are generally asked in the interviews.
Skill Tips: Do solve all previous year question papers of CAT and try to increase speed of solving.
Do practice some case studies and puzzles.
Skills:
College Name: IIT KANPUR

Horizon Architects Interview FAQs

How many rounds are there in Horizon Architects ETL Tester interview?
Horizon Architects interview process usually has 1 rounds. The most common rounds in the Horizon Architects interview process are Technical.

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 1 interview experience

Difficulty level

Easy 100%

Duration

Less than 2 weeks 100%
View more
Medical Coder
5 salaries
unlock blur

₹2 L/yr - ₹3.8 L/yr

Accountant
4 salaries
unlock blur

₹2.5 L/yr - ₹3 L/yr

Architect
4 salaries
unlock blur

₹5.5 L/yr - ₹8.4 L/yr

Sales Manager
4 salaries
unlock blur

₹2.8 L/yr - ₹4 L/yr

Junior Architect
4 salaries
unlock blur

₹1.8 L/yr - ₹3.8 L/yr

Explore more salaries
Compare Horizon Architects with

Cognizant

3.7
Compare

Teleperformance

3.9
Compare

iEnergizer

4.7
Compare

Reliance Retail

3.9
Compare
write
Share an Interview