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 Developer Interview Questions and Answers for Freshers

Updated 1 Feb 2024

UST ETL Developer Interview Experiences for Freshers

1 interview found

ETL Developer Interview Questions & Answers

user image Akshay Jagirdaar

posted on 1 Feb 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Some in depth questions about python and java
Round 2 - Coding Test 

Asked some problem solving questions they will allow to choose the language it's good

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain SSIS and ite use cases
  • Ans. 

    SSIS is a Microsoft tool used for ETL processes in data integration and data warehousing.

    • SSIS stands for SQL Server Integration Services

    • It is used for extracting, transforming, and loading data from various sources to destinations

    • SSIS can be used for automating workflows, data cleansing, and data migration tasks

    • It provides a visual interface for designing data flow tasks and control flow tasks

    • Example: Using SSIS to ext...

  • Answered by AI

Skills evaluated in this interview

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

I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed before Jan 2024. There were 4 interview rounds.

Round 1 - Coding Test 

3 coding problems
1 aptitude
1 puzzle
3 hrs duration

Round 2 - Technical 

(2 Questions)

  • Q1. Sorting algorithms
  • Q2. 1 puzzle - burning candles
Round 3 - Technical 

(2 Questions)

  • Q1. General discussion on resume
  • Q2. Few reasoning questions
Round 4 - HR 

(1 Question)

  • Q1. About company work culture
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Asked basics of Javascript and ReactJS and data flow

Round 2 - Technical 

(1 Question)

  • Q1. What is react and concept of Virtual dom and real dom
  • Ans. 

    React is a JavaScript library for building user interfaces. Virtual DOM is a lightweight copy of the Real DOM, used for efficient updates.

    • React is a popular JavaScript library for building user interfaces.

    • Virtual DOM is a lightweight copy of the Real DOM, used for efficient updates.

    • When changes are made in React, the Virtual DOM is updated first, then compared to the Real DOM to minimize actual DOM manipulation.

  • Answered by AI

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Java basics oops, and others stuff in the resume
Interview experience
4
Good
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 - Aptitude Test 

Easy aptitude questions with minimum tough

Round 3 - Coding Test 

2 rounds of coding.. one is normal coding another is super coding

Round 4 - Technical 

(2 Questions)

  • Q1. What is polymorphism,buzz words of java
  • Ans. 

    Polymorphism is the ability of an object to take on many forms.

    • Polymorphism allows objects of different classes to be treated as if they are of the same class.

    • It is achieved through method overloading and method overriding.

    • Example: A parent class Animal can have child classes like Dog, Cat, and Bird. Each child class can have its own implementation of the method 'makeSound', but they can all be called using the same me...

  • Answered by AI
  • Q2. Difference between html and html5
  • Ans. 

    HTML5 is the latest version of HTML with new features and improvements.

    • HTML5 supports multimedia elements like video and audio without plugins.

    • HTML5 has new semantic tags like

      ,
      ,
    • HTML5 has improved form elements like date pickers, range sliders, etc.

    • HTML5 has better support for mobile devices and responsive design.

    • HTML5 has improved performance and security compared to HTML.

    • HTML5 has a canvas element for drawing...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident be brave . You can do it . And this is a good company. Good mnc

Skills evaluated in this interview

I was interviewed in May 2022.

Round 1 - Coding Test 

