職位描述
Responsibilities :
1. Design, develop and implement Extract, Transformation and Load (ETL) processes, programs and scripts using structured software development method.
2. Develop data/metadata models and technical specifications using standard modeling techniques.
3. Consult with analysts, data providers and business operations staff to understand and elaborate data dissemination requirements and propose technical solutions.
4. Evaluate data product requirements from data providers and translate the requirements into technical specifications.
5. Define technical standards; evaluate alternative protocols, tools and standards.
6. Conduct root cause analysis and resolve production problems.
7. Create documentation of implemented ETL processes for knowledge sharing and hand-off .
8. Develop estimates for design.
Requirements :
1. 3+ year of experience with informatica tool-related development work, ETL approach and technologies.
2. Strong understanding in data warehouse concepts.
3. Proficient in SQL programming. Hands-on experience in DB2 or Oracle Database is preferred.
4. Good communication skills, verbal and written in English or Japanese.
企業介紹
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.
