Etl interview Questions

                                                                                                                                         <<<            >>>

ETL interview questions:



  1. What is the difference between OLAP and OLTP?
  2. Tell me about your ETL workflow process?
  3. What is the difference between Operational Database and Warehouse?
  4. What type of approach you follow in your project?
  5. What is the difference between Data Mart and data ware house?
  6. In your project you are using which type of data base and how much space ?
  7. Explain the test case template?
  8. What is the difference between Severity and Priority?
  9. What is the difference between SDLC and STLC?
  10. What is the difference between Issue Log and Clarification Log?
  11. What type of bugs you have faced in your project?
  12. What is Banking?
  13. Explain what are the types of Banking?
  14. What is the difference between Dimension table and Fact table?
  15. Explain SCD’s and their types? how it will be used?
  16. Explain Bug reporting?
  17. Are you using any models in SDLC?
  18. Which process used in ETL Testing?
  19. What is unit testing? who will do this?
  20. Whats the difference between Incremental Load and Initial Load?
  21. Through which document you have done your project?
  22. Are you using Requirement tab in QC?

81 comments:

  1. Unknown22 June 2013 at 01:30

    it's a Nice article, very helpful for us and thank's for sharing. we are providing ETL Testing online training

    ReplyDelete
  2. Abhishek22 August 2013 at 00:01

    Nice Info !!

    ReplyDelete
  3. Unknown25 September 2013 at 04:02

    hi you have gathered a valuable information on ETL testing...., I am looking for content like this and i am much impressed with the information and nice course content, thanks a lot for the Information regarding ETL testing Online Training.

    ReplyDelete
  4. Unknown27 September 2013 at 05:02

    Thanks for gathering information regarding ETL testing,I have gathered 123trainings the best ETL testing ONLINE TRAINING provider from hyderabad.

    ReplyDelete
    Replies
    1. hai8 October 2013 at 02:05

      Hi,if u want any doubts from ETL Testing course in real time scenario's,send me a mail i wil send u answers. (penchal555@gmail.com)
      Thanks,
      cpb

      Delete
  5. hai8 October 2013 at 02:02

    Hi,if u want any doubts from ETL Testing course in real time scenario's,send me a mail i wil send u answers. (penchal555@gmail.com)
    Thanks,
    cpb

    ReplyDelete
  6. hai8 October 2013 at 02:04

    Hi,if u want any doubts from ETL Testing course in real time scenario's,send me a mail i wil send u answers. (penchal555@gmail.com)
    Thanks,
    cpb

    ReplyDelete
  7. Unknown23 October 2013 at 02:42

    Thanks for sharing valuable information and it is useful for 123 trainings provides the best ETL Testing Online Training classes.To see free demo classes ETL Testing Online Training in Uk,CANADA.

    ReplyDelete
  8. Unknown24 October 2013 at 05:05

    Nice article i was really impressed by seeing this article, it was very intresting and it is very useful for ETL Testing Online Training Learners.. I came to know that 123trainings is also one of the best ETL Testing online training institute at hyderabad.

    ReplyDelete
  9. Unknown11 November 2013 at 04:11

    Thanks for sharing valuable information and it is useful for BigInfosys provides the best ETL Testing Online Training classes.

    ReplyDelete
  10. Unknown3 December 2013 at 12:06

    hi frd, can u send me real time scenarios with answers and if u have articles of etl & sql send me pls.

    thank u very much....

    ReplyDelete
  11. Unknown15 January 2014 at 22:31

    Please provide answers for above question its really very usefull please .. please send to my mail ID shivukumar47@gmail.com plzzzzzz

    ReplyDelete
  12. Uttam Kedia19 February 2014 at 19:14

    Nice Post..

    Hi All,

    I have been working in DWH project for 6 years. I have gone through so many interviews and taken also..

    If anybody wants to go through ETL testing , unix and sql interview questions then follow the below link :

    http://techloverforum.blogspot.com/?view=magazine

    Hope you will like the posts.

    Thanks!

    ReplyDelete
  13. Editor26 January 2015 at 22:10

    Thank you for sharing this Useful Information !!

    LINUX INTERVIEW QUESTIONS


    Linux FTP vsftpd Interview Questions

    SSH Interview Questions

    Apache Interview Questions

    Nagios Interview questions

    IPTABLES Interview Questions

    Ldap Server Interview Questions

    LVM Interview questions

    Sendmail Server Interview Questions



    Read more at Linux Troubleshooting

    ReplyDelete
  14. Unknown8 February 2015 at 20:49

    Nice information. Our institute Is the Leading online institute in Hyderabad, India to provide SAS online trainings with the real time experts and certified professionals. alot SAS Online Training.

    ReplyDelete
  15. krishna8 March 2015 at 04:41

    Hadoop online Training in Hyderabad

    ReplyDelete
  16. Unknown2 April 2015 at 22:19

    Uniqe informative content, thanks for sharing. Today I see myself proud to be a hadoop professional with strong dedication and will power by blasting the obstacles. Thanks to Hadoop Training in Chennai

    ReplyDelete
  17. Unknown24 April 2015 at 02:18


    Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    CCNA training in chennai | CCNA training chennai | CCNA course in chennai | CCNA course chennai

    ReplyDelete
  18. Unknown22 July 2015 at 05:53

    This comment has been removed by the author.

    ReplyDelete
  19. Unknown22 July 2015 at 05:57

    ETL testing Online training is the process for extracting, transforming and loading large amount of data from a single database to another. There are numerous ways of doing it such as coding your own processes to the more often used way of implementing ETL tools continious the web site http://www.hyderabadsys.com/etl-testing-online-training/ Etl testing online training .

    ReplyDelete
  20. peterjohn7 August 2015 at 05:27

    I really enjoy the blog.Much thanks again. Really Great.
    Very informative article post.Really looking forward to read more. Will read on…

    sap online training
    hadoop online training
    sap-crm-online-training
    hadoop online training

    ReplyDelete
  21. Unknown8 August 2015 at 10:41

    I was reading your blog this morning and noticed that you have a awesome
    resource page. I actually have a similar blog that might be helpful or useful
    to your audience.

    Regards
    sap sd and crm online training
    sap online tutorials
    sap sd tutorial
    sap sd training in ameerpet

    ReplyDelete
  22. asitbangalorereviews18 August 2015 at 02:54

    Very useful...
    Core Java Interview Questions and Answers

    Advanced Java Interview Questions and Answers

    c++ interview questions and answers

    Mysql Interview Questions and Answers

    Testing Questions and Answers

    ReplyDelete
  23. Unknown18 August 2015 at 05:48

    ETL Like next big thing will definitely be hadoop and it is well taught at hadoop online training in hyderabad and I became expert in all concepts of hadoop.

    ReplyDelete
  24. Unknown21 September 2015 at 01:15

    Thanks for the info..Really useful :)Please visit the link

    http://www.tekclasses.com/

    ReplyDelete
  25. Unknown21 September 2015 at 01:18

    very informative!!if you are interested visit the link.

    http://www.tekclasses.com/

    ReplyDelete
  26. Unknown21 September 2015 at 01:22

    NICE BLOG...

    http://www.tekclasses.com/

    ReplyDelete
  27. Unknown21 September 2015 at 02:39

    The Best Kits Online Trainings,thanks for sharing

    ETL Testing Online Training institute

    Hadoop Online Training institute

    Hyperion Online Training institute

    Informatica Online Training institute

    Java Online Training institute

    QTP &QC Online Training institute

    Microstrategy Online Training institute

    MSBI Online Training institute

    Oracle 11g RAC Online Training institute

    Oracle DBA Online Training institute

    ReplyDelete
  28. Unknown13 November 2015 at 22:07

    Rajasthan Gram Panchayat 2252 Sathin Recruitment 2015-16

    Nice blog! The content is impress me. Thanks for sharing...........

    ReplyDelete
  29. Unknown2 December 2015 at 02:16

    Latest Govt JObs 2016

    It was helpful and will really help me in building my new blog traffic and increasing my readers per day......................

    ReplyDelete
  30. Unknown10 December 2015 at 04:32

    Your style is so unique compared to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I’ll just bookmark this page.
    SAP APO Online Training

    ReplyDelete
  31. Unknown11 December 2015 at 05:15

    Hi, Explain your last project? (My project is in Healthcare insurance domain), how to explain this project as a ETL tester in an interview? Pls send me detailed answer to koribp@gmail.com.

    ReplyDelete
  32. Unknown11 January 2016 at 05:57

    This comment has been removed by the author.

    ReplyDelete
  33. Unknown11 January 2016 at 05:59

    Nice Blog..!!
    Thank you for sharing such a good information..
    We Provide ETL TESTING ONLINE TRAINING

    ReplyDelete
  34. Mervin Parmar13 January 2016 at 04:54

    Using big data analytics may give the companies many fruitful results, the findings can be implemented in their business decisions so as to minimize their risk and to cut the costs.
    hadoop training in chennai|big data training|big data training in chennai

    ReplyDelete
  35. Unknown17 January 2016 at 03:44

    Cloud computing is the next big thing, through cloud the users have the liberty to use a shared network. The companies can focus on core business parts rather than investing heavily on infrastucture.
    cloud computing training in chennai|cloud computing courses in chennai|cloud computing training

    ReplyDelete
  36. Unknown12 February 2016 at 02:00

    very nice article.Thanks for sharing the information.
    Amazon Web Server

    Android

    ReplyDelete
  37. Unknown10 May 2016 at 13:14

    The Author did a great work. It’s really helpful for cracking ETL interviews. I have gone through each and every site; it’s really helpful for me. Keep sharing. Suppose if you want more Interview Questions/A’s regarding ETL I will share you link just have a look: https://goo.gl/oSxf3W I hope it will help who are looking for ETL Interview.

    ReplyDelete
  38. Unknown24 May 2016 at 00:25

    Hii you are providing good information.Thanks for sharing if anyone interested SAP APO
    Online training See below

    http://www.sapapoonlinetraining.in/


    ReplyDelete
  39. Unknown17 June 2016 at 04:31

    thanks for sharing..
    http://www.informaticaonlinetraining.co/

    ReplyDelete
  40. Unknown2 September 2016 at 00:37

    Very good collection of question thank you for sharing this article. Know more about Talend Online Training

    ReplyDelete
  41. Unknown6 September 2016 at 22:27

    Nice! and keep sharing the data and if any one interested in bigdata hadoop online training in hyderabad refer the at hadoop online training

    ReplyDelete
  42. Unknown23 October 2016 at 23:13

    Thanks for sharing this valuable information.
    lenovo laptop service center in chennai
    lenovo thinkpad service center chennai
    lenovo ideapad service center chennai

    ReplyDelete
  43. Unknown26 October 2016 at 04:40

    Thanks for sharing this valuable information.
    SOAP UI training in chennai

    ReplyDelete
  44. Unknown26 October 2016 at 04:41

    Great and Useful Article.
    JAVA training in chennai

    ReplyDelete
  45. Unknown2 December 2016 at 03:51

    The best article to read thank you for sharing. ETL Testing Training Videos

    ReplyDelete
  46. Stepherd22 December 2016 at 02:17

    This is a great post. I like this topic.This site has lots of advantage. It helps me in many ways.Thanks for posting this again.
    Recruitment Consultancy in Chennai

    ReplyDelete
  47. Unknown12 January 2017 at 03:21

    thanks for sharing info

    tamil actres unseen photo

    ReplyDelete
  48. Unknown15 May 2017 at 02:28

    Excellent information regarding etl testing interview questions.This information is useful who search for Jobs. So we need this information.... Currently i am looking for etl testing jobs in hyderabad location.Thank you for sharing this great post .

    ReplyDelete
  49. Unknown18 July 2017 at 23:30

    Thank you so much for sharing this worth able content with us. The concept taken here will be useful for my future programs and i will surely implement them in my study. Keep blogging article like this.

    Tableau Online Training|
    R Programming Online Training|
    SAS Online Training |

    ReplyDelete
  50. Unknown2 October 2017 at 00:39

    Great info. for more details, visit https://edduy.com/etl-testing-interview-questions-and-answers-for-freshers-and-experienced-part-1/

    ReplyDelete
  51. Raj Sharma13 June 2018 at 22:09

    This information you provided in the blog that is really unique I love it!! Thanks for sharing such a great blog Keep posting..
    ETL Interview Questions and Answers

    ReplyDelete
  52. sandeep7 August 2018 at 03:52


    such a wonderful article...very interesting to read ....thanks for sharining .............

    Informatica online training in Hyderabad

    ReplyDelete
  53. Unknown2 September 2018 at 22:59

    The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.

    ccna training in chennai



    ccna training in bangalore


    ccna training in pune

    ReplyDelete
  54. rohini8 October 2018 at 04:11

    Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
    Selenium Training in Bangalore | Selenium Training in Bangalore | Selenium Training in Pune | Selenium online Training

    ReplyDelete
  55. gowthunan2 November 2018 at 01:30

    I have to voice my passion for your kindness giving support to those people that should have guidance on this important matter.
    best safety training in chennai

    ReplyDelete
  56. Sadhana Rathore27 November 2018 at 23:07

    Thanks for taking time to share this etl interview questions with answers. It is really helpful. Share more like this.
    ccna Training in Chennai
    ccna Training near me
    ccna course in Chennai
    ccna Training institute in Chennai
    ccna institute in Chennai
    ccna Training in Velachery

    ReplyDelete
  57. Sadhana Rathore9 January 2019 at 04:37

    Thanks a lot for sharing this page, really helpful.
    R Training in Chennai
    R Programming Training in Chennai

    ReplyDelete
  58. jefrin17 January 2019 at 23:36

    Great topic thanks for sharing
    ccna training course in chennai

    ReplyDelete
  59. jefrin29 January 2019 at 23:44

    Wow good to read thanks for sharing


    R training in chennai

    ReplyDelete
  60. karthick20 February 2019 at 05:23

    This comment has been removed by the author.

    ReplyDelete
  61. karthick20 February 2019 at 05:24

    This is Very Useful blog, Thank you to Share this.
    Best Dotnet Training in Chennai

    ReplyDelete
  62. Muralidhara Raju Indukuri16 March 2019 at 01:13

    Thanks for super info.
    aws training in hyderabad

    ReplyDelete
  63. service care18 March 2019 at 07:31

    I am obliged to you for sharing this piece of information here and updating us with your resourceful guidance. Hope this might benefit many learners. Keep sharing this gainful articles and continue updating for us.
    oneplus service center chennai
    oneplus service center in chennai
    oneplus service centre chennai

    ReplyDelete
  64. Vicky Ram5 April 2019 at 00:18

    It is a great post. Keep sharing such kind of useful information.

    Guest posting sites
    Technology

    ReplyDelete
  65. svrtechnologies19 March 2020 at 03:13

    I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.

    sas tutorial

    ReplyDelete
  66. Anonymous24 May 2020 at 06:13

    It is a very useful blog to know all the information.

    Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery

    ReplyDelete
  67. subha29 May 2020 at 01:52

    Hi,

    Thanks For sharing a valuable post, this is very informative and useful... keep sharing.lovely post guys.
    C and C++ Training Institute in chennai | C and C++ Training Institute in anna nagar | C and C++ Training Institute in omr | C and C++ Training Institute in porur | C and C++ Training Institute in tambaram | C and C++ Training Institute in velachery

    ReplyDelete
  68. Unknown24 June 2020 at 22:07

    Very much helpful information. Thanks for sharing your blog.
    etl testing online
    etl testing online course

    ReplyDelete
  69. rocky9 July 2020 at 07:59

    I'm interested for more information.
    Python Training in Chennai | Certification | Online Course Training | Python Training in Bangalore | Certification | Online Course Training | Python Training in Hyderabad | Certification | Online Course Training | Python Training in Coimbatore | Certification | Online Course Training | Python Training in Online | Certification | Online Course Training


    ReplyDelete
  70. sudhan3 August 2020 at 03:27

    Awesome blog with great piece of information. Very well written blog with crisp and neat content. Keep sharing more such blogs.
    Cyber Security Training Course in Chennai | Certification | Cyber Security Online Training Course | Ethical Hacking Training Course in Chennai | Certification | Ethical Hacking Online Training Course | CCNA Training Course in Chennai | Certification | CCNA Online Training Course | RPA Robotic Process Automation Training Course in Chennai | Certification | RPA Training Course Chennai | SEO Training in Chennai | Certification | SEO Online Training Course

    ReplyDelete
  71. johnny11 August 2020 at 06:12

    Do you need to hack into any, databaseserver spy on Facebook,Emails, Whatsapp, Viber, Snapchat, Instagram and many more.
    I urge you to get in touch with the best people for the job, i have confirm the service when i need to spy on my spouse phone. They are good at Phone Cloning and Bitcoin/binary minning and any other hack job.
    Thanks guys for the team work HACKINTECHNOLOGYATGMAILDOTCOM
    +12132951376(WHATSAPP)

    ReplyDelete
  72. suresh22 December 2020 at 02:02

    DevOps is currently a popular model currently organizations all over the world moving towards to it. Your post gave a clear idea about knowing the DevOps model and its importance.

    DevOps Training in Chennai

    DevOps Course in Chennai

    ReplyDelete
  73. Ranjith31 December 2020 at 01:03

    Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.

    python Training in chennai

    python Course in chennai


    ReplyDelete
  74. Takipçi Satın Al27 June 2021 at 17:13

    Hızlı takipçi almak için takipçi satın al
    Organik takipçi almak için takipçi satın al
    Bilgisayardan takipçi almak için takipçi satın al
    Mobil cihazdan takipçi almak için takipçi satın al
    Gerçek ve orijinal takipçi almak için takipçi satın al
    Yazarkasa ile takipçi almak için takipçi satın al
    Bitcoin takipçi almak için takipçi satın al
    Pos ile takipçi almak için takipçi satın al
    EFT ile takipçi almak için takipçi satın al
    Havale ile takipçi almak için takipçi satın al
    Mobil ödeme ile takipçi almak için takipçi satın al
    Tamamı orijinal takipçi almak için takipçi satın al
    Organik ile takipçi almak için takipçi satın al
    Türkiye takipçi almak için takipçi satın al
    Global takipçi almak için takipçi satın al
    En hızlı instagram takipçi satın al
    En uygun instagram takipçi satın al
    En telafili instagram takipçi satın al
    En gerçek spotify takipçi satın al
    En ucuz instagram takipçi satın al
    En otomatik instagram takipçi satın al
    En sistematik tiktok takipçi satın al
    En otantik instagram takipçi satın al
    En opsiyonel instagram takipçi satın al
    En güçlü instagram takipçi satın al
    En kuvvetli instagram takipçi satın al
    En seri instagram takipçi satın al
    En akıcı instagram takipçi satın al
    En akıcı instagram takipçi satın al
    En akıcı instagram takip etmeyenler

    ReplyDelete
  75. Prakash29 July 2021 at 05:11

    Really you have done a good job. Thanks for sharing this valuable information....
    Informatica Future Scope
    Informatica MDM Jobs in India
    MDM Informatica
    Top 5 Reasons To Learn Informatica MDM

    ReplyDelete
  76. Kaparthicynixit6 August 2021 at 00:04

    Thanks for sharing such a helpful, and understandable blog. I really enjoyed reading it.
    Visit us: Dot Net Online Course
    Visit us: .Net Online Training

    ReplyDelete
  77. Anonymous1 May 2022 at 07:17

    mmorpg
    ınstagram takipci satin al
    Tiktok Jeton Hilesi
    tiktok jeton hilesi
    SAC EKİMİ ANTALYA
    referans kimliği nedir
    instagram takipçi satın al
    metin2 pvp serverlar
    instagram takipçi satın al

    ReplyDelete
  78. Anonymous17 May 2022 at 21:51

    perde modelleri
    sms onay
    mobil ödeme bozdurma
    nft nasıl alınır
    ankara evden eve nakliyat
    trafik sigortası
    DEDEKTOR
    web sitesi kurma
    aşk kitapları

    ReplyDelete
  79. Anonymous3 June 2022 at 15:59

    beykoz bosch klima servisi
    üsküdar bosch klima servisi
    kadıköy toshiba klima servisi
    maltepe beko klima servisi
    kadıköy beko klima servisi
    ümraniye lg klima servisi
    ümraniye toshiba klima servisi
    ümraniye beko klima servisi
    beykoz lg klima servisi

    ReplyDelete

Subscribe to: Posts (Atom)