? 2+ years? experience of developing using Teradata v14.00 and Informatica v9.5.
? Expert in writing scripts using stored procedures / Macros in Teradata
? Expert in writing and Performance tuning of SQL queries in Teradata
? Use ,write and implement of Teradata utilities fastload, multiload, tpump and TPT to load data.
? Excellent analysis and problem solving skills
? Experience in using Informatica Powercenter to build ETL mappings, sessions and workflows.
? Experience with converting legacy systems to Teradata is highly desirable.
? Ability to be highly productive and deliver high quality work
? Experience with Unix/Linux, ERWIN and informatica pushdown optimization technologies a plus.
? Knowledge of reporting tool Micro strategy is a plus