Senior ETL Developer

filter-iconFilter interviews by

Senior ETL Developer Interview Questions and Answers

Updated 16 May 2022

Popular Companies

Q1. What difference between temporary table and global temporary table?

Ans.

Temporary tables are session-specific while global temporary tables are accessible across sessions.

  • Temporary tables are created in a user's temporary tablespace and are automatically dropped at the end of the session.

  • Global temporary tables are created in a user's temporary tablespace but are not automatically dropped at the end of the session.

  • Temporary tables are only accessible within the session that created them.

  • Global temporary tables can be accessed by multiple sessions...read more

Q2. Different between function and Store procedure?

Ans.

Functions return a single value while stored procedures can return multiple values and perform complex operations.

  • Functions are used to perform a single operation and return a single value.

  • Stored procedures can perform complex operations and return multiple values.

  • Functions can be used in SQL statements while stored procedures cannot.

  • Functions are faster than stored procedures as they do not require compilation.

  • Stored procedures can be used to execute a series of SQL statemen...read more

Q3. How IICS and PC works

Ans.

IICS is a cloud-based integration platform while PC is a data integration tool for on-premise systems.

  • IICS stands for Informatica Intelligent Cloud Services

  • It is a cloud-based integration platform that allows users to integrate data from various sources

  • PC stands for PowerCenter

  • It is a data integration tool for on-premise systems

  • PC can extract data from various sources, transform it, and load it into a target system

  • Both IICS and PC are used for data integration and ETL process...read more

Q4. Drawback of SSIS packages?

Ans.

SSIS packages can be complex and difficult to troubleshoot.

  • Debugging can be time-consuming and challenging.

  • SSIS packages can be resource-intensive and slow down other processes.

  • Version control can be difficult to manage.

  • SSIS packages may not be suitable for real-time data integration.

  • SSIS packages may require additional licensing costs for advanced features.

Senior ETL Developer Jobs

Senior Etl Developer 6-11 years
Insightsoftware
3.5
Hyderabad / Secunderabad
Senior ETL Developer 5-10 years
Barclays Shared Services Pvt. Ltd
3.9
Pune
Senior ETL Developer- ADF 8-10 years
First American (India) Pvt Ltd
3.6
Bangalore / Bengaluru
Are these interview questions helpful?
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

3.7
 • 10.4k Interviews
3.6
 • 7.5k Interviews
3.8
 • 3.1k Interviews
3.8
 • 2.8k Interviews
3.7
 • 222 Interviews
3.0
 • 172 Interviews
3.8
 • 50 Interviews
View all

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

Recently Viewed
COMPANY BENEFITS
Dilip Buildcon
304 benefits
COMPANY BENEFITS
Dilip Buildcon
304 benefits
COMPANY BENEFITS
IRB Infrastructure
60 benefits
COMPANY BENEFITS
KNR Constructions
20 benefits
JOBS
Browse jobs
Discover jobs you love
LIST OF COMPANIES
Ambuja Cements
Overview
SALARIES
Osfin.ai
JOBS
Ceat Tyres
No Jobs
SALARIES
BIS Research
SALARIES
Osfin.ai
Senior ETL Developer Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter