Upload Button Icon Add office photos
Engaged Employer

i

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

Zensar Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Zensar Technologies ETL Tester Interview Questions and Answers

Updated 12 Jun 2021

Zensar Technologies ETL Tester Interview Experiences

1 interview found

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 12 Jun 2021

Interview Questionnaire 

1 Question

  • Q1. Etl questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Padho aur badho

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Question regarding communication skill

I applied via Referral and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. I was asked about Python programming
  • Q2. My past experience job related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with technical skills

Interview Questionnaire 

1 Question

  • Q1. 3 rounds of interviews, 1. Technical: basics java & selenium & framework , 2. Technical: API and selenium questions, 3. Manager round: why you want to leave, some company-related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - work on java & framework

I applied via Approached by Company and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. C programming questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Questions are based on project being hired for, prepare accordingly.
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 Mar 2022. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why do you want to work with us
Round 2 - HR 

(1 Question)

  • Q1. How would you benefit our company

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep it up have confidence just be patient and you will be ✅

I applied via Naukri.com and was interviewed before Aug 2021. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Write some logical coding
Round 2 - Technical 

(1 Question)

  • Q1. Project related and technical
Round 3 - HR 

(1 Question)

  • Q1. Strength of yourself, expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - then got offerletter within 15 days, and very much supportive and coperative

Interview Questionnaire 

2 Questions

  • Q1. About insurance
  • Q2. About back logs

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

Interview Questionnaire 

20 Questions

  • Q1. What is Difference between C,C++?
  • Ans. 

    C is a procedural programming language while C++ is an object-oriented programming language.

    • C is a low-level language while C++ is a high-level language.

    • C++ supports object-oriented programming concepts like classes, inheritance, and polymorphism.

    • C++ has better support for exception handling and templates.

    • C++ is more complex than C and requires more memory.

    • C++ is used for developing applications like video games, while...

  • Answered by AI
  • Q2. What is a class?
  • Ans. 

    A class is a blueprint for creating objects that have similar attributes and behaviors.

    • Classes are used in object-oriented programming.

    • They define the properties and methods that objects of that class will have.

    • Objects are instances of a class.

    • Classes can inherit properties and methods from other classes.

    • Examples of classes include 'Person', 'Car', and 'Animal'.

  • Answered by AI
  • Q3. What is an object?
  • Ans. 

    An object is a self-contained entity that contains data and behavior.

    • An object is an instance of a class.

    • It has attributes (data) and methods (behavior).

    • Objects can interact with each other through their methods.

    • Examples include a car object with attributes like color and model, and methods like start and stop.

    • Another example is a person object with attributes like name and age, and methods like walk and talk.

  • Answered by AI
  • Q4. What is static variable?
  • Ans. 

    A variable that is associated with a class rather than with instances of the class.

    • Static variables are declared using the static keyword.

    • They are initialized only once, at the start of the program execution.

    • They retain their value throughout the program's execution.

    • They can be accessed without creating an instance of the class.

    • Example: public static int count = 0;

  • Answered by AI
  • Q5. What is difference between Static and Global Vaiable?
  • Ans. 

    Static variables have local scope but retain their value between function calls, while global variables have global scope.

    • Static variables are declared inside a function and retain their value between function calls

    • Global variables are declared outside of any function and can be accessed from any part of the program

    • Static variables have local scope, while global variables have global scope

    • Static variables are initializ...

  • Answered by AI
  • Q6. What are pointers?
  • Ans. 

    Pointers are variables that store memory addresses of other variables.

    • Pointers allow for dynamic memory allocation and manipulation.

    • They are commonly used in programming languages like C and C++.

    • Example: int *ptr; // declares a pointer to an integer variable

    • Example: ptr = # // assigns the memory address of num to ptr

    • Example: *ptr = 5; // assigns the value 5 to the variable pointed to by ptr

  • Answered by AI
  • Q7. What are structures?
  • Ans. 

    Structures are arrangements of elements that form a framework or framework-like support.

    • Structures can be found in various fields such as engineering, architecture, and biology.

    • They can be made of different materials such as steel, wood, or bone.

    • Examples include bridges, buildings, and the skeletal system.

    • Structures can be designed to withstand different types of forces such as compression, tension, or bending.

  • Answered by AI
  • Q8. What is a stack and various operations on it?
  • Ans. 

    A stack is a data structure that follows the Last In First Out (LIFO) principle.

    • Push: adds an element to the top of the stack

    • Pop: removes the top element from the stack

    • Peek: returns the top element without removing it

    • IsEmpty: checks if the stack is empty

    • Size: returns the number of elements in the stack

  • Answered by AI
  • Q9. What are 3 steps for using function in c?
  • Ans. 

    Three steps for using functions in C.

    • Declare the function with its return type, name, and parameters.

    • Define the function by writing the code for it.

    • Call the function by using its name and passing arguments if necessary.

  • Answered by AI
  • Q10. What is limit for no of arguments passed to functions? if limit is 10 den how to pass more parameters? Ans:- either Array or Structure
  • Ans. 

    The limit for the number of arguments passed to functions is not fixed. Arrays or structures can be used to pass more parameters.

    • The limit for the number of arguments passed to functions is not fixed and depends on the programming language and system architecture.

    • In C programming language, there is no limit on the number of arguments that can be passed to a function.

    • In Java, the maximum number of arguments that can be ...

  • Answered by AI
  • Q11. What is union?
  • Ans. 

    A union is an organization formed by workers to protect their rights and interests in the workplace.

    • Unions negotiate with employers for better wages, benefits, and working conditions.

    • They also provide support and representation for workers in disputes with management.

    • Membership in a union is voluntary, but members pay dues to support the union's activities.

    • Unions can be industry-specific, such as the United Auto Worker...

  • Answered by AI
  • Q12. What is difference between if else and switch case statements?
  • Ans. 

    if else is used for simple conditions while switch case is used for multiple conditions.

    • if else is a sequential decision-making statement while switch case is a multi-branch decision-making statement

    • if else is used when there are only a few conditions to be checked while switch case is used when there are multiple conditions to be checked

    • if else can have multiple conditions in a single statement while switch case can o...

  • Answered by AI
  • Q13. What are member functions?
  • Ans. 

    Member functions are functions that are defined inside a class and can access the class's private and protected members.

    • Member functions are also known as methods.

    • They can be used to manipulate the data members of an object.

    • They can be overloaded, meaning multiple functions with the same name but different parameters can exist within a class.

    • They can be declared as const, meaning they do not modify the object's state.

    • E...

  • Answered by AI
  • Q14. Find the output:- a=5;b=4;c=++a+b--; find c?
  • Ans. 

    Find the output of c=++a+b-- where a=5 and b=4.

    • The value of a is incremented by 1 before the addition operation

    • The value of b is decremented by 1 after the addition operation

    • The final value of c is 10

    • The value of a becomes 6 and the value of b becomes 3

  • Answered by AI
  • Q15. Plant 10 plants in 5 rows such that each row has 4 plants
  • Ans. 

    10 plants can be planted in 5 rows with 4 plants in each row.

    • Divide the plants into groups of 4.

    • Arrange the groups in 5 rows.

    • Each row will have 4 plants.

  • Answered by AI
  • Q16. There is 2 pot one red and one blue. one pot contains tressure. Two statement are given 1. only one of the statement is correct. 2. Blue pot has the tressure. Find the tressure?
  • Q17. Exceptions handling in java?
  • Ans. 

    Exceptions handling is a mechanism to handle runtime errors in Java programs.

    • Exceptions are objects that are thrown at runtime when an error occurs

    • Java provides try-catch-finally blocks to handle exceptions

    • Checked exceptions must be handled or declared in the method signature

    • Unchecked exceptions can be handled or left unhandled

    • Custom exceptions can be created by extending the Exception class

  • Answered by AI
  • Q18. Run me through your resume
  • Ans. 

    I have experience in project management, data analysis, and consulting across various industries.

    • Managed multiple projects simultaneously, ensuring timely delivery and client satisfaction

    • Analyzed data to identify trends and provide insights for clients

    • Consulted with clients to develop and implement strategies for growth and efficiency

    • Worked with clients in industries such as healthcare, finance, and retail

    • Collaborated ...

  • Answered by AI
  • Q19. Mostly my nterview was project based. He asked me to explain me my project. My contribution in it
  • Q20. What are your 5 year plans
  • Ans. 

    To gain experience in consulting and develop skills in project management, team leadership, and client relations.

    • Gain experience in consulting

    • Develop skills in project management

    • Develop skills in team leadership

    • Develop skills in client relations

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Written Test consists of following sections:
Technical sections had questions from almost all the sections(C, C++, DBMS, DS, OS)
Quantitative aptitude’s questions were good.. All were almost of R. S. Aggarwal’s level.
Logical reasoning and verbal ability was good.. Some questions were little tough.
Tips: Try to be fast n practice Quantitative aptitude to increase speed..

