Etl/data Warehouse Developer
[company name]. (CFL), LA, USA is in the business of manufacturing goods and beverages with factories all over the globe. This has many products with different flavors and the product sale is through many channels like CSD, institutional and Dealership including North America, Africa, Asia pacific and Europe. Informatica is used as ETL Tool for loading a Data from heterogeneous source system from different location into Target Table.
- Worked on the project that involved development and implementation of a data warehouse for CFL
- Responsible for extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse
- Designed, developed, and tested the mappings, using Informatica 8.1.0
- Interacted with management to gather sources and their requirements
- Involved in the some part of performance tuning.
- Developed simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.