ETL Testing Future Scope & Skills Required for ETL Testers to Crack Interview Answers by Experts

ETL Testing Future Scope & Skills Required for ETL Testers to Crack Interview Answers by Experts
In my view the job market for an ETL tester is quite smaller compared to an ETL developer. Many projects do not have specific role of ETL tester. These projects usually have a end to end ( ex: reports, portal, DB and ETL) tester rather than specific to ETL or the developers themselves review and test each other's code. So the number of openings specifically for ETL testing will be less and it could reduce further with more test automation. I also think that its not good to limit a profile to only ETL testing.
Additional info,
Manual ETL testing is usually carried out by offshore based IT companies that take advantage of cheap labour.
Writing Automation scripts and full Automation of ETL testing has higher value and I think this will continue to increase.
ETL test Automation is very important for regression testing.
SKILSS TO PERFORM ETL TESTING JOBS:
I've been working as a ETL tester from Past 6 years, So I've listed all these below points are based on my experience.
1. First and foremost an ETL tester should be upgraded to master in writing complex SQL queries for any DataBase.
2. Incorporate as much as automation for doing ETL validations(Python is my best suggestion).These days it became mandatory for an ETL tester that must of Python knowledge, so this is one of the major skill an ETL tester should upgrade.
3. By having good knowledge on Python, you can build your own python framework that make your job easier.
4. Having good knowledge on UNIX. Sometimes an ETL tester need to perform validations on flat files, in such cases UNIX scripting comes as handy option. By having unix knowledge not only required to work on LINUX OS, it can be worked on Windows in Gitbash tool.
5. Domain Knowledge: Most of the projects what I have worked on is Insurance Domain, so it would be good to have skills on Domain Knowledge.
skills to crack etl testing interview

Пікірлер: 26

  • @manjunathnaik9401
    @manjunathnaik9401 Жыл бұрын

    Thanks sir❤

  • @sqlmaster9816

    @sqlmaster9816

    Жыл бұрын

    Welcome manju...

  • @ashisrout383
    @ashisrout383 Жыл бұрын

    Good info sir

  • @sqlmaster9816

    @sqlmaster9816

    Жыл бұрын

    Thank You...

  • @Manifestion_kannada
    @Manifestion_kannada Жыл бұрын

    Do show insurance project how it works in company

  • @sqlmaster9816

    @sqlmaster9816

    Жыл бұрын

    I already made video on insurance project go to my channel and watch video

  • @ashokchandola
    @ashokchandola10 ай бұрын

    What would be advise to manual tester?? ( having 4 yr exp)

  • @sqlmaster9816

    @sqlmaster9816

    10 ай бұрын

    its good to go for manual testing and for automation testing

  • @y.c.breddy3153
    @y.c.breddy31538 ай бұрын

    SSIS tool experience mandatory for manual ETL tester Sir

  • @sqlmaster9816

    @sqlmaster9816

    8 ай бұрын

    Yes it's compulsory to know

  • @sqlmaster9816

    @sqlmaster9816

    8 ай бұрын

    They check overall knowledge so

  • @kiranpatil4968
    @kiranpatil4968 Жыл бұрын

    Plese you know etl automation make video on etl automation video

  • @sqlmaster9816

    @sqlmaster9816

    Жыл бұрын

    Yes definitely i make videos... on etl automation...

  • @anupshastry5969
    @anupshastry59695 ай бұрын

    Sir i am currently working has automation tester can i make transition to ETL testing . If yes is it good choice or learn devops and dig more into automation

  • @sqlmaster9816

    @sqlmaster9816

    5 ай бұрын

    Learn DevOps it's best and Mithun technology is best to learn DevOps

  • @anupshastry5969

    @anupshastry5969

    5 ай бұрын

    Sir i am confused between devops and data engineering field I am interested in both the field but some are telling data engineering is scope and some are telling since you are automatiom tester move to devops then you can switch to data engineering if required . Can you please suggest me on that

  • @sqlmaster9816

    @sqlmaster9816

    5 ай бұрын

    see move devops ok its having good carrer very long time you can make your career and its very helpful in automation also my suggetion is move to devops if required contact Bhaskar Mithun Technologies 9980923216 just enquire later you think on that .@@anupshastry5969

  • @sqlmaster9816

    @sqlmaster9816

    5 ай бұрын

    Me also doing devops course now in Mithun Technologies

  • @anupshastry5969

    @anupshastry5969

    5 ай бұрын

    Ok sir thank you so much for you suggestions

  • @chetan5697
    @chetan569711 ай бұрын

    Sir i am working as ETL tester for last 3 years, now i am planning to learn IICS. So what's your suggestion Sir?

  • @sqlmaster9816

    @sqlmaster9816

    11 ай бұрын

    Yes it's great thing learn it it has more opportunity with high pay salary

  • @chetan5697

    @chetan5697

    11 ай бұрын

    @@sqlmaster9816 Thank you Sir for your suggestion

  • @mcsdigital5223

    @mcsdigital5223

    10 ай бұрын

    Hello bro, may i ask how much salary do u get as an ETL tester??I m asking bcoz i m considering to do this course.

  • @sqlmaster9816

    @sqlmaster9816

    10 ай бұрын

    @@mcsdigital5223 now its very hard to get etl testing job for fake candidates but if you try hard you get of 60 pm

  • @mcsdigital5223

    @mcsdigital5223

    10 ай бұрын

    @@sqlmaster9816 thanks a lot sir, appreciating ur work. Bdw what does fake candidates imply?

Келесі