Profile
A professional with 2.0 years of experience in Software Development with deep insight into finance , commercial broadcast television industry and exposure to Data warehousing domain.
Extensively worked on data extraction, Transformation and loading data from various sources & Targets like Teradata, Oracle, DB2,Sybase and Flat files.
Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on ETL requirements.
Designing the mappings based on technical design specification documents with Quality and always adhered to the established standard practices.
Had good experience in ETL design, development and maintenance using Oracle SQL, Informatica Power Center 8.x, 9.x.
Extensively used Transformations like Router, Aggregator, Joiner, Expression and Lookup, Update strategy and Sequence generator and Filter.
Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files
Parametrized the mappings and increased the re-usability.
Worked on performance tunings of mappings in Informatica.
Excellent problem solving skills, high analytical skills, good communication skills.
Had basic knowledge on the Teradata utilities like fastload ,multiload ,tpump,fastexport.