Round: Technical Interview
Experience: Technical Interview was conducted on skype. I was able to answer most of the questions. And if i could not answer i tried to explain my approach using examples...It lasted for 50 mins..

Tips: Brush up basics knowledge of C,C++ and be confident of what you know. And try to explain your approach if you couldn't tell answer.

Round: HR Interview
Experience: This interview was also through skype. You can drive this Interview towards the direction you want... This interview also lasted for 50 mins... I explained him my project.
Tips: Just be cool.. He was just checking your confidence n spirit to complete the task given to you..

All the best!!!!

General Tips: Practice Quant regularly from Rs.Agrawal, solve questions on DBMS and C,C++ from India Bix.. Test was conducted by AMCAT so try to find if its questions are available on internet.
Skills: C,C++
College Name: NIT Raipur
Motivation: Its clients which are AUDI, Ferrari, Coca-cola,Unilever.
Funny Moments: To try to make me comfortable he asked me weather i like coke or pepsi. He asked why? i said bcoz i feel coke has little less soda content in it.:P Next when i told him my hobbies are watching sitcoms he asked which sitcoms have u watched. I started naming sitcoms he had to intreuppt me.. den asked which one u liked best n y i was telling him the reason then in between he asked me about my project n i thought it was about sitcom so i was answering him about sitcom rather than my project then after a big confusion i co

Skills evaluated in this interview

I appeared for an interview before Dec 2015.

Interview Questionnaire 

2 Questions

  • Q1. Basic questions on Java and data structures with few analytics questions
  • Q2. Basic questions

Interview Preparation Tips

Round: Test
Experience: 1 minute for each question. Completely technical round with questions on Java, algorithm and data structures
Duration: 1 hour 30 minutes
Total Questions: 90

Round: HR Interview
Experience: They ask about your interest, your hobbies and once you are done with this they will ask you questions on the hobbies you previously claimed you like.

Skills: Java Programming
College Name: Thapar University, Patiala

Zensar Technologies Interview FAQs

How to prepare for Zensar Technologies 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 Zensar Technologies. The most common topics and skills that interviewers at Zensar Technologies expect are ETL Testing, Agile, Automation Testing, Data Warehouse Testing and PLSQL.

Tell us how to improve this page.

Interview Questions from Similar Companies

DXC Technology Interview Questions
3.7
 • 804 Interviews
Nagarro Interview Questions
4.0
 • 765 Interviews
NTT Data Interview Questions
3.8
 • 629 Interviews
Publicis Sapient Interview Questions
3.5
 • 623 Interviews
GlobalLogic Interview Questions
3.6
 • 594 Interviews
UST Interview Questions
3.8
 • 520 Interviews
CGI Group Interview Questions
4.0
 • 495 Interviews
View all
Zensar Technologies ETL Tester Salary
based on 12 salaries
₹3.6 L/yr - ₹9.2 L/yr
5% less than the average ETL Tester Salary in India
View more details
Software Engineer
3.8k salaries
unlock blur

₹2 L/yr - ₹10.4 L/yr

Senior Software Engineer
3.8k salaries
unlock blur

₹7 L/yr - ₹26 L/yr

Technical Specialist
1.5k salaries
unlock blur

₹9.6 L/yr - ₹35 L/yr

Softwaretest Engineer
827 salaries
unlock blur

₹2.4 L/yr - ₹9.8 L/yr

Senior Technical Specialist
729 salaries
unlock blur

₹11.5 L/yr - ₹40.2 L/yr

Explore more salaries
Compare Zensar Technologies with

DXC Technology

3.7
Compare

Sutherland Global Services

3.6
Compare

Optum Global Solutions

4.0
Compare

FIS

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