Data Modeling and ETL Responsibilities 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. Requirements 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
PricewaterhouseCoopers (PwC) U.S Advisory Shanghai Service Delivery Center (SDC) is the natural extension of PwC's leading-class global delivery capabilities. Our highly skilled resources assist with software development, ERP programming development, application integration and support and maintenance services. SDC Shanghai provides premium, cost effective, high quality technology services for projects based in the United States and global clients focused on key horizontal and vertical end-to-end solutions.Our U.S owned SDCs are critical to PwC's success in the marketplace; in our business landscape a Global Delivery Model has become a competitive necessity. An essential and strategic part of Advisory's multi-sourced, multi-geography Global Delivery Model, the Shanghai SDC is a dynamic, rapidly growing component of our business and has achieved remarkable results in process quality and delivery capability, resulting in a loyal customer base and a reputation for excellence.At the core of our firm's philosophy is a simple construct: People matter. PwC's high-performance culture is based on a passion for excellence with a focus on diversity and inclusion. We recruit the best talent from traditional and non-traditional sources, and then provide our people with the tools—including enriching professional experiences, everyday coaching, timely and productive feedback, and high-quality learning and education opportunities—to grow as professionals throughout their careers at PwC.PricewaterhouseCoopers is all about you. Your personal and professional development, your achievement, your lifelong learning, your individuality and your choices. Whether you're just starting out or an experienced professional, your future starts here.
招贤纳士网联盟网站
