System Engineer at TCS
Feb-2013 to May-2013
SMD is a project where all sell-in, sell-through and sell-out sales data of NOKIA is reported in one single application. Task is to create a star schema structure in target database to ensure good performance in reports.
Product history handling was maintained to capture the effective changes. Teradata macros, Informatica and UNIX scripts were used to the full extent.
Key Highlights
Analysis of Business and system requirements including impact analysis of existing systems and create detail requirements with the consultation of Business users and technical architects.
Extensively worked in data Extraction. Transformation and loading from source to target system using Informatica and Teradata.
Involved in writing scripts for loading data to target data Warehouse.
Invloved in macros and Used Utilities like BTEQ,MLOAD,FLOAD