Sr Terredata Developer / Herndon / VA (082212MARSAL-IO32-E)

 

 

Title: Sr Terredata Developer
Location: Herndon, VA
Duration: Long term

Financial client is seeking a strong Teradata developer to work with Database warehousing team. Resource should be analytical,
comfortable with dealing large amounts and data, coming up with solutions for design of data security, data
access/authorization, etc. Must have working experience with the entire technology stack of Teradata appliance
(Teradata 13, Viewpoint, SWS, TVI, BAR, SLES), implemented PDCR (PMCP) and can support it. Have extensive
experience with TTU 13.10 client tools including Teradata Manager, SQL Assistant (Queryman), Teradata Administrator
(WinDDI). Extensive experience monitoring and maintaining a production Teradata environment. Familiar with logging
onto the Teradata nodes, running tools from the Supervisor screen such as PackDisk, CheckTable, ScanDisk, and other
diagnostic tools such as VProcManager. Expertise in Teradata load utilities like MLoad and OLELoad, Teradata Parallel
Transport utility (TPT) coding. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query
performance, expert level knowledge of complex SQL using Teradata functions, UDFs, macros and stored procedures,
expertise in Data Warehouse Metadata concepts, tools and repositories. Experience using Teradata TMON to monitor
and manage Teradata RDBMS resource utilization (TASM), and have created alert policies for monitoring database
space, average disk use, TASM priority scheduler. Extensive TPUMP V13: Teradata: TTU V. 13.10 Release Teradata
Parallel Transporter for near real time and eliminates batch window. Experience in analysis, design and development of
Data marts. Candidate should have working experience on all phases of Data Warehouse project life cycle and should
be well versed on Dimensional Modeling.
Big Plus:
Experience in Data Profiling, Data Migration, Data Integration, Data Modeling Using Various ETL Tools.
Experience with SAP Business Objects Data Services ( Data Integrator 3.1),
Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology, Bill Inmon Snow Flake
schema methodology.