• 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 t