• Over 12 years of comprehensive experience in Architecting, Analysis and Design, configuration, Software Development and Implementation of Packaged Data Warehousing solutions using Informatica, Oracle and Teradata, technical leadership & project leadership. • Hands on all phases of the project from Architecting to maintenance including Multitask in multiple projects. • Excellent exposure and experience working on ETL Tool - Informatica V 7.3/ 8.1/ 8.6 and 9.0. • Experience working on Informatica transformations like normalizer, Lookup, Source Qualifier, Expression, Aggregator, Sorter, Rank and Joiner. • Involved in generating Mload and Tpump scripts to load the data into Teradata tables. And have very good knowledge and hands on Teradata load utilities (Fast Load, Multiload, BTEQ, etc.) • Hands on experience on Teradata SQL Assistant, the AQT and TOAD • Excellent team player and proven track record working in various team sizes performing cross-functional roles. • Experience in Design, Development, and Enhancement and Maintaining Informatica applications with oracle and Teradata as backend databases. • Good Knowledge in UNIX/ Solaris/ Linux/ Windows • Experience in designed and deployment of UNIX Shell Scripts in K shell. • Expert knowledge in using data modeling tools like ER-WIN and ER diagrams with Model mart exposure. Normalization Techniques for designing database with Relational technology on N-Tier Architecture. • Good Knowledge of various Design patterns used in the current day Data ware housing and niche to learn newer techniques that will improve performance. • Excellent Problem Solving, Analytical skills combined with very good communication and Interpersonal skills and a proven Team player with a good track record • Extensive expertise in requirements captures analysis, documentation, and translation in technical specifications.