Experience wif using teh following Teradata Utilities: Bteq, multiload, fastload, fastexport, Tpump, TPT, TD explain utility, visual explain, TSET, TD Index Wizard, TD Statistics Wizard, ViewPoint, and SQL Assistant. Strong Teradata SQL and ANSI SQL coding skills. Extracted source data from Mainframe Z/OS using JCL scripts and SQL into UNIX Environment and created formatted reports for Business Users using BTEQ scripts. Sourced data from disparate sources like Mainframe Z/OS, UNIX flat files, IBM DB2, Oracle, and SQL Server and loaded into Oracle, Teradata DW etc. Good noledge of Teradata RDBMS Architecture, Tools & Utilities. Skilled in Data Warehousing Data Modeling using Star Schema and Snowflake Schema. Proficient in converting logical data models to physical database designs in Data warehousing Environment and in - depth understanding of Database Hierarchy and Data Integrity concepts. Extensively worked on DBC and PDCR tables. Hands on experience Writing tools such as BOBJ, Cognos, Report Services, or Microstrategy. Supported many applications from design Phase to Implementation Phase. 
Closely worked on Teradata Data Labs (Sandbox environment) and did POC.Involved in SQL Tuning, Optimizer, Indexes and Table partitions.
Familiar in Creating Secondary indexes, and join indexes in Teradata. Extensively worked in Teradata RDBMS V2R5/V2R6/12/13.10. Extensively worked in various Teradata Client Utilites like Multiload, Fast load, Fast Export, Tpump, Teradata Parallel transpoter and TERADATA administrator activities. Experience in designing and maintaining slowly changing dimensions to keep track of historical data changes. 8+ years of experience in Analysis, Design, Teradata database administration, tuning and design methodologies and Development using Teradata tools and ETL tools Informatica, Datastage.
0 kommentar(er)
