First Few Weeks Experience as ETL Developer - sharing my story & Teradata SQL Cheat Sheet as Bonus

[@mrsudeepdas1]

Thank you bro really it is very useful for all great experience. Expecting more video like that.

[@ETLSQL]

Happy to help.

[@gy8844]

That's fentastic piece of work, sheet will be very helpfull for the beginners, looking forward to see more from you.

[@ETLSQL]

Thank you. Will upload soon.

[@EternalDiet]

Thank you very much for the Cheat sheet. I downloaded it and look forward to gaining much from it.

[@ETLSQL]

Happy to help :)

[@venkateshbatchu5925]

Hi, Thank you so much a lot. Actually my first task was also run the BTEQ scripts in dev. Expecting more videos from you.

[@ETLSQL]

Will upload soon

[@amarmanik2755]

Thank you soooooooooooo Much bro... its really helpful for me . lots of thanks

[@ETLSQL]

Happy to help. Will upload soon more videos in this series.

[@carlazacarias1810]

Thank you for sharing!

[@ETLSQL]

Happy to help.

[@ravaliannaldas2994]

Tqqq sir pls continue

[@ETLSQL]

Anything specific you wish me to cover ?

[@sureshjnikam8432]

Very useful ..!!! Thanks Man

[@ETLSQL]

You're welcome!

[@swapnilnavale9581]

sir share more on this i loved the way u explained

[@ETLSQL]

Thank you, I will

[@kamalikabhar4619]

Hi! I am currently working as L3 production support (for Abinitio), could you please guide on how to prepare for Ab initio developer profile ?

[@ETLSQL]

Hi Kamalika, I will give you only one tip - go and talk to your development team. I will share my personal example. When I joined a new team I was part of the development team using Teradata and informatica. There were a few people from the QA team who used to test my code. A few of them asked me to help them switch to dev team. They used to come and sit at my desk and see my work. Slowly shadowing me and 5-6 months later they joined my dev team from the QA team within the same project. So don't get overwhelmed by a lot of information available in the market. I don't think you to buy any course. You are in a good position. You have the project , you have the tools. Just share your aspiration with your manager and start shadowing development team. In 6 months you will transition to dev. Good luck.

[@konkaravali6933]

Yes ,please share your experience ...iam now joined fesher as an etl developer...your insights means a lot

[@ETLSQL]

Thanks. Will upload soon more videos.

[@Chanduantony]

Career gap candidates' can get as a fresher

[@renukap9315]

Hi Please share roles and responsibilities of terradata developer

[@ETLSQL]

Hi Renuka, Let me recommend you below post. etl-sql.com/teradata-learning-path/ This should answer your questions. If still you have any query let me know. Happy to help.

[@kafiravadh3934]

I'm about to start my career as ETL developer as fresher. Can I connect with you where I can ask my query. In linkedIlin I am unable to message you.

[@ETLSQL]

First of all, congratulations and best wishes. Send your query to [e-mail]

[@umapathins6701]

Can you guide me on ETL development since I have a BFSI background and need to switch over..give me basic tips

[@ETLSQL]

Happy to help

[@umapathins6701]

Let us know sir your convenient time to discuss further

[@umapathins6701]

How to contact you

[@ETLSQL]

Please send email at [e-mail]

[@VaraPrasad-bl4ne]

Informatica ETL TOOL VS Talend Etl tool wich one is the best tool sir

[@ETLSQL]

Dear I will not recommend comparing the tools to find which is the best. Generally I don't answer it. I can only recommend that you learn what is used in your project. Both are very popular. Understand the basic concepts behind the UI and not just limit knowledge to drag and drop stages. This way you can easily switch between tools if required. Also say if a company has purchased an informatica license then they will use informatica. If you are a developer in that project then you will work on informatica only. If you know the ETL concepts then tomorrow if the company switches to Talend you can easily apply your knowledge in the new environment. This is from my personal experience when I switched from informatica to datastage for a new project. So learn the tool which is used in the project. Understand the core and basic concepts. Apply that knowledge across different tools and platforms to widen your skills. Hope this helps. Best, Nitin

