Upload Button Icon Add office photos

Filter interviews by

ZS Technologies ETL Developer Interview Questions and Answers

Updated 1 May 2023

ZS Technologies ETL Developer Interview Experiences

1 interview found

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

I applied via Naukri.com and was interviewed before May 2022. There were 3 interview rounds.

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 - Technical 

(2 Questions)

  • Q1. Basic questions about sql windows functions
  • Q2. They give a case study on data modelling before interview and you explain your approach for the case study during interview
Round 3 - One-on-one 

(3 Questions)

  • Q1. Explain the projects you worked on
  • Q2. Followup questions about the project
  • Q3. Situational questions about team management

Interview Preparation Tips

Interview preparation tips for other job seekers - Sharpen your sql and data warehousing skills

Interview questions from similar companies

I applied via LinkedIn and was interviewed in Aug 2022. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Question on logic SCD types
  • Q2. Dynamic lookup along with lookup

Interview Preparation Tips

Interview preparation tips for other job seekers - Technical mainly logic and interview is cool Lister so that you can explain well
Round 1 - Technical 

(1 Question)

  • Q1. About the ETL Process
Round 2 - HR 

(1 Question)

  • Q1. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Good and be confident on what you want to convery.

I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. General, project overview, technology stack, scenario based questions, challenges and experiences
Round 2 - HR 

(1 Question)

  • Q1. General, salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be genuine and share your experiences

ETL Developer Interview Questions & Answers

Tech Mahindra user image RAMAVATHULA CHANDRA NAIK

posted on 4 Feb 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. They were asking very logical and technical questions on interview time
  • Q2. They were test our skills and time punctuation
Round 2 - HR 

(1 Question)

  • Q1. They were discussed with some technical questions and based on knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - They were asking technical questions and based on our resume mentioned questions

I applied via Recruitment Consulltant and was interviewed in Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Introduction, projects worked, technology stack, scenario based questions, challenges
Round 2 - HR 

(1 Question)

  • Q1. Salary negotiation and general discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay confident and be open with the answers.

I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Oracle DWH concept Informatica

Interview Preparation Tips

Interview preparation tips for other job seekers - Just apply .you may not be the best candidate or have all the require qulification ,but you 'll never
get a job you don't try
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(1 Question)

  • Q1. Which version of talend you are using
  • Ans. 

    I am using Talend version 7.3.1 for ETL development.

    • I am currently using Talend version 7.3.1 for ETL development.

    • The specific version of Talend being used is 7.3.1.

    • Talend 7.3.1 offers various features and improvements for ETL processes.

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

4 Questions

  • Q1. Whats is mapping
  • Ans. 

    Mapping is the process of defining the relationship between source and target data in ETL.

    • Mapping involves identifying the source and target data structures.

    • It also involves defining the transformation rules to be applied to the source data.

    • Mappings can be simple or complex depending on the complexity of the data.

    • Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target

  • Answered by AI
  • Q2. What is sesson
  • Ans. 

    Session refers to a period of time during which a user interacts with a computer system or application.

    • A session is created when a user logs into a system or application.

    • It is used to track user activity and maintain user-specific data.

    • Sessions can be terminated manually or automatically after a certain period of inactivity.

    • Session management is important for security purposes.

    • Examples of session management techniques

  • Answered by AI
  • Q3. Which role u did
  • Q4. Oracle sqi pl sqi
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. What is the uses of filter stage
  • Ans. 

    Filter stage is used in ETL processes to selectively pass or reject data based on specified criteria.

    • Filter stage helps in removing unwanted data from the input dataset.

    • It can be used to apply conditions like filtering out duplicate records, selecting specific columns, or excluding certain values.

    • For example, a filter stage can be used to only pass records where the sales amount is greater than $1000.

  • Answered by AI
  • Q2. What is the uses of transfor stage
  • Ans. 

    Transform stage is used in ETL process to apply business rules, clean and enrich data before loading into target database.

    • Transform stage is used to apply business rules to the data.

    • It is used to clean and standardize data before loading into the target database.

    • Transform stage can also be used to enrich data by combining multiple sources or adding calculated fields.

    • Examples include converting data types, removing dupl

  • Answered by AI
  • Q3. What is the uses of sort stage
  • Ans. 

    Sort stage is used in ETL processes to sort data based on specified criteria before loading it into the target system.

    • Sort stage helps in arranging data in a specific order for better analysis and reporting

    • It can be used to remove duplicates from data before loading

    • Sorting can be done based on multiple columns or expressions

    • Example: Sorting customer data based on their purchase amount before loading into a data warehou

  • Answered by AI
  • Q4. How to create the prallel job
  • Ans. 

    To create a parallel job, use parallel processing techniques to divide tasks into smaller subtasks that can be executed simultaneously.

    • Identify tasks that can be executed independently and in parallel

    • Use parallel processing techniques such as multi-threading or distributed computing

    • Implement parallel job using ETL tools like Informatica or Talend

    • Monitor and optimize parallel job performance to ensure efficient executio

  • Answered by AI
  • Q5. Defenation of scd
  • Ans. 

    SCD stands for Slowly Changing Dimension, a technique used in data warehousing to track changes in dimension attributes over time.

    • SCD is used to maintain historical data in a data warehouse

    • There are different types of SCDs - Type 1, Type 2, and Type 3

    • Type 1 SCD overwrites old data with new data

    • Type 2 SCD creates a new record for each change and maintains history

    • Type 3 SCD keeps a limited history by adding columns to tr

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Hi my name is ravindra pls check my profile .i'm intrested ur company

Skills evaluated in this interview

ZS Technologies Interview FAQs

How many rounds are there in ZS Technologies ETL Developer interview?
ZS Technologies interview process usually has 3 rounds. The most common rounds in the ZS Technologies interview process are One-on-one Round, Resume Shortlist and Technical.
What are the top questions asked in ZS Technologies ETL Developer interview?

Some of the top questions asked at the ZS Technologies ETL Developer interview -

  1. They give a case study on data modelling before interview and you explain your ...read more
  2. Basic questions about sql windows functi...read more

Tell us how to improve this page.

ZS Technologies ETL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Compare ZS Technologies with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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