作者 |
上海招聘:数据仓库工程师 |
|
zbc0411
头衔: 海归中校 声望: 学员
加入时间: 2006/05/24 文章: 425
海归分: 38865
|
|
作者:zbc0411 在 海归招聘 发贴, 来自【海归网】 http://www.haiguinet.com
This is a position reporting to the Head of Business Analytics in the xxxx Classifieds Group, within China Development Center. The Developer will be responsible for designing, developing, and implementing Data Warehouse applications in an enterprise data warehouse system.
Responsibilities will include:
· Work in cooperation with the Euro Analysis and Development team to prepare logical and physical design documents. These specifications will detail the operation of software intended to extract, transfer and load information from various data sources into the xxxx data warehouse.
· based on the detailed specifications, develop Extract, Transform and Load (ETL) programs (AbInitio, Teradata SQL, Perl/shell script) to populate the warehouse from various source systems(Oracle,Mysql,xml,flat files). Tune the programs and queries to optimize data load/transform times, ensure data accuracy, error handling and escalation.
· Work with the local development and QA group to document and execute Test plans.
·Report weekly on progress and deliverables against plan.
· Write the support documentation, assist the production handover and deployment the new applications to production.
·Build reports according to business requirement and maintains the existed reports
Job Requirements:
(Knowledge, skills, abilities, experience required to perform job)
Given the goals for this position, candidates must:
· Demonstrate effective communication written and verbal English skills.
· Also demonstrate excellent organization skills.
· Possess a BS degree in Computer Science or equivalent
· 2+ years implementing a large-scale data warehouse system (preferably Oracle and Teradata DBMS)
· Strong SQL skills (Oracle, Teradata) and good knowledge of UNIX and Perl.
· Good understanding of data warehousing concepts including dimensional modeling (star/snowflake), Extraction/Transport/Loading best practices.
· Performance tuning experience with large relational databases necessary. Knowledge of ETL tools (AbInitio, Informatica) is a plus.
· Experience in BI tools like MSTR/SAS report is a plus
· Ability to think logically and analyze application and business
email: [email protected]
作者:zbc0411 在 海归招聘 发贴, 来自【海归网】 http://www.haiguinet.com
|
|
|
返回顶端 |
|
|
|
- 上海招聘:数据仓库工程师 -- zbc0411 - (2224 Byte) 2010-7-01 周四, 17:02 (971 reads)
|
|
|
您不能在本论坛发表新主题, 不能回复主题, 不能编辑自己的文章, 不能删除自己的文章, 不能发表投票, 您 不可以 发表活动帖子在本论坛, 不能添加附件可以下载文件, |
|
|