Skip to main content

Informatica - Extract , Transform and Load??

Informatica tool is one of the popular tool for data warehousing. Most companies require this tool and there will be people working to retrieve the data. when you have tons and tons of data, your job would be to transform that data and provide the analytics. Usually the fortune 500 companies would be working on this tool.



how can you become an Informatica Developer?
the team at Edureka have a course on Informatica Training and certification. This course would help you to complete certification and you can get promoted as Informatica Developer/Informatica Admin. Mostly the admin jobs are few in the market. The salary is in the range of 80k usd to 160k usd and there is an easy way to search for jobs with google - "Informatica " jobs in "Location". Just see the image below



You will get the results from Dice, Linkedin and other job sites easily through this simple search. There is no time wasted with checking different portals like dice, monster, timesjobs.

Why, What and How ? Informatica

 I was a fan of this software program and during 2010, I started learning about Data warehousing. There were very less tools in the market about data migration. when you learn the ETL tools , you will know about how to use the database, how to access the database. You will need to learn about any database like Oracle 11g or MongoDB or Mysql. You will about connecting to the FTP server and retrieving data from the company server.

The domain sector can be either retail, banking or pharma or it can be anything. There will be huge chunks of data like sales or attendance or something like that. Your job would be

1. Extract the data from source database

2. Load the data into another software say like reporting tool

3. Sometimes you will have to process the data ( either add or remove columns or rows)

Imagine the excel sheet with 1000 rows and 1000 columns, you will have to alter them and it's possible manually. Hence we use the software tool - Informatica Powercenter which is a data migration tool.

I have put things in simple terms to understand better, please click on the ad below to get more details


Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Automate things and success follows

Recently I read the 5am club book which is about how to wake up early, how to be more productive. But if you think in deeper level, you must have a routine and never feel bored about it. Keep doing the things that you love, once when you find your IKIGAI then your life becomes awesome. Everything is old school and there is only a slow learning curve to master anything. It doesn’t happen overnight and you need to push with your motivation. Because it’s the energy to solve the problem before your eyes. Have you thought about being rich or being the best person in your skill??   Then follow one thing – Routine Focus on the hours and you can complete your goal. If you think the task is too much for you, then break them into tiny bits so that you complete it easily. Positivity is what you need in every stage of life and always believe that miracles would happen soon. What is a routine now? There is a wonderful book on routine from Hal Elrod called the Morning Miracle,...
Post a Comment
Read more

Instagram AI and the explore page

Have you ever wondered that how the Instagram works?? Artificial intelligence and Machine learning are the two integral parts of this platform. Ivan Medvedev,Haotian Wu and Taylor Gordon - the three people behind this wonderful design I guess, that's what I read from the facebook AI blog ( google it, you would find this page) There are 2 things of this whole process 1. Give what the end user wants 2. Give the best in the niche I am the end user and I am ashok. I want to browse pics of nature. I love nature and I keep double tapping the pictures with trees, clouds, Ice berg, mountains and rivers. So if I check my explore page, I would get to see the same interest. Instagram Algorithm is designed in a way that I am hooked to the mobile and I keep addicted to it. I am glued to the explore page BTW How does it give me the best results ? there are 3 ways to filter the results as mentioned in the original blog. 1. Choose the best from 150 similar interests - give the be...
Post a Comment
Read more

Gatsby Js - the next biggest thing

I absolutely love the journey of Web development. I haven't updated my skills or my resume that's a different thing. What amazes me is that too much things to learn and the way we can make the online selling easier or create the websites easily or make the web developments easy for all. Here is the new  Gatsby Javascript. The Gatsby Masterclass -  start to learn using the GraphQL.  Learn about building an Online store and blog through this framework. This is an excellent course from Reed Barger and you can start building new apps from the basics learnt in this course. Gatsby. js for beginners - learn things from the scratch. This is going to the easiest way to start learning a course. Always start with learning the fundamental concepts of programming. I struggled with learning new concepts with books that was too complex. What's the new thing in Gatsby?? The static website can be implemented easily on dozens of services, which makes the work so easy. Ga...
Post a Comment
Read more