ETL Consultant(Shanghai,Security and others)
Teradata美商天睿
- 公司规模：500-1000人
- 公司性质：外资(欧美)
- 公司行业：计算机服务(系统、数据服务、维修) 互联网/电子商务
职位信息
- 发布日期：2015-03-22
- 工作地点：上海
- 招聘人数：若干
- 工作经验：3-4年
- 学历要求：本科
- 职位月薪：面议
- 职位类别：其他
职位描述
Role: ETL Consultant
Location: Shanghai
Industry : Security/Transportation/Travel/Manufactory/Government
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, Teradata Aster, and Hadoop systems. This individual must have the skills necessary to understand the overall Unified Data Architecture – including details within the data warehouse architecture and Hadoop architecture. The ETL Consultant designs and builds the ETL environment with the specific toolset required by the client. 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.
? Design, develop, and test processes for extracting data from legacy systems, production databases, Teradata, Teradata Aster, and Hadoop 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 Database, 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.
? Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives.
? Understanding of the Teradata Reference Information Architecture
任职要求
? 本科学历
? 2年以上工作经验，有证券/物流/航空/制造/政府类行业数据仓库开发和实施经验者优先
? 至少熟悉一种常用数据库ETL开发和调度工具(Informatic/DataStage/Kettle等)
? 至少熟悉一种主流关系型数据库(Oracle/DB2/MSSQL/MySQL等)，熟悉SQL，有Teradata经验者优先
? 熟悉Unix/Linux操作系统或者有Shell/Perl脚本开发经验者优先
? 良好的英语读写能力、学习能力、沟通能力和团队合作精神，能够适应较强工作压力
? 能够根据项目需要进行出差
更多职位详情，请点击进入：www.teradatacareers.com/apj
Email contact: lydie.lu@teradata.com, roey.du@teradata.com
应聘时请在Subject处注明职位名称+地点
Location: Shanghai
Industry : Security/Transportation/Travel/Manufactory/Government
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, Teradata Aster, and Hadoop systems. This individual must have the skills necessary to understand the overall Unified Data Architecture – including details within the data warehouse architecture and Hadoop architecture. The ETL Consultant designs and builds the ETL environment with the specific toolset required by the client. 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.
? Design, develop, and test processes for extracting data from legacy systems, production databases, Teradata, Teradata Aster, and Hadoop 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 Database, 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.
? Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives.
? Understanding of the Teradata Reference Information Architecture
任职要求
? 本科学历
? 2年以上工作经验，有证券/物流/航空/制造/政府类行业数据仓库开发和实施经验者优先
? 至少熟悉一种常用数据库ETL开发和调度工具(Informatic/DataStage/Kettle等)
? 至少熟悉一种主流关系型数据库(Oracle/DB2/MSSQL/MySQL等)，熟悉SQL，有Teradata经验者优先
? 熟悉Unix/Linux操作系统或者有Shell/Perl脚本开发经验者优先
? 良好的英语读写能力、学习能力、沟通能力和团队合作精神，能够适应较强工作压力
? 能够根据项目需要进行出差
更多职位详情，请点击进入：www.teradatacareers.com/apj
Email contact: lydie.lu@teradata.com, roey.du@teradata.com
应聘时请在Subject处注明职位名称+地点
公司介绍
Teradata Corporation (NYSE: TDC) is the global leader in data warehousing and analytic technologies that make smart companies smarter. Teradata provides the most knowledgeable and experienced consulting professionals, highest performing technology, industry-leading innovation, and a world-class network of customers and partners to make faster, smarter decisions that give our customers a decided competitive advantage.
Teradata offers a robust and innovative portfolio of horizontal and industry analytical applications such as data warehousing, customer management, finance and performance management, and demand and supply chain. We deliver integrated, enterprise-scale analytical solutions based on the most powerful, scalable and reliable technology platform in the industry. Every day we push analytical intelligence deeper into operational execution, enhancing process efficiency and transforming corporate culture. As a result, one of the world's largest and busiest data management environments are currently running and growing on Teradata.
We currently have over 5,500 associates in over 40 countries and a strong diversified client base of over 850 corporate customers worldwide. Our management team of passionate professionals averages over 20 years of experience. All Teradata associates are masters of solution development-deeply knowledgeable in the industries we serve and relentlessly committed to solving our customers' business and information challenges.
Our customers are the industry powerhouses that are outpacing their competitors. They join with our partners to form a worldwide collaborative network connecting every industry, market and geography with application-specific expertise and proven best practices. Teradata actively seeks partnerships with other leading innovators in software, technology and integration services to provide customers with end-to-end analytic solutions.
Teradata continues to retain Leadership Position in Data Warehouse Server Evaluation Model based on the Gartner Server Evaluation Model (SEM), as published on June 18, 2007.
公司网站： http://www.teradata.com
Teradata offers a robust and innovative portfolio of horizontal and industry analytical applications such as data warehousing, customer management, finance and performance management, and demand and supply chain. We deliver integrated, enterprise-scale analytical solutions based on the most powerful, scalable and reliable technology platform in the industry. Every day we push analytical intelligence deeper into operational execution, enhancing process efficiency and transforming corporate culture. As a result, one of the world's largest and busiest data management environments are currently running and growing on Teradata.
We currently have over 5,500 associates in over 40 countries and a strong diversified client base of over 850 corporate customers worldwide. Our management team of passionate professionals averages over 20 years of experience. All Teradata associates are masters of solution development-deeply knowledgeable in the industries we serve and relentlessly committed to solving our customers' business and information challenges.
Our customers are the industry powerhouses that are outpacing their competitors. They join with our partners to form a worldwide collaborative network connecting every industry, market and geography with application-specific expertise and proven best practices. Teradata actively seeks partnerships with other leading innovators in software, technology and integration services to provide customers with end-to-end analytic solutions.
Teradata continues to retain Leadership Position in Data Warehouse Server Evaluation Model based on the Gartner Server Evaluation Model (SEM), as published on June 18, 2007.
公司网站： http://www.teradata.com