Data Architect

Requisition Number: 201295

External Description:

Role: Data Architect

Location : Shanghai

Industry : Retail/Airline/Express/Security

Data Developers development, implement, and test data ingestion and/or ETL/ELT processes to meet functional and non-functional requirements and objectives. Data Developers are broadly aligned with the Data Acquisition & Integration sub-practice.

 Many Data Developers start their careers in more junior positions, but as part of their professional development, Data Developers will be encouraged to develop into “T-shaped” professionals, who may specialize in one or two disciplines (e.g.: streaming ingest or ELT processing) and technologies (e.g.: Informatica, GCFR, Kafka), but also have a working knowledge of a wider range of data processing patterns and technologies. Principal Data Developers may function as Tech Leads.

Key Areas of Responsibility

• Capture ETL requirements – note this includes all data integration techniques such as ELT, etc.
• Develop, implement, and test processes for extracting data from legacy systems, production databases, Teradata, Hadoop, and Open Source platforms.
• Develop, implement, and test processes for validating and conditioning data prior to loading it into a Teradata Warehouse, Hadoop, or other platforms.
• Develop, implement, and test processes for loading initial and cyclical data into a Teradata Warehouse, Hadoop, or other platforms.
• Develop, implement, and test 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 and / or Hadoop platforms.
• 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 hybrid environments.
• Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives.
• Understanding of the Teradata Reference Information Architecture
• Work with the appropriate project management methodology (Agile or Waterfall) based upon customer and project requirements 

任职要求

• 计算机，信息工程，应用数学，统计等相关专业本科及以上学历
• 5年以上数据仓库或类似系统ETL相关设计开发经验
• 熟练数据库技术知识，熟练使用SQL
• 良好的沟通和表达能力
• 良好的英语口语和阅读理解及书写能力
• 熟悉主流分布式MPP架构平台，有Teradata数据库项目背景的可优先考虑

CountryEEOText_Description:

City: Shanghai

State: Shanghai Shi

Community / Marketing Title: Data Architect

Job Category: Consulting

Company Profile:

Our Company

At Teradata, we believe that people thrive when empowered with better information. That’s why we built the most complete cloud analytics and data platform for AI. By delivering harmonized data, trusted AI, and faster innovation, we uplift and empower our customers—and our customers’ customers—to make better, more confident decisions. The world’s top companies across every major industry trust Teradata to improve business performance, enrich customer experiences, and fully integrate data across the enterprise.

LinkedIn Remote:

Location_formattedLocationLong: Shanghai, Shanghai Shi CN