Informatica Power Center is an ETL tool with visual interface to drag and drop different objects(transformations) and design process flow diagrams(mappings) for data extraction transformation and load. Mapping are scheduled to run as and when required. Fetching of data from source, transforming and loading to external systems(Systems/Databases). Power center can communicate with all major data sources like mainframe, Big Data, RDBMS, Flat Files, XML, SAP, Salesforce etc can move/transform data between them. Informatica can effectively integrate heterogeneous data sources & converting raw data into useful information.
- Use Informatica Designer to build mappings that move data from sources to targets.
- Design mappings and workflows based on business needs.
- Perform basic troubleshooting mappings and transformations.
- Use authorized Informatica Support options to resolve questions and problems about Informatica
- Change Management
- Individuals interested in pursuing career in data integration.
Basic knowledge of data ware housing and data base. Knowledge of PL/SQL is advantageous.