Job Title： Data analyst （Global CRM OnDemand Team）
Job location: Shang Hai
Job description：
This position will serve as a key role in:
• Managing data cleansing, loading and verification activities for Siebel CRM OnDemand
• Coordinating development and testing activities for data and interface-related changes for CRM OnDemand
Key Responsibilities:
• Manage Data Cleansing, Loading and Verification activities for the upcoming CRM OnDemand China solution deployment, working with third-party provider to execute the loading activities
• Manage Data Cleansing, loading and verification activities for the existing CRM OnDemand global affiliates, working with third-party provider to execute the loading activities
• Resolve data integrity issues with CRM OnDemand global affiliates
• High level Understanding of business processes and Siebel/analytics functionality and apply them to the Interfaces or to the Data Integrity rules.
• Perform ad-hoc SQL queries to extract data for OnDemand affiliates
• Coordinate development and testing activities within the different development teams
• Assist business, application, data and reports SME’s to define requirements for Interfaces and Data Integrity Rules.
• Assist OnDemand local roles to coordinate affiliates data file preparation.
• Assist in the development of test scripts.
• Assist in the preparation of test data.
• Assist and coordinate with Informal and Formal testing.
• Coordinate the resolution of data and interface related defects during Informal Testing and Formal Testing.
Required Experience:
1. 5+ years working and project experiences。
2. Sufficient level of experience with Siebel and/or more specifically EIM/EAI or ETL.
3. Experience of Data management, cleansing and verification
4. Participation on initiatives requiring Solution Design exercises on interface projects
Experience in Computer system validation
5. Effective analytical, problem solving and investigative skills
Essential Skills:
1. Solid technical Design background in Information technology specially on ETL
2. Good technical understanding of SQL, Oracle/Siebel, Informatica and general data management skills.
3. Demonstrated interpersonal skills and team work
4. Ability to communicate proactively and effectively with IT stakeholders
Qualifications(Education/Major/English level):
1. Bachelor or above degree major in Computer Science or related ones.
2. English：Fluent
