ETL Testing 5 hours complete training | ETL Testing interview preparation | What is ETL testing
#etltesting
In this video we will learn
etl testing interview questions and answers,
etl testing interview,
etl testing real time,
ETL Testing: What, Why, and How to Get Started
ETL Testing,
Basics of ETL Testing with sample queries,
ETL testing interview preparation,
Introduction to ETL Testing,
ETL Testing Tutorial for Beginners
========================================================
Informatica Self-Paced Courses and Interview Questions Links:
courses.nicitacademy.com/courses
Are you interested in joining my Live training? or Self-Paced course?
Feel free to contact me for more details @+917010080468 🌕 wa.link/m4lat0
WhatsApp group:
chat.whatsapp.com/I8ijRV6xjvO...
Please visit our website for more details.
www.nicitacademy.com/
Thanks,
NiC IT Academy
========================================================
📌 Please write to me for any help on ETL testing - nicitacademy@gmail.com
Please add your suggestions/feedback/Queries in comments, I will answer it and I am happy to help you
📌 Like the video and forward it to your friends circle.
📌 Informatica training in TAMIL - Playlist
• Informatica Training -...
📌 Informatica training in ENGLISH - Playlist
• Informatica Training S...
📌 Informatica Interview Preparation - TAMIL
• Informatica Interview ...
📌 Informatica Interview Preparation - ENGLISH
• Informatica Interview ...
********************************************************************************
Informatica Self-Paced Courses and Interview Questions Links:
courses.nicitacademy.com/courses
Are you interested in joining my Live training? or Self-Paced course?
Feel free to contact me for more details @+917010080468 🌕 wa.link/m4lat0
WhatsApp group:
chat.whatsapp.com/I8ijRV6xjvO...
Please visit our website for more details.
www.nicitacademy.com/
Thanks,
NiC IT Academy
*********************************************************************************
📌 Oracle SQL - Complete tutorial Playlist
• Oracle SQL Tutorial - ...
***********************************************************************************
📌 Oracle SQL Day wise Video:
Oracle SQL Tutorial - Day 1 - • Oracle SQL Day 1|Oracl...
Oracle SQL Tutorial - Day 2 - • Day 2 - Oracle SQL for...
Oracle SQL Tutorial - Day 3 - • Day 3 - Oracle SQL for...
Oracle SQL Tutorial - Day 4 - • Day 4 - Oracle SQL for...
Oracle SQL Tutorial - Day 5 - • Day 5 - Oracle SQL for...
📌 Oracle Day 3 Notes:
=====================
drive.google.com/file/d/1RgXu...
**********************************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL
• SQL tutorial TAMIL | ...
📌Oracle SQL Day wise Video: TAMIL
-----------------------------------
Oracle SQL in Tamil - Day 1 - • Day 1 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 2 - • Day 2 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 3 - • Day 3 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 4 - • Day 4 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 5 - • Day 5 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 6 - • Day 6 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 7 - • Day 7 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 8 - • Day 8 - SQL in TAMIL |...
Oracle SQL in Tamil Day 9 - • Oracle SQL Analytical ...
Oracle SQL in Tamil Day 10 - • Views in Oracle SQL TA...
************************************************************************************
🔥 • Informatica Training S...
• Informatica Interview ...
In this video, we’ll learn what is ETL testing
ETL testing Interview preparation
ETL Testing
etl v/s database testing,
etl training,etl tutorial,
data cleansing,
etl training course,
data warehousing,
etl tutorial for beginners,
etl,etl v/s bi tools,
staging area,
dimensional modelling,
scd types, dimension tables,
fact table, normalization, dimension table,
enterprise ware house schema,
star schema, snow flake star schema,
architecture of data ware houses
====================================================
Audio track credit:
Believe Music
Пікірлер: 280
*Complete 48 hours of Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy
Simply wow, explained every well, even nill knowledge person also will understand in first attempt
@NICITACADEMY
2 жыл бұрын
Thank You very much. Keep watching my channel.
Complete agree its a wonder session which cover all the area of ETL testing. Thank you so much!!
@NICITACADEMY
2 жыл бұрын
You're very welcome!
This is the best ETL testing video I have ever seen...covers all concepts from Start to the End... great session 🙌👏
@NICITACADEMY
2 жыл бұрын
Wow, thanks! Keep watching my channel.
*Informatica Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/courses Are you interested in joining my Live training? or Self-Paced course? Feel free to contact me for more details @+917010080468 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Please visit our website for more details. www.nicitacademy.com/ Thanks, NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English kzread.info/head/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* kzread.info/dash/bejne/dWWuqbiLdrCZXaQ.html 📌*Informatica Full Course:* kzread.info/dash/bejne/iGZ61ryYebHTmso.html 📌*SQL Full Course:* kzread.info/dash/bejne/m6mq3MyfZ9G7Yaw.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist kzread.info/head/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist kzread.info/head/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH kzread.info/head/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் kzread.info/head/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist kzread.info/head/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL kzread.info/head/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer kzread.info/head/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos kzread.info/head/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks
I can easily understand SQL when you explain in tamil
That's the video I was looking for. Thanks!
@NICITACADEMY
Жыл бұрын
Thanks, Keep watching my channel.
Love the way you are explaining, thanks a lot
@NICITACADEMY
2 жыл бұрын
Thanks for liking. keep watching my channel.
Your session is very good and informative 🙏🏻
@NICITACADEMY
2 жыл бұрын
So nice of you. Thank you! Keep watching my channel.
Thank you very much 🥰 for uploading video full course
@NICITACADEMY
2 жыл бұрын
Most welcome
Excellent!! This is the best video I ever seen in KZread😍
@NICITACADEMY
2 жыл бұрын
Thank you so much 😀
Sir super teaching... God bless you...
@NICITACADEMY
2 жыл бұрын
Thank You, Keep watching my channel.
All rounder performance 👍👍👍👍 Nice video 🎉🎉🎉
@NICITACADEMY
2 жыл бұрын
Many many thanks. Keep watching.
Thank you soo much sir for your valuable video which was explained in a very good way where a zero knowledge person can get self confidence to attend interview for etl testing.
@NICITACADEMY
6 ай бұрын
Thanks and welcome
GREAT!!!😀
Very well and beautifully explained Sir.. 🙏🙏🙏🙏🙏 Thank you..
@NICITACADEMY
Жыл бұрын
Thanks 🙏. Keep watching my channel
Thank you so much. Wonderful subject. The ways u have explained terrific . Could you pls share some real time live project. For validation
@NICITACADEMY
2 жыл бұрын
Thanks for your wonderful feedback. Keep watching my channel.
Most expected video...keep rocking
@NICITACADEMY
2 жыл бұрын
Thank you so much 😀
Great sir. Its very useful
@NICITACADEMY
2 жыл бұрын
So nice of you. Keep watching my channel and support.
Iam a ETL developer . Video is so usefull.. expecting more videos for etl and future development in ETL
@NICITACADEMY
2 жыл бұрын
Thanks, Sure
@venkateshvenki7552
2 жыл бұрын
Hello Hai bro I'm learning Sql course present how it's jobs and working bro please reply me
@bhaskarkavuluri6838
2 жыл бұрын
Hai Bro, i have some doubts about ETL , can i make a call to you bro
You are the best Sir!!!
@NICITACADEMY
9 ай бұрын
Thank You. Keep watching my channel. courses.nicitacademy.com/courses
Sir I want to know if informatica still holds its values in 2022? There are other tools like Talend what do you think which etl tool is best for career growth.
sir you're doing great job
@NICITACADEMY
2 жыл бұрын
Thanks and welcome
Sir is enough for informatics.... Thanks for this video
@NICITACADEMY
2 жыл бұрын
Most welcome, yeah its enough
its verry useful sir...keep rocking...
@NICITACADEMY
2 жыл бұрын
Thank you, Keep watching.
Very helpful..Thankyou👍
@NICITACADEMY
2 жыл бұрын
Welcome 😊 Thank You!. Keep watching my channel.
Thank you For this Video.
@NICITACADEMY
2 жыл бұрын
You're welcome
Superb video sir..
@NICITACADEMY
2 жыл бұрын
Thanks a ton. Keep watching my channel. Add your queries, I will create new video on the required topics.
tq sir these classes use full in medille class pepules
@NICITACADEMY
2 жыл бұрын
You're most welcome
I love the way u teach👌👌
@NICITACADEMY
2 жыл бұрын
Thank You, keep watching my channel. Post your queries in comments.
It's really very helpful for us. Thank you so much brother, the way of explanation is very good and if possible could you please share some Realtime live project validations in ETL testing.
@NICITACADEMY
2 жыл бұрын
Sure, I will share it. I have already discussed some of the Realtime use case. please watch it second half part..
when we prepare test cases, we are only preparing test cases that are mentioned on (STTM) mapping document right? or do we need to prepare other test cases that are not in the STTM? for example nulls validation and other validations? this one has always confused me.
Keep rocking....sir
@NICITACADEMY
2 жыл бұрын
Thank you.
Thanks for the videos that you have shared with us Savior
@NICITACADEMY
Жыл бұрын
Thanks Brother. Keep watching my channel
best video
Thanku sir
Hello sir, your videos are useful for etl Testing aspirants, Could please share the file and how to install hp QC in pc
Wow, it's great explanation. Please upload teradata sql and ETL real time project also...
@NICITACADEMY
Жыл бұрын
I have already posted Teradata videos in NIC IT Academy 2.0 Please check kzread.info/dash/bejne/oZ5hmMVtqcXbg7g.html
Thank you sir !!
@NICITACADEMY
2 жыл бұрын
Most welcome!
Sir, please make a vedio for ab initio tool either in dev or testing, it will be more helpful
Super explanation
@NICITACADEMY
2 жыл бұрын
Thank you 🙂
As yo mentioned for dimension table, there would be only Non-measurable data. In product dim table there is price of the product, isn't it measurable.? Thank you
Thanks so much
@NICITACADEMY
2 жыл бұрын
You're welcome!
Thanks a lot
@NICITACADEMY
2 жыл бұрын
Most welcome
First like
How to check data consistency and How to check if table has ASCCI values..I am not able to answer...plas give the answer for those questions
Sir please send me manual pdf for simple project.. So everybody easily understand it.. Actually I am having zero knowledge and trying to get job with ur vlogs only
Hi dude Using Informatica, flat file data can be loaded into staging, and developers can add any logic. Or, the mapping will be tested.
great sir
@NICITACADEMY
Жыл бұрын
Thanks
Great 👍🏻
@NICITACADEMY
Жыл бұрын
Thanks ✌️
Sir I need urgent video on hpalm or notes prepared by u
Send some interview questions or how to crcak interview tricks
Great explanation sir Please make one video on how to create and why do create or who create traceability matrix documents as etl tester
@NICITACADEMY
2 жыл бұрын
Sure. I ll do. Keep watching my channel
@Azaan1p
2 жыл бұрын
@@NICITACADEMY sure
Very useful content, My primary skill is different but I got an opportunity on ETL Testing by learning this video. Thankyou so much sir. Is there any full ETL Testing video sir?
@NICITACADEMY
Жыл бұрын
I will add more videos on ETL testing. Keep watching my channel.
i wish this video has english sub, that's so great 🥰
@NICITACADEMY
2 жыл бұрын
Working on it!
@hectorromero685
2 жыл бұрын
@@NICITACADEMY .
Hi bro, This etl testing is only for testing domain right?
Sir please provide some pdf s related to this...
Hi sir, I have couple of things to clarify..... Please get time to help me out.... Thanks... I am into Manual Testing now. Having basic knowledge in Selenium-Java and Database testing. I am planning to upskill myself on ETL testing. This would be really helpful. Couple of doubts I am having before starting it. 1. Is this course enough for starting a career in ETL testing?? 2.What are the pre-requisites?? 3. Are you providing any online courses??
Please do more videos on ETL testing sir
@NICITACADEMY
2 жыл бұрын
Sure, I ll do.
Nesecito subtítulos en español o en ingles!! Gracias!!
it is really helpful except the ma'am asking too many question as dev side.
@NICITACADEMY
2 жыл бұрын
Thanks
Please send me interview question a nd answers for etl testing in pdf..
Hi can you please share all the materials that you used during 5 hrs session? including TCs, STTM etc?? I would be greatful
@NICITACADEMY
6 ай бұрын
Please check here courses.nicitacademy.com/
Hello sir, if source is flat file and target is database then how we can validate data from staging to data warehouse?
@NICITACADEMY
2 жыл бұрын
We have use some tool to test it like Querysurge.
@rajeshkadlag5310
2 жыл бұрын
@@NICITACADEMY can you make video on this topic?
I joined as Etl tester with Sql knowledge but I don’t know how to do any validations in Etl but they took me based on my Sql. Can you please help me out how to work on this as I’m from mapping background and I changed my domain recently. So it’s being very tough for me to work on.
@NICITACADEMY
2 жыл бұрын
please watch my SQL Session.
@bhaskarkavuluri6838
2 жыл бұрын
Hai , i have some doubts about ETL, i think u already worked on it so can u help me
Hi Chandra sir, it seems You are like Etl dictionary. Do you put any videos related tableau report testing
@NICITACADEMY
2 ай бұрын
Thank you for your wonderful feedback. I will add Tableau video as well. Keep watching my channel.
Hi Sir, could you please share me the link of sql which you were mentioning, i could only see oracle sql in your playlist
@NICITACADEMY
9 ай бұрын
kzread.info/dash/bejne/q6mfrpuvgsTShtI.html
how much ETL tester has a scope in career ? and what should be the next step after ETL Tester?
@NICITACADEMY
2 жыл бұрын
Hi, ETL tester has good scope and you can move on to Big data testing, Data lake testing further. So be confident and learn it. SQL and Unix is mandatory
Hii sir If source have 100 records and target gets 80 records only. How to get back those records in to target using in informatica
@NICITACADEMY
2 жыл бұрын
Check my KZread session on debugger and dependency check.
Nenga tamil? I have 7 years in manual testing. I planning to move to ETL testing domain. I need some guidance from you. Can you please help me
@NICITACADEMY
2 жыл бұрын
Please watch my ETL testing full session, ETL developer full session. We have lot of openings
@dineshbe7076
2 жыл бұрын
Sir, Are you providing online training.
hi sir how can we test if sourceid of one DB type as oracle and target is Teradata kind of thing? can you please make one video for better understanding in that scenario?
@NICITACADEMY
2 жыл бұрын
I have explained the same scenario in this video itself. Please watch without skipping.
@sudharani1702
2 жыл бұрын
@@NICITACADEMY We need to load the data from in to staging by creating Teradata connection which makes the data will be stored in Teradata . Can you please let me know my understanding correct or not? I am little confused here so just wanted to have clarification.
@NICITACADEMY
2 жыл бұрын
yes correct, That's the way we can test it, Approach 1: Create a stage layer in TD and do one to one load in TD and compare TD stage to TD target. Approach 2: otherwise we can go with some tools like QuerySurge to compare data from two different data bases.
@live-dy1gu
2 жыл бұрын
Got it sir thank you Appreciate your efforts in providing the knowledge on informatica sessions
@sudharani1702
2 жыл бұрын
@@NICITACADEMY Sir I could not find video on joiner transformation? Can you please upload the same?
Hi Sir, This tutorial was very useful. One small request from can you also please post the same ETL tutorial in tamil.
@NICITACADEMY
Жыл бұрын
It is already available kzread.info/dash/bejne/aqRnl7yRnsvcqM4.html
@ganeshv2123
Жыл бұрын
@@NICITACADEMY Thanks sir
Sir, is this enough for 3 plus experience knowledge in etl testing?
@NICITACADEMY
2 жыл бұрын
Yes, of course. It is enough to work.
Hi Sir, Thanks for your tutorial. Can you please post this tutorial in Tamil.
@NICITACADEMY
7 ай бұрын
Thanks, Will upload soon. Keep watching my channel.
Sir pls Talend ETL tool using Oracle SQL tutorial vedio post pannugka sir
@shanmugapriya.s3133
6 ай бұрын
With English subtitle
With English subtitles for talend ETL tool pls
source have 10k records without any transformation applied data moved to target directly what are the validation tester perform ??
@NICITACADEMY
Жыл бұрын
Since it is one to one load, We can do below testing 1. Count check 2. Null value check 3. Data type and data precision check 4. Target-Source and Source-Target etc...
@neethisurya9755
Жыл бұрын
4th one is Minus query?? A-B and B -A ?
Sir I have completed mechanical engineering 2018-19 batch, i got gap i dint worked anywhere, now I want to join it sector, some people recommending me to do ETL TESTER COURSE, what's your suggestion, plz reply
@NICITACADEMY
2 жыл бұрын
Yes definitely you can learn SQL and ETL testing and you can try for IT. More of our followers getting job. so prepare and try.
@bkr6273
2 жыл бұрын
@@NICITACADEMY sir in etl testing work pressure is more or normal? Does we get wrok from home work in etl testing or not?
@NICITACADEMY
2 жыл бұрын
It is based on the project where we are working.
All good..But the time, live lesson starts, there is one girl keeps asking repeated questions with lots of attitude..Which is irritating..
Overview of testing - Diagram 21:32
Could you please Upload Tamil version of ETL testing🙏
@NICITACADEMY
4 күн бұрын
📌Please visit our website for interview questions nicitacademy.com/ 📞For more details contact me on WhatsApp (+91 7010080468) or the below link wa.link/m4lat0 📞 Direct call & WhatsApp @ +91-99529 74013 🌕 wa.link/8szdvc
Please sir u explain tamil video also in etl testing process
@NICITACADEMY
2 жыл бұрын
Sure
@dineshbe7076
2 жыл бұрын
Waiting for tamil
Is this completely enough for etl testing any topics missing or do we need to learn more. .
@NICITACADEMY
2 жыл бұрын
Please SQL session and this ETL testing session, it is more than enough to crack interview.
hai sir good morning i have join etl testing.
@NICITACADEMY
Жыл бұрын
Ok good. 🌕For more details contact me on WhatsApp (+91 7010080468) or below link wa.link/m4lat0
It will be very helpful if can give online training for ETL testing
@NICITACADEMY
2 жыл бұрын
Yes, definitely
I am mba 2018 passout... right now As a fresher can take this course... is it workout for me or not ????
@NICITACADEMY
2 жыл бұрын
Yes, You can learn completely and try for opportunities.
Informatica ETL TOOL VS Talend Etl tool wich one is best tool please suggest me sir
@NICITACADEMY
Жыл бұрын
Informatica PowerCenter is widely used ETL tool.
@VaraPrasad-bl4ne
Жыл бұрын
Thanks for reply sir when will you start new batch sir
The whole video is for the ETL tester role or etl developer role.?
@NICITACADEMY
2 жыл бұрын
ETL Tester role
Sir ..is there any jobs right now for etl testing,.and can you please help us to make naukri profile skills...what about future Career in etl????
@NICITACADEMY
2 жыл бұрын
hi, Lot of job opportunities are there for ETL tester.
@j0hnvicks
2 жыл бұрын
@@NICITACADEMY sir ..i m not getting calls from naukri ...what should I do?? I hv completed course in January...
Hello sir, If the company is located in usa and we are building warehouse in india, how are they going to send data to us. Do we connect to their company's database from India? Or they copy their data and keep sending us.
Can you explain in Tamil just like sql
Hello Sir I want to learn the entire etl developer,ideally I'm from commerce background could you please help me
@NICITACADEMY
2 жыл бұрын
Hi, I have posted entire developer training video in our channel, please start learning it.
@syedanas5115
2 жыл бұрын
@@NICITACADEMY hello sir hood morning tq for reply I tried alot to check sir couldn't find it could you please help me the link over here the entire playlist
@NICITACADEMY
2 жыл бұрын
kzread.info/head/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd
Sir, please can you post this video in tamil
Hello sir, i joined as a etl tester with 3 plus experience of previous knowledge.. I dont have much idea on etl testing.. Is this enough to do my job on etl testing
@NICITACADEMY
2 жыл бұрын
Yes, Please watch my complete session on ETL Testing and Informatica.
Hi my qualification is ma b.ed and 10 years teaching experience I want to change my profile now. My friend suggested this course. Can one suggest me
@NICITACADEMY
2 жыл бұрын
All the best, Yes we have lot of opening for SQL+Informatica as ETL developer or ETL Tester. Our Channel videos are more than enough to prepare and crack interviews. Lot of students are already got offers. Please keep learning.
@Armaanshahkp
2 жыл бұрын
@@NICITACADEMY sir gd aftrn, can't we get certificate for learning this?
Hii sir which course is best for non it graduates with work from home job for future demand jobs
@NICITACADEMY
2 жыл бұрын
We can't say which is best, everything is best. but we need to have complete knowledge on this. ETL is best tool and have complete knowledge, we can say many tools and cloud systems as well.
@h.p.gamingtamil8599
2 жыл бұрын
@@NICITACADEMY thank you
Sir does Etl testing have a better future or not? can we have a better growth in this?
@NICITACADEMY
2 жыл бұрын
Yes, we have good future.
Hi my name is Pankaj. I have a query being at the age of 44 from arts background. after learning these will I get the job. Please reply me.
@NICITACADEMY
7 ай бұрын
After learning SQL and ETL testing, Yes definitely you can get into ETL related jobs. But you need to have proper IT experience certificate.
Sir .i need ETL testing live project if any course available
@NICITACADEMY
6 ай бұрын
Will upload soon
Is it enough for IBM data stage etl tool
@NICITACADEMY
2 жыл бұрын
Yes, it is enough, Just learn what is Informatica.. basic concepts. because Informatica is widely used ETL tool in many projects.