[@VaraPrasad-bl4ne]

Thank you sir

[@lakshmiravuri3193]

Any support available on these two teradata , informatica

[@ETLSQL]

I am not taking any classes.

[@sofiagrace7028]

Thank you for shearing your experience. I'm new in the Taradata . The cheat cheet link opens a new window and when you click on the free PDF download It shows 404 error found. Can you kindly share the PDF to my email or rectify the issue ?? Pls

[@ETLSQL]

Thank you for your comment. I will fix it and you should be able to download it by tomorrow positively.

[@nadeemmohammad5479]

Hi I'm interested in ETL developer can you please tell me what are the skills required for ETL developer

[@ETLSQL]

Hi Nadeem I will say start with Data warehouse concepts , ETL concepts and relate it with the SQL queries. This requires you to convert Concepts into actual SQLs to implement it. Few Examples: You read about Slowly Changing Dimensions (SCD) - now write SQL queries to implement SCD-1,2,3. You read about Staging area now create data load scripts into staging tables. Decide if it will be Truncate/Load or Incremental load. Create Dimension tables and after that create fact table. Write SQL query to join DIM tables and use group by to calculate some measures in FACT table. Once you have theoretical knowledge , go ahead with creating ETL pipelines using your preferred ETL tools. You may use only SQL with shell scripting or python to achieve same as well. Hope this helps to start with. Best, Nitin

[@ViralCrank]

Please share more at advance level 👍

[@ETLSQL]

Anything specific you wish me to cover ?

[@vivekshinde8746]

Nice video. Sir could you share how did you studied teradata before joining the job as an etl devoloper. It would be really helpful.

[@ETLSQL]

Hi Vivek. Fortunately I joined as a fresher so nothing much was expected and I was given bandwidth to learn in the project.

[@dushyantbansod526]

What's the difference between ETL tester and ETL developer?

[@ETLSQL]

Hi Dushyant In typical data warehouse team, ETL developers create pipelines to move and transform data from Source to Staging to EDW layer. Developers refer to Source-Target mapping document to write SQL code to implement business requirements. ETL tester on the other side create test cases - both technical and functional. Once the code is deployed in QA environment, testers run the code on sample data to validate if all technical & functional requirements are met by the code or not.

[@PriyaSingh-zt7xy]

Please let us know the responsibilities of ETL and teradata developer for 1-3 years of experience

[@ETLSQL]

Sure. I will plan a video on it. In the meantime, if I may, I will recommend you checking this playlist. kzbin.info/aero/PLZpGsO7CdJ8z3SdDdmfalOlHVcbB_xOvZ

[@manoj00231]

Good explanation

[@ETLSQL]

Thanks and welcome

[@dramatictoons9303]

Could you help me with writing unix scripts for workflows

[@ETLSQL]

I am sure you would have done this all by yourself by now.

[@ajaynarra3608]

I am relating with you, i had similar kind of experience in first month.

[@ETLSQL]

Good to hear that. So I guess it is much more common than I thought.

[@harishmahale7180]

Very good video, while watching your video, Feel like I am working on real time projects

[@ETLSQL]

Glad to hear that. Yes I intentionally share my real life experience in the videos so that beginners can find it helpful and experienced professional can relate to it as well.

[@shoaibullahferoz1560]

Hi I’m looking for a mentor.

[@ETLSQL]

Hi Shoaib I may suggest that first you fix your 6-12 months goal. Then identify someone on linkedin who has done exactly what you want to achieve. Then reach out to them for mentorship. Few of them may be willing to assist you.

[@janardhanacharypadakandla1759]

Iam interested in Learn ETL

[@ETLSQL]

Good for you. Let me know if I can help in any manner.

[@srishdwivedi6112]

Share your informatica experience as well

[@ETLSQL]

Keeping it in my backlog.

[@amazingcreator3744]

Please share video on career as ETL developer, salary, future scope, abroad opportunities, etc... We need it very eagerly....😣 Also share video on how you switched to big data...👍 But before that share video on career as ETL developer...🤗 Waiting for your video...

[@ETLSQL]

Will upload soon