ETL Testing 5 hours complete training | ETL Testing interview preparation | What is ETL testing
ฝัง
- เผยแพร่เมื่อ 28 ธ.ค. 2021
- #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
![อยู่ได้แล้ว - LIPTA feat. Mirrr [OFFICIAL MV]](http://i.ytimg.com/vi/-9-hpntNym4/mqdefault.jpg)
*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
Complete agree its a wonder session which cover all the area of ETL testing. Thank you so much!!
You're very welcome!
*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
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
th-cam.com/video/C1zGVRFM3-A/w-d-xo.html
📌*Informatica Full Course:*
th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
📌*SQL Full Course:*
th-cam.com/video/iuvzjf7nU1I/w-d-xo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
This is the best ETL testing video I have ever seen...covers all concepts from Start to the End... great session 🙌👏
Wow, thanks! Keep watching my channel.
I can easily understand SQL when you explain in tamil
Simply wow, explained every well, even nill knowledge person also will understand in first attempt
Thank You very much. Keep watching my channel.
Love the way you are explaining, thanks a lot
Thanks for liking. keep watching my channel.
That's the video I was looking for. Thanks!
Thanks, Keep watching my channel.
Your session is very good and informative 🙏🏻
So nice of you. Thank you! Keep watching my channel.
Thank you very much 🥰 for uploading video full course
Most welcome
Sir super teaching... God bless you...
Thank You, Keep watching my channel.
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.
Thanks and welcome
Iam a ETL developer . Video is so usefull.. expecting more videos for etl and future development in ETL
Thanks, Sure
Hello Hai bro I'm learning Sql course present how it's jobs and working bro please reply me
Hai Bro, i have some doubts about ETL , can i make a call to you bro
All rounder performance 👍👍👍👍
Nice video 🎉🎉🎉
Many many thanks. Keep watching.
GREAT!!!😀
Excellent!! This is the best video I ever seen in TH-cam😍
Thank you so much 😀
Thank you so much. Wonderful subject. The ways u have explained terrific . Could you pls share some real time live project. For validation
Thanks for your wonderful feedback. Keep watching my channel.
Very well and beautifully explained Sir.. 🙏🙏🙏🙏🙏 Thank you..
Thanks 🙏. Keep watching my channel
Most expected video...keep rocking
Thank you so much 😀
You are the best Sir!!!
Thank You. Keep watching my channel.
courses.nicitacademy.com/courses
sir you're doing great job
Thanks and welcome
Great sir. Its very useful
So nice of you. Keep watching my channel and support.
Thank you For this Video.
You're welcome
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.
Sure, I will share it. I have already discussed some of the Realtime use case. please watch it second half part..
tq sir these classes use full in medille class pepules
You're most welcome
Very helpful..Thankyou👍
Welcome 😊 Thank You!. Keep watching my channel.
Sir is enough for informatics.... Thanks for this video
Most welcome, yeah its enough
its verry useful sir...keep rocking...
Thank you, Keep watching.
Superb video sir..
Thanks a ton. Keep watching my channel. Add your queries, I will create new video on the required topics.
best video
Thanku sir
Sir, please make a vedio for ab initio tool either in dev or testing, it will be more helpful
Keep rocking....sir
Thank you.
I love the way u teach👌👌
Thank You, keep watching my channel. Post your queries in comments.
Super explanation
Thank you 🙂
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.
Thanks so much
You're welcome!
Thank you sir !!
Most welcome!
Hello sir, your videos are useful for etl Testing aspirants, Could please share the file and how to install hp QC in pc
Thanks a lot
Most welcome
Thanks for the videos that you have shared with us
Savior
Thanks Brother. Keep watching my channel
Wow, it's great explanation. Please upload teradata sql and ETL real time project also...
I have already posted Teradata videos in NIC IT Academy 2.0
Please check th-cam.com/video/oj-6c4ybuSU/w-d-xo.html
Send some interview questions or how to crcak interview tricks
great sir
Thanks
Great explanation sir
Please make one video on how to create and why do create or who create traceability matrix documents as etl tester
Sure. I ll do.
Keep watching my channel
@@NICITACADEMY sure
Great 👍🏻
Thanks ✌️
Sir I need urgent video on hpalm or notes prepared by u
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
Sir please provide some pdf s related to this...
i wish this video has english sub, that's so great 🥰
Working on it!
@@NICITACADEMY .
Nesecito subtítulos en español o en ingles!! Gracias!!
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?
I will add more videos on ETL testing. Keep watching my channel.
With English subtitles for talend ETL tool pls
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
it is really helpful except the ma'am asking too many question as dev side.
Thanks
Please do more videos on ETL testing sir
Sure, I ll do.
Overview of testing - Diagram 21:32
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.
Could you please Upload Tamil version of ETL testing🙏
📌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 send me interview question a nd answers for etl testing in pdf..
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
Sir pls Talend ETL tool using Oracle SQL tutorial vedio post pannugka sir
With English subtitle
hai sir good morning i have join etl testing.
Ok good. 🌕For more details contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
how much ETL tester has a scope in career ? and what should be the next step after ETL Tester?
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
Please sir u explain tamil video also in etl testing process
Sure
Waiting for tamil
Hi Sir, Thanks for your tutorial.
Can you please post this tutorial in Tamil.
Thanks, Will upload soon. Keep watching my channel.
Hi Chandra sir, it seems You are like Etl dictionary. Do you put any videos related tableau report testing
Thank you for your wonderful feedback.
I will add Tableau video as well. Keep watching my channel.
Hi dude
Using Informatica, flat file data can be loaded into staging, and developers can add any logic.
Or, the mapping will be tested.
It will be very helpful if can give online training for ETL testing
Yes, definitely
All good..But the time, live lesson starts, there is one girl keeps asking repeated questions with lots of attitude..Which is irritating..
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?
I have explained the same scenario in this video itself. Please watch without skipping.
@@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.
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.
Got it sir thank you Appreciate your efforts in providing the knowledge on informatica sessions
@@NICITACADEMY Sir I could not find video on joiner transformation? Can you please upload the same?
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??
Hi can you please share all the materials that you used during 5 hrs session? including TCs, STTM etc?? I would be greatful
Please check here
courses.nicitacademy.com/
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
Please watch my ETL testing full session, ETL developer full session. We have lot of openings
Sir, Are you providing online training.
Hi Sir, This tutorial was very useful. One small request from can you also please post the same ETL tutorial in tamil.
It is already available
th-cam.com/video/8p35ZXnhvxk/w-d-xo.html
@@NICITACADEMY Thanks sir
Hello sir, if source is flat file and target is database then how we can validate data from staging to data warehouse?
We have use some tool to test it like Querysurge.
@@NICITACADEMY can you make video on this topic?
Sir, please can you post this video in tamil
Can you explain in Tamil just like sql
Hi Sir, could you please share me the link of sql which you were mentioning, i could only see oracle sql in your playlist
th-cam.com/video/yukL9vRalVo/w-d-xo.html
Sir, is this enough for 3 plus experience knowledge in etl testing?
Yes, of course. It is enough to work.
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
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.
@@NICITACADEMY sir in etl testing work pressure is more or normal? Does we get wrok from home work in etl testing or not?
It is based on the project where we are working.
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.
please watch my SQL Session.
Hai , i have some doubts about ETL, i think u already worked on it so can u help me
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????
hi, Lot of job opportunities are there for ETL tester.
@@NICITACADEMY sir ..i m not getting calls from naukri ...what should I do?? I hv completed course in January...
Could you please make ETl testing in Tamil
Sure I will do
Is this completely enough for etl testing any topics missing or do we need to learn more. .
Please SQL session and this ETL testing session, it is more than enough to crack interview.
Can you send video on jira and hpalm
Yes, I will upload soon.
@@NICITACADEMY thank you very much sir... really I learnt too much from ur video
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
Check my TH-cam session on debugger and dependency check.
Sir any video on only hpalm
I will upload soon. Keep watching my channel.
source have 10k records without any transformation applied data moved to target directly
what are the validation tester perform ??
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...
4th one is Minus query??
A-B and B -A ?
Hello Sir I want to learn the entire etl developer,ideally I'm from commerce background could you please help me
Hi, I have posted entire developer training video in our channel, please start learning it.
@@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
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
Informatica ETL TOOL VS Talend Etl tool wich one is best tool please suggest me sir
Informatica PowerCenter is widely used ETL tool.
Thanks for reply sir when will you start new batch sir
Hi bro,
This etl testing is only for testing domain right?
The whole video is for the ETL tester role or etl developer role.?
ETL Tester role
Talend ETL developer video can u do like this ?
Yeah, I will do, Keep watching my channel.
@@NICITACADEMY ETL developer role video available ?
I am mba 2018 passout... right now As a fresher can take this course... is it workout for me or not ????
Yes, You can learn completely and try for opportunities.
Sir does Etl testing have a better future or not? can we have a better growth in this?
Yes, we have good future.
Hii sir which course is best for non it graduates with work from home job for future demand jobs
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.
@@NICITACADEMY thank you
Sir .i need ETL testing live project if any course available
Will upload soon
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
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.
@@NICITACADEMY sir gd aftrn, can't we get certificate for learning this?