Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by UST Team. If you also belong to the team, you can get access from here

UST Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 4.1k Reviews

Filter interviews by

UST ETL Tester Interview Questions and Answers

Updated 25 Nov 2024

UST ETL Tester Interview Experiences

1 interview found

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 25 Nov 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. What is referential integrity
  • Ans. 

    Referential integrity ensures that relationships between tables are maintained in a database.

    • It ensures that foreign key values in one table match primary key values in another table.

    • It helps maintain consistency and accuracy of data in the database.

    • If a foreign key value is deleted or updated, the corresponding primary key value should also be updated or deleted to maintain integrity.

  • Answered by AI

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Sql Quires related question.
  • Q2. Data ware house related question
  • Q3. What is entry criteria & exit criteria
  • Ans. 

    Entry criteria and exit criteria are conditions that must be met before and after testing, respectively.

    • Entry criteria are the conditions that must be fulfilled before testing can begin

    • Exit criteria are the conditions that must be fulfilled before testing can be considered complete

    • Entry criteria can include having test data ready, test environment set up, and test cases prepared

    • Exit criteria can include all test cases ...

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Types of schema
  • Ans. 

    Types of schema include star schema, snowflake schema, and fact constellation schema.

    • Star schema: central fact table connected to dimension tables in a star-like structure.

    • Snowflake schema: normalized form of star schema with dimension tables further normalized.

    • Fact constellation schema: multiple fact tables share dimension tables.

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Current Project explanation, MDM process, ETL Transformation rules, Rank and dense rank, and SQL Questions on all the Joins
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

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

Round 1 - Technical 

(5 Questions)

  • Q1. Explain about yourself
  • Q2. What is exploratory testing and adhoc testing and how you used these in your project?
  • Ans. 

    Exploratory testing is a simultaneous learning, test design, and test execution approach. Adhoc testing is an informal testing approach without any predefined test cases.

    • Exploratory testing involves exploring the software, learning about it, and designing and executing tests on the fly.

    • Adhoc testing is unplanned and unstructured testing where testers randomly test the application without any specific test cases.

    • In my p...

  • Answered by AI
  • Q3. Roles and responsibilities in your previous projects
  • Q4. Difference between mobile and web testing?
  • Ans. 

    Mobile testing focuses on apps for smartphones and tablets, while web testing focuses on websites accessed through browsers.

    • Mobile testing involves testing apps on different devices and operating systems.

    • Web testing involves testing websites on different browsers and screen sizes.

    • Mobile testing includes testing for touch gestures and device-specific features.

    • Web testing includes testing for cross-browser compatibility ...

  • Answered by AI
  • Q5. Challenges faced in your last project?

Skills evaluated in this interview

Software Tester Interview Questions & Answers

_VOIS user image Bidur Choudhary

posted on 27 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Basic interview questions a
  • Q2. Why do you want to join
  • Ans. 

    I am passionate about ensuring high-quality software and enjoy the challenge of finding bugs and improving user experience.

    • Passionate about ensuring high-quality software

    • Enjoy the challenge of finding bugs

    • Want to improve user experience

    • Excited about the opportunity to work in a dynamic and innovative team

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Test cases questions
  • Q2. Python questins

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in May 2024. There were 4 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. PT and Scripting
Round 2 - Technical 

(1 Question)

  • Q1. About PT and PE
Round 3 - One-on-one 

(1 Question)

  • Q1. Managerial based questions
Round 4 - HR 

(1 Question)

  • Q1. HR based question, about location , salary negotiation etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and well versed with your concepts

Manual Tester Interview Questions & Answers

Nagarro user image Nikita Khutwad

posted on 22 Feb 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Manaul testing concepts like defect life cycle,diff smoke sanity ,agile
Round 2 - Technical 

(1 Question)

  • Q1. Diff between smoke sanity ,agile ,sql like queries ,
  • Ans. 

    Smoke, sanity, agile, and SQL queries are different concepts in software testing.

    • Smoke testing is a quick test to check if the basic functionalities of the application are working.

    • Sanity testing is a subset of regression testing to ensure that specific areas of the application are still working after changes.

    • Agile is a software development methodology that emphasizes iterative development and collaboration.

    • SQL queries ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare all Manaul testing concepts

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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. Introduction current project framework java core selenium etc
Round 3 - Technical 

(1 Question)

  • Q1. Introduction current project framework core java version control CI/CD selenium etc
Round 4 - HR 

(1 Question)

  • Q1. Introduction salary discussion joining location LWD etc

Interview Preparation Tips

Interview preparation tips for other job seekers - keep your knowledge polished because interviewer ask from very basic to the current scenario.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Selenium concepts and basic java
Round 2 - Technical 

(1 Question)

  • Q1. Question related to conflict management
Round 3 - HR 

(1 Question)

  • Q1. Salary expectations

UST Interview FAQs

How many rounds are there in UST ETL Tester interview?
UST interview process usually has 1 rounds. The most common rounds in the UST interview process are Technical.
How to prepare for UST 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 UST. The most common topics and skills that interviewers at UST expect are ETL Testing, ETL, API Testing, Datastage and SQL.

Tell us how to improve this page.

People are getting interviews through

based on 1 UST interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
UST ETL Tester Salary
based on 49 salaries
₹3.7 L/yr - ₹15.8 L/yr
37% more than the average ETL Tester Salary in India
View more details

UST ETL Tester Reviews and Ratings

based on 7 reviews

4.4/5

Rating in categories

4.2

Skill development

4.5

Work-Life balance

4.2

Salary & Benefits

4.3

Job Security

4.3

Company culture

4.2

Promotions/Appraisal

4.3

Work Satisfaction

Explore 7 Reviews and Ratings
Software Developer
2k salaries
unlock blur

₹3.5 L/yr - ₹12.1 L/yr

Senior Software Engineer
1.6k salaries
unlock blur

₹6.5 L/yr - ₹26 L/yr

Software Engineer
1.3k salaries
unlock blur

₹3.7 L/yr - ₹14.6 L/yr

System Analyst
1.2k salaries
unlock blur

₹6.5 L/yr - ₹22.2 L/yr

Senior Software Developer
1.1k salaries
unlock blur

₹5.5 L/yr - ₹19.6 L/yr

Explore more salaries
Compare UST with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
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
write
Share an Interview