天津招聘

职位描述：
Teradata Professional Services Role Description
ETL Consultant

The ETL Consultant specializes in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to appropriate structures within the Teradata RDBMS, Teradata Aster, Hadoop, Open Source Systems, and various other systems. Conversely, the ETL Consultant will also acquire data from Teradata sources such as the Teradata RDBMS, Teradata Aster, Hadoop, and other open source platforms, to apply to appropriate structures within any other customer system. This individual must have the skills necessary to understand the overall Unified Data Architecture – including details internal to the Teradata data warehouse architecture, Teradata Aster architecture, and Hadoop architecture. The ETL Consultant designs and builds the ETL environment with the specific toolset required by the client. These tools may include direct interfaces supplied with Teradata, Teradata Aster, Hadoop, as well as third party data integration tools. The ETL Consultant will be key to implementing Teradata projects in both the public and private cloud as well as on premises, and needs to be familiar with best practices for working within these environments and within mixed environments. The ETL Consultant may also provide input to the database designer to optimize the data loading of the physical database. The ETL Consultant may be the Project Tech Lead on a project.

Key Areas of Responsibility

? Capture ETL requirements – note this includes all data integration techniques such as ELT, etc.
? Design, develop, and test processes for extracting data from legacy systems, production databases, Teradata, Teradata Aster, Hadoop, and Open Source platforms.
? Design, develop, and test processes for validating and conditioning data prior to loading it into a Teradata Warehouse, Teradata Aster, or Hadoop platform.
? Design, develop, and test processes for loading initial and cyclical data into a Teradata Warehouse, Teradata Aster, or Hadoop platform.
? Design the processes to meet service level agreements for data timeliness and frequency.
? Determine which data elements are historic and the retention period for historic data.
? Determine data growth trends and peak business periods.

Skills

? In depth knowledge of the Teradata Database, Teradata Aster, and / or Hadoop platform.
? In depth knowledge of ETL tools and the SQL language.
? Ability to understand and properly use data integration techniques such as ETL and ELT.
? Profiling, validating, conditioning, transforming, and cleansing of data.
? Implement projects on premises, in the cloud, and between mixed environments.
? Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives.
? Understanding of the Teradata Reference Information Architecture

Technical Skill Category Skill Mapping
Service Offers Primary Skill
Aster Data Primary Skill
Cloud Computing Primary Skill
Databases Primary Skill
Hadoop Primary Skill
Industry Knowledge Knowledge
Project Mgmt: Data Warehousing Skills Primary Skill
Project Tech Lead Primary Skill
Teradata Active Data Warehousing Knowledge Primary Skill
Teradata Applications Primary Skill
Teradata Architecture Primary Skill
Tools – Development Primary Skill
Tools – Enterprise Application Integration Primary Skill
Tools – ERP Software Primary Skill
Tools – ETL Primary Skill
Tools – Job Control and Scheduling Primary Skill
Tools – Modeling Primary Skill
Tools – Monitoring and Control Primary Skill
Tools – Operating Systems Primary Skill
Tools – Security Knowledge
Tools – Teradata Primary Skill 举报 分享

  Teradata天睿公司（Teradata Corporation，美国纽约证券交易所交易代 码：TDC）是全球领先的数据分析解决方案厂商，专注于整合数据仓库、大数据分析和业务应用，是全球公认的领导者，Teradata连续16年被Gartner评为数据仓库DBMS领导者。详细介绍参考公司网址：www.teradata.com
目前，80%的全球***商业和储蓄银行、90%全球十大电信运营商、80%的全球***零售商、100%的全球***航空公司、83%的世界***运输/物流公司，都在使用Teradata数据平台系统。