(4 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

First round has 4 coding Questions in which i have solved 3 complete and 1 partial.

  • Q1. Crazy Numbers

    Ninja loves playing with numbers. So one day, he wants to arrange a few numbers in the ‘N’ number of rows. The first row contains 1 number, the second row has two numbers, the third row has 3...

  • Ans. Brute force

    The key here is to traverse all the lines sequentially, and for each line, we print the required character at the given index.

    The steps are as follows:

    • We will define matrix ‘ans’ to store the final pattern.
    • We will initialize a variable ‘k’ to 1, which will be the starting value for the pattern.
    • We will iterate over all the rows, i.e., i = 0 to i = N - 1:
      • We will run a for loop starting from j = N - i -1 with t...
  • Answered by CodingNinjas
  • Q2. Pairs with difference K

    You are given with an array of integers and an integer K. You have to find and print the count of all such pairs which have difference K.

    Note: Take absolute difference between th...

  • Ans. Space Complexity: O(1)Explanation: Time Complexity: O(1)Explanation:
  • Answered by CodingNinjas
  • Q3. Fibonacci Member

    Given a number N, figure out if it is a member of fibonacci series or not. Return true if the number is member of fibonacci series else false.

    Fibonacci Series is defined by the recurren...

  • Ans. Space Complexity: Explanation: Time Complexity: Explanation:
  • Answered by CodingNinjas
  • Q4. Ninja And The New Year Guests

    Ninja has organized the new year party and invited all the programmers for it, as being the programmer also has been invited by Ninja.

    To detect whether the guest is a progr...

  • Ans. Brute Force Approach

    Approach: We will recursively find all possible permutations and then check for each of them whether it is following the condition or not.

     

    We will maintain a counter based on that and increment it when the current permutation satisfies the condition.

     

    Algorithm :  

     

    // It is a recursive function to get all the permutations of the current array 'arr'.

    void getPermutations(arr, i...

  • Answered by CodingNinjas
Round 2 - Video Call 

(2 Questions)

Round duration - 20 minutes
Round difficulty - Easy

Every single question were based on the concept of data structure.
I have to answer my approach for solving a particular real life Problem.

  • Q1. Valid Parentheses

    You're given string ‘STR’ consisting solely of “{“, “}”, “(“, “)”, “[“ and “]” . Determine whether the parentheses are balanced.

    Input Format:
    The first line contains an Integer &...
  • Ans. 

    Declare a character stack S.
    Now traverse the expression string exp. 
    If the current character is a starting bracket (‘(‘ or ‘{‘ or ‘[‘) then push it to stack.
    If the current character is a closing bracket (‘)’ or ‘}’ or ‘]’) then pop from stack and if the popped character is the matching starting bracket then fine else brackets are not balanced.
    After complete traversal, if there is some starting bracket left in stac

  • Answered by CodingNinjas
  • Q2. Aptitude Question

    Find the angle between the minute and The hour clock
    if its 4:10

Round 3 - HR 

(1 Question)

Round duration - 15 minutes
Round difficulty - Easy

  • Q1. Basic HR Questions

    Why do u want to join Nagarro
    Explain About Yourself.

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from AKGEC : Ajay Kumar Garg Engineering College. I applied for the job as Software Developer in GurgaonEligibility criteriaNONagarro interview preparation:Topics to prepare for the interview - Data Structures, OOPS, Python, Full stack Web development, System Design, Algorithms.Time required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Focus majorly on Data Structures and algorithms
Tip 2 : Master on One Programming Fundamentals
Tip 3 : Build one live Project on any tech stack.

Application resume tips for other job seekers

Tip 1 : Be concise and Confident what you have written in your resume.
Tip 2 : Make sure to mention any coding Profile which u practice on and one live project.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
-

I was interviewed in Nov 2022.

Round 1 - Aptitude Test 

An aptitude test is a way for employers to assess a candidates abilities through a variety of different testing formats

Round 2 - HR 

(2 Questions)

  • Q1. An interview that typically conducted by a human resources generalist at the beginning of the hiring process
  • Q2. While the HR interview gets a bad reputation for being a formality

Interview Preparation Tips

Interview preparation tips for other job seekers - Fight for happiness
Learn something new every day
Market yourself
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 - Coding Test 

Good questions related to coding and performance tuning

Round 3 - HR 

(2 Questions)

  • Q1. General HR questions
  • Q2. Questions about location and salary

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well as a fresher at least know basics of coding and oops concepts and best practices

I was interviewed in Sep 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 90 minutes
Round difficulty - Medium

Timing -12pm to 1:30pm
Test environment was good and we should keep in our mind about our net speed.

  • Q1. Reverse the array

    Given an array with N elements, the task is to reverse all the array elements and print the reversed array.

    Input Format:

    The first line contains an integer N representing the size of ...
  • Ans. Brute Force approach
    • Initialise start and end indices with start = 0, end = N-1 where N is the total number of elements in array.
    • We then run a loop while start < end and swap arr[start] with arr[end].
    • Finally, we increment start and decrement end variable
    Space Complexity: O(1)Explanation: Time Complexity: O(1)Explanation:
  • Answered by CodingNinjas
  • Q2. Tiling Problem

    You have been given a board where there are '2' rows and 'N' columns. You have an infinite supply of 2x1 tiles, and you can place a tile in the following ways:

    1. Horizontal...
  • Ans. Recursion And Memoization (Runtime error)

    Try to place the tile to fill the unit column and calculate the number of ways from smaller sub-problems. Then use memoization to convert O(2^N) solution to an O(N) solution.

    1. At any point we are at ‘idx’ column then we can place our tile in two ways to fill this column.
      1. Option 1 -  1 Horizontal Tile

    We can place in this way where we have ‘idx-1’ column filled.

        &nb...

  • Answered by CodingNinjas
Round 2 - Video Call 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Easy

Timing was 3pm to 4 pm
environment was easy familier and interviwer was also in good mood ,first he ask me about general things then he come on OS/DBMS .

  • Q1. DBMS Questions

    Normalization forms.
    Entity relational model

Round 3 - HR 

(1 Question)

Round duration - 30 Minutes
Round difficulty - Easy

timing - 10am to 10:30am
environment was very familier and interviewer was with good sence of humor

  • Q1. Basic HR Questions

    Would you prefer work from home or would like to come to office?

    What is your biggest achievement.

    Are you a team player?

  • Ans. 

    Tip 1 : do what you are real and don't try to be fake 
    Tip 2 : be confident and try to explain in simple way

  • Answered by CodingNinjas

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in NoidaEligibility criteriaCGPA 7Global Logic interview preparation:Topics to prepare for the interview - Data Structure, OOPS,MERN STACK, DBMS,OSTime required to prepare for the interview - 12 MonthsInterview preparation tips for other job seekers

Tip 1 : Don't depend on video only , practice is must and assignments provided by coding ninja's are best.
Tip 2 : Note all important point in note book so that you can easy revise.
Tip 3 : Make at least 3-4 projects on your on

Application resume tips for other job seekers

Tip 1 : Be real don't go for fake and write what you are.
Tip 2 : Mention all your project and explain them in good way

Final outcome of the interviewSelected

Skills evaluated in this interview

UST Interview FAQs

How many rounds are there in UST ETL Developer interview for freshers?
UST interview process for freshers usually has 2 rounds. The most common rounds in the UST interview process for freshers are Technical and Coding Test.
How to prepare for UST ETL Developer interview for freshers?
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, SQL, Informatica, Application Development and Bash.
What are the top questions asked in UST ETL Developer interview for freshers?

Some of the top questions asked at the UST ETL Developer interview for freshers -

  1. What is difference between cluster and non cluster in...read more
  2. What is inital load in ...read more
  3. Some in depth questions about python and j...read more

Tell us how to improve this page.

UST ETL Developer Salary
based on 82 salaries
₹4 L/yr - ₹11.5 L/yr
6% less than the average ETL Developer Salary in India
View more details

UST ETL Developer Reviews and Ratings

based on 7 reviews

4.7/5

Rating in categories

4.7

Skill development

4.7

Work-Life balance

4.5

Salary & Benefits

4.7

Job Security

4.6

Company culture

4.5

Promotions/Appraisal

4.6

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

Software Engineer
1.3k salaries
unlock blur

₹3.6 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.5 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