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

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2023. There were 3 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 - Technical 

(1 Question)

  • Q1. L1 was scheduled and asked abt ETL basics, some sql queries related to string manipulation
Round 3 - Technical 

(1 Question)

  • Q1. After 1st round I was asked to submit resume again and BGV details. Submitted them and Waiting for round 2

Interview Preparation Tips

Interview preparation tips for other job seekers - L1 was good waiting for the result and L2
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Dec 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. DWH concepts, ETL concepts, JIRA tool,
  • Q2. Dwh concepts, ETL concepts, HPALM, informatica

Interview Preparation Tips

Interview preparation tips for other job seekers - I have an experience in ETL TEST ENGINEER, DWH testing
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. What are your salary expectations
  • Q2. Make sure you are not giving exact number unless its necessary and quote bit extra than what you expect because there will be always a negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about all DWH concepts , practice on SQL joins and sample test scenarios used for etl testing
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(4 Questions)

  • Q1. 1 introduce 2. framework 3 oops 4 palindrome code
  • Q2. Framework explain in detail
  • Ans. 

    A framework is a set of guidelines, libraries, and tools used to develop and test software applications.

    • Framework provides a structure for organizing code and implementing common functionalities.

    • It helps in reducing development time and improving code quality.

    • Examples include Selenium for automated testing, Spring for Java development, and React for front-end web development.

  • Answered by AI
  • Q3. Oops concept with use of it
  • Ans. 

    Oops concepts are fundamental principles of object-oriented programming that help in organizing and designing code efficiently.

    • Encapsulation: bundling data and methods that operate on the data into a single unit (class)

    • Inheritance: allowing a class to inherit properties and behavior from another class

    • Polymorphism: ability of objects to take on multiple forms or have multiple behaviors

    • Abstraction: hiding the complex imp...

  • Answered by AI
  • Q4. Daily routine and responcibility

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(1 Question)

  • Q1. What are the testing tools to be used?
  • Ans. 

    Some common testing tools include Selenium, JIRA, Postman, and TestRail.

    • Selenium - for automated testing of web applications

    • JIRA - for bug tracking and project management

    • Postman - for API testing

    • TestRail - for test case management and reporting

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(5 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a highly experienced software tester with a passion for ensuring quality and reliability in software products.

    • Over 8 years of experience in software testing

    • Expertise in manual and automated testing

    • Strong knowledge of testing methodologies and tools

    • Experience in testing web and mobile applications

    • Ability to work collaboratively with development teams

    • Proven track record of delivering high-quality software products

  • Answered by AI
  • Q2. How do you handle Testing in Agile
  • Ans. 

    Testing in Agile involves continuous testing throughout the development cycle.

    • Collaborate with the development team to ensure testing is integrated into each sprint

    • Use automation testing tools to speed up the process

    • Prioritize testing based on user stories and acceptance criteria

    • Perform exploratory testing to uncover defects that may have been missed

    • Ensure that testing is done in parallel with development to catch defe

  • Answered by AI
  • Q3. Some more questions on testing basics
  • Q4. Some questions on Selenium basics
  • Q5. Some on Scenario based Questions
Round 3 - HR 

(1 Question)

  • Q1. Salary Discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough in basics and have a good knowledge on your project and your roles an responsibilities in the project

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Aptitude Test 

Aptitude was 1st round, technical apti, then followed by tec nn iCal round

Round 3 - Technical 

(2 Questions)

  • Q1. Technical round was 2 nd, concepts related to testing Testing
  • Q2. Tsting related questions were asked in interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with basics of testing test cases defect reporting
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Be truthful in your resume. It is very easy to catch false or lies during the interview by asking basic questions.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. Testing Process
  • Q2. Questions related to automation testing
  • Q3. OOPS concepts, Selenium concepts
  • Q4. SQL concepts , security & performance testing concepts
Round 3 - One-on-one 

(3 Questions)

  • Q1. Agile process, Process related
  • Q2. Write a Program, Testing Framework knowledge
  • Q3. Other tools knowledge (if shown in resume)

Interview Preparation Tips

Interview preparation tips for other job seekers - Work load, No job security
If you get good manager then you will be on top otherwise pathetic life
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jan 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Manual testing, API , Real-time scenario

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
879 salaries
unlock blur

₹6 L/yr - ₹23 L/yr

Senior Software Engineer
553 salaries
unlock blur

₹6.8 L/yr - ₹24.5 L/yr

Software Engineer
258 salaries
unlock blur

₹3.5 L/yr - ₹14 L/yr

Technical Specialist
208 salaries
unlock blur

₹10.9 L/yr - ₹38.5 L/yr

Software Development Engineer
189 salaries
unlock blur

₹4.5 L/yr - ₹12 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