Upload Button Icon Add office photos

Brillio

Compare button icon Compare button icon Compare

Filter interviews by

Brillio ETL Tester Interview Questions and Answers

Updated 4 Sep 2024

Brillio ETL Tester Interview Experiences

1 interview found

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 4 Sep 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Difference between fact and dimension.
  • Ans. 

    Fact tables contain quantitative data that can be measured, while dimension tables contain descriptive attributes related to the facts.

    • Fact tables store numerical data such as sales revenue, quantity sold, etc.

    • Dimension tables store descriptive attributes like product name, customer name, etc.

    • Fact tables are typically larger in size compared to dimension tables.

    • Fact tables are connected to dimension tables through fore

  • Answered by AI
  • Q2. SQL query to find second Max salary.
  • Ans. 

    Use SQL query with subquery to find second highest salary.

    • Use ORDER BY and LIMIT to get the second highest salary.

    • Use a subquery to exclude the highest salary from the result set.

    • Example: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Jun 2019. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Configuration Management, data modelling, CI relationships, Problem management process flow, SIAM, integration, cmdb reports, KPIs.
  • Q2. General introduction, projects handled in the past,

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick to what u have worked on in your resume, ask about offered profile,

I applied via Campus Placement and was interviewed before Nov 2019. There were 8 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Porters Generic Marketing Strategy
  • Q2. Extempore Pitch to position a product differentially in the Market
  • Ans. 

    Our product is the only one in the market that offers a unique combination of features and benefits.

    • Our product is designed to solve a specific problem that no other product in the market can solve.

    • Our product offers a unique combination of features and benefits that are not available in any other product.

    • Our product is backed by extensive research and development, ensuring that it is the most effective solution in the...

  • Answered by AI
  • Q3. Why MBA, Why Marketing

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Be confident , Open and Prepared

2.Kindly understand the question and answer relating with some of the concepts you have studied

I applied via Naukri.com and was interviewed before Dec 2019. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Oracle Apps Technical - PlSQL concepts
  • Q2. Basic questions like logic to find even number, swap number ,etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to see all the Technology related questions in Google before going for interview.

Interview Questionnaire 

1 Question

  • Q1. Data transforms, integration, data pages, RAP, Case management

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and give your answer with confidence

I applied via Referral and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Its from Java, Springboot, Microservices.. and touchbase of UI technologies such as Angular.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be well prepared for evry topic.. ask yourself what, when, why, how.
Thats how you can think logically.

then only you will be able to crack.

I applied via Campus Placement and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is sdlc? Tell me about yourself. What is options future

Interview Preparation Tips

Interview preparation tips for other job seekers - Preparation tell me about yourself well

I applied via Approached by Company and was interviewed in Dec 2018. There were 2 interview rounds.

Interview Preparation Tips

General Tips: I believe Knowledge and application of knowledge are the only things required to get selected in any interview. To get this two things you have to work on your skills and have good hands on experience. You will be a master in applying your knowledge to real time problems if you have faced them with honesty, hard work and dedication in your current/previous work. Other skills like communication, presentation and domain knowledge comes as by product in the process of learning/day to day job. Make sure your basics are strong in whatever technology you are working in.
If you fail once, you will be better for the next. Good luck!
Skills: Communication, Problem Solving, Analytical Skills, Presentation Skills, Decision Making Skills
Duration: 1-4 weeks

Interview Questionnaire 

2 Questions

  • Q1. Technical
  • Q2. Be yourself

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

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing as such. Overall experience was good

Brillio Interview FAQs

How many rounds are there in Brillio ETL Tester interview?
Brillio interview process usually has 1 rounds. The most common rounds in the Brillio interview process are Technical.
How to prepare for Brillio ETL Tester interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Brillio. The most common topics and skills that interviewers at Brillio expect are Bi Testing, DWH Testing, Database Testing, ETL Testing and SQL Server Reporting Services.
What are the top questions asked in Brillio ETL Tester interview?

Some of the top questions asked at the Brillio ETL Tester interview -

  1. SQL query to find second Max sala...read more
  2. Difference between fact and dimensi...read more

Tell us how to improve this page.

Brillio ETL Tester Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Brillio ETL Tester Salary
based on 5 salaries
₹5.8 L/yr - ₹13 L/yr
26% more than the average ETL Tester Salary in India
View more details
Senior Engineer
881 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
558 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
258 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Specialist
207 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Development Engineer
188 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Brillio with

Accenture

3.8
Compare

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview