職位描述
職責(zé)描述：
1. This Data Modeling and ETL Specialist will help develop the enterprise data model and will work closely with Business Analyst and Business Intelligence groups to implement ODS/EDW/DM projects.
2. This individual will develop key aspects of the information architecture, including logical/physical data models, data flow diagrams, ETL architect, and ETL artifacts to integrate data from various sources into the ODS/EDW/DM.
3. The candidates must excel in communication, design and delivery of complex models in very large data systems.
4. S/he must be familiar with the strategies, concepts, rationale, challenges, and otherwise best practices of data modeling in a large environment. Relevant experience must include data modeling, data analysis, SQL programming, ETL design and development, knowledge of Internet concepts, and familiarity with database applications and database engineering in general.
任職要求：
1. 5+ years hands on data modeling plus ETL experience in enterprise data warehouse environment
2. Clear understanding of Logical and Physical Data modeling concepts and goals.
3. Proficient using either PowerDesigner, Erwin or Embarcadero modeling tools.
4. Understanding or definition of ETL standards and processes.
5. Implement the ETL scripts according to data mapping specifications.
6. Perform Unit testing and system integration testing of ETL jobs.
7. Conduct root cause analysis of data discrepancy to provide permanent fix.
8. Diagnose performance issue and provide tuning solution
9. Assisting the design and implementation of analyses that will identify is a plus
10. Bachelor degree above
企業(yè)介紹
PricewaterhouseCoopers Information Technologies (Shanghai) Co., Ltd. Is the natural extension of our leading-class delivery capabilities. With over 500 offshore-specific software engineers, we support the delivery of technology enabled end-to-end solutions and are fully integrated with PwC’ s global delivery methodology. We provide premium, cost effective, high quality technology services and solutions to our global clients and focused on key horizontal and vertical end-to-end solutions. PwC GDC China has been rated CMMI Level 5by Sept. 2005 and has ISO27001 and ISO20000 Certification.
