In Data Warehousing World, Extract, Transform and Load (ETL) refers to a process in database usage and especially in data warehousing that:
Usually all the three phases execute in parallel since the data extraction takes time, so while the data is being pulled another transformation process executes, processing the already received data and prepares the data for loading and as soon as there is some data ready to be loaded into the target, the data loading kicks off without waiting for the completion of the previous phases.
ETL systems commonly integrate data from multiple applications(systems), typically developed and supported by different vendors or hosted on separate computer hardware. The disparate systems containing the original data are frequently managed and operated by different employees. For example a cost accounting system may combine data from payroll, sales and purchasing.
Click here for more information on ETL Developer Salary Range!
This tailor-made class content is designed to provide comprehensive overview of ETL tools and technologies in practice and learning industry leading ETL tool – Informatica. By attending the course, you will:
Applicable Job Roles: ETL Developer, Informatica Developer, Data Warehouse Developer, Data Architect
Objectives for this class are:
Prerequisite: Prior knowledge of Database Development and SQL is required. You shall attend our SQL/Database class prior to taking this training if you are not familiar with SQL/Database.
Learning Approach: You will attend the training in-person (and NOT ONLINE) at our training center.
Class Duration: 3.5 Weekends (Saturday & Sunday 8:30 AM – 1:30 PM) training + Project + Practice Lab Hours every week on Thursdays (6:30 PM to 8:30 PM) – Approx. 40+ Hours of training.
Early Bird Fees: $650 online (or $625 via check) till October 25, Fees after October 25 is $695
Instructor Name: Sachin Amin (Informatica Certified Consultant)
Mr. Amin has over 15 years of experience in the field of Datawarehousing with expertise in technologies like Informatica, Data stage, Business Objects, Teradata etc. He is Informatica certified Consultant and worked as Sr. Developer /Architect/Consultant at various clients with in US. He has Master’s Degree in Internet engineering from University of East London, UK. Sachin has been providing training since 2007 and have trained 500+ students in BI space.