Job Info2，
惠普公司Global Delivery China Center
303377 Senior BI Professional
入门小测试 看你能答上多少？
Data Warehousing concept
1. What is Data Warehousing? Why do we need it?
2. What is ad hoc analysis?
3. Describe OLAP and OLTP systems? OLAP vs. OTLP: list five main differences.
4. What is a fact table in a dimensional model? What is a dimension table?
5. Characterize STAR and SNOWFLAKE schemas.
6. What is a Slow Changing Dimension? List all known types; describe implementation techniques.
7. What is a lookup table?
A lookup table is a finite set of ordered pairs {(x, f(x))}, that is, it is a function on a finite domain (the first column) to some range (the second column).
8. Why do we need Dimension Normalization?
9. List and describe storage models supporting multidimensional analysis (list pros and cons for each).
10. What is ETL?
11. What is a Data Mart?
12. Describe Slice and Dice techniques.
13. What is the main difference between Kimball抯 and Inmon抯 approaches?...PLEASE STUDY ALOT ABOUT THESE TWO MODELS
14. What is a data mining? List and describe data mining tasks.
职位描述：
Description
The Senior BI Professional 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 US 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 eBay 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. Tune the programs and queries to optimize data load 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.
Qualifications
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.
- Ability to think logically and analyze application and business
职位描述：294511 Data Warehousing/BI Solutions Engineer
Description
1) Telco BI solution engineering inclusive of BSS/OSS data ETL process, data mining, analysis and presentation.
2) Implementation of telecom BSS/BI relevant projects as a system architect or developer.
3) Data model design on ODS, Data Warehouse, Data Mart.
4) Communications with oversea project teams, partners and customers.
5) Work scope covers pre-sale activities, requirement, design, coding, configuration, trouble shooting, support, and delivery for telecom BSS/BI solution.
6) Short/long term travel.
Qualifications
1) Bachelor degree (or above) in telecommunication or computer science is a must.
2) Expert, or strong experienced on the following BOBJ technology, including
BOBJ Webi, Crystal Report, BO Sever configuration and BOBJ SDK based implementation or application integration.
3) Good English communication skills.
4) Strong experienced on SQL and DB performance tuning.
5) Experience on large-scale system integration solutions as system architect in BSS/BI domain.
6) Be familiar with UNIX, especially UNIX admin and UNIX shell scripting.
7) Good knowledge in telecom BSS/OSS solutions, including pricing, billing, settlement, CRM, FMS etc.
8) Better to have: Experience on data mining implementation on mainstream tools like SPSS, SAS.
9) Better to have: Expert or rich knowledge on data modeling based upon industrial specifications like TMF/SID, ITU recommendations etc.
10) Responsibility, resilience, self-motivated, self-management, independent and quick learner, team work.
世界500强IT外企（上海）诚聘BI/DW Engineer
BI/DW Engineer
职位描述：
This engineer position will work on ETL of Business Intelligence (BI) OR Data Warehouse (DW) projects.
•Work with domestic/oversea counterparts to code, test, troubleshoot, document and maintain projects;
•Apply current technologies and applicable emerging technologies to assigned duties;
•Case handling - provide support on ticket/case handling that are raised from customer or other Support team for assistance on data content, performance or availability issues;
•Documentation - providing Support documentation on processes and procedures for maintaining system test and production environments .Document solutions and track communications as required and defined within support processes.
职位要求：
- 5Y familiar with at lease 1 or 2 tools below:
- Business Objects
- Informatica
- Microsoft BI products (e.g. Analysis Services, Reporting Services),
- Cognos products (e.g. PowerPlay, ReportNet),
- Oracle/Hyperion products (e.g. Essbase, HFM, OBIEE); •Familiar with at least 1 major DBMS, e.g. ORACLE, SQL Server, Teradata
- Good English both in oral and written
Location: Shanghai
BI-Reporting Lead STE
The Lead STE, under the leadership of the Lead STE located in Seattle, will work closely with the Seattle BI QA, Program Management and Development teams and other RN staff to coordinate and plan activities and to complete projects.
This position will be responsible for leading the team of QA engineers in Beijing.
This position will analyze transactional data and analytical data and compare business rules to discover holes and troubleshoot data integrity, and also dig deeply into report integrity problems. Other job functions include in-depth analysis of use cases, examination of feature and bug fix design and implementation, and corresponding creation, maintenance, execution, and review of test plans/cases, Root Cause Analysis, provide test estimates, schedule resources and track tasks. Quick technical skills, flexibility and energy are a must.
Technical environment is Unix, Teradata and related tools.
This is a great opportunity for a smart, detailed person to go behind the scenes of an industry leader and work hands-on with the engine that drives today’s business.
Knowledge, Skills, and Abilities:
Minimum:
• Experience in leading a team in the application of standard software QA testing methodologies.
• Ability to write complex SQL queries.
• Solid knowledge of relational databases (SQL MYSQL DB2 POSTGRESQL). Experience in data migration, data analysis and/or data warehousing.
• Deep understanding of software development life cycle, quality assurance process, software test design strategy and software testing tools.
• Working knowledge of Unix and shell scripting (Language).
• Motivated and eager to acquire new skills; Self learner;
• Solid oral and written communication skills in English, able to read and discuss the business rules.
• Capacity to work under pressure in small highly focused team.
• Ability to work independently and raise issues by priority and without waiting.
Manual test
Preferred:
• Experience with Microstrategy or equivalent.
• Experience in Teradata and / or Oracle databases.
• Experience with data warehousing.
Education, Certification, and/or Training:
Minimum:
BA/BS in Computer Science or equivalent experience with databases.
Preferred:
MS in technical field (or longer experience with databases).
Experience:
Minimum:
• 2 years of experience as a QA team lead.
• 3 years of software quality assurance or database development experience.
• 2 consecutive years of experience with relational databases.
• Experience with stored procedures or equivalent.
Preferred:
• 1 year of Report testing or data validation experience.
• 2 years experience with Data Warehouse.
• 2 year in QA of back-end systems or business analysis.
Base: 上海（交通便利，薪资福利绝对有竞争力！）
Software Engineer –reporting team
Job Description:
1、Work closely with the Shanghai software development team to provide technical leadership, detailed review, and guidance
2、Work closely with US software engineers to manage the delivery, integration, and testing of our company's products
3、Coordinate with software analysis teams to provide explanation and clarification of requirements, and help to initiate new productdevelopment efforts
4、Provide project management and status tracking jointly for Shanghai development team, and identify issues and suggest solutions
5、Provide development support for Shanghai and US QA activities
Requirements:
1、2+ software development experience in US software company
2、4+ years hands-on Database experience for BI applications. Cognos experience is desirable.
3、Be familiar with MSSQL Server/SSIS.
4、Solid Java J2EE experience is preferred.
5、Be familiar with Agile development model
6、BSCS or BSEE is required
7、Ability to work as part of global / cross-cultural team
8、Excellent bi-lingual (Chinese & English) written and verbal communication skill
上海急招【Data analyst Siebel or EIM/EAI /ETL】 高薪月薪看JD来吧！
|
上海急招【Data analyst Siebel or EIM/EAI /ETL】 高薪月薪看JD来吧！ |
Required
-5+ years with either Cognos software applications or Microsoft SSRS
-For Cognos developers, experience required in:
-PowerPlay, Cognos 8, Report Studio and Analysis Studio (current version is 8.3) on both Unix and Microsoft platforms
-Advance PowerPlay design and construction of cubes
-Design and construct several Cognos 8 or PowerPlay prototypes to aid in report designs and user acceptance
-For SSRS developers, expertise required in
-Writing complex reports in SSRS 2005
-Strong SQL experience (for writing efficient stored procedures) with SQL Server 2005
-Experience with Microsoft Business Intelligence development toolset
-Review report designs and prototypes with project team, business users, system analysts, and business analysts
-Assist during all testing phases including test planning and executions, and defect fixing
-Ability to communicate clearly and effectively, and answer questions precisely
-Demonstrated ability to manage multiple assignments simultaneously
-7+ years experience as a developer, writing reports/SQL in a large team environment
-5+years experience in Data Warehouse environment (must have basic knowledge of facts/dimensions/use of surrogate keys, slowly changing dimensions, indexing options, etc.)
-Recommended
-Cognos administration (cubes are built on a Sun platform)
-Expert-level hands-on experience with Analytical and Operational Reporting within a Data Warehouse environment
-Design and implement security at multiple levels
-Solid PL/SQL and Oracle (8i and/or 9i) experience
-Desired, but not required
-Relational and dimensional data modeling experience
-Experience with Kimball's data warehouse methodology
-Exposure to PeopleSoft EPM or JD Edwards exposure or Hyperion Planning exposure
-Exposure to ETL tools such as SSIS or Ascential Datastage
-Delivered applications through the Microsoft Sharepoint infrastructure.
Responsibilities:
1. Works effectively and professionally .
2. Produces quality desired results in an efficient manner.
3. Recognizes and accepts responsibility for all parts of the job.
4. Communicates accurately and effectively.
5. Complies with organizational and departmental policies and procedures.
6. Performs other duties as assigned.
Requirements :
1. 5+years working experience in consulting company, including Panorama or other BI tools, IT support, projects and a variety of computer applications, BI team management.
2. Bachelor, Master degree in Computer Science or related majors
3. Ability to organize, prioritize and schedule work assignments.
4. Project management skills and the ability to resolve complex problems and issues.
5. Analytical techniques to diagnose user problems and offer corrective action.
6. Ability to develop and manage project plans, estimates and implementations
Responsibilities :
Build Reports/Cubes and ETL function based on specification documents provided by BA/SA , which includes
Reports and Cubes
a) Reviewing report specifications created by Business Analyst
b) Developing reports in Reporting Services or Cognos that meet the specifications
ETL
a) Review Source to Target for clarity
b) Develop SSIS packages
Perform unit testing against data/reports/packages and submit for peer review
Assist BA/SA for requirement sign off, iteration review and approval
Assist BA/SA on integration testing, rectify/improve data quality and system performance issue identified in iteration review and testing
Assist BA/SA on training material, user manual preparation
Provide Maintenance, trouble shooting (including 7x24 on call duty) after report/cube released
Requirements:
Job requires a college degree or equivalent in a technical area plus 2-4 years of report development experience maintaining and supporting reports.
A working knowledge of dimensional modeling and the Kimball Business Intelligence (Data Warehouse) methodologies.
Must have oral communication skills necessary to assist users and work effectively in a team environment with Regional and Global Reporting Project Managers, Business Analyst, QA Tester, and ETL Developers.
A working knowledge of SQL Server 2005 Reporting Services, SQL Server 2005 Analysis Services, Cognos 8.2 Framework Manager, Query Studio, Analysis Studio, and possibly Report Studio (a combination of some knowledge of these tools is required.. Training can be arranged for some of the tools.)
Candidate must be proficient in ETL design practices (Data Transformation and Data Migration) with extensive experience in SQL Server 2005 Integration Services (SSIS). (Not limited to DTS.)
Responsibility
-Work with domestic/oversea counterparts to understand complex elements of a client's business,apply experience and practical understanding of technology and methodology to provide comprehensive, adaptive DW/BI support services.
-Apply current technologies and applicable emerging technologies to assigned duties;
-Develop front-end reporting solutions.
-Related business knowledge in fast Consumer goods Industry.
-Documentation-providing Support documentation on processes and procedures for maintaining system test and production. environments.Document solutions and track communications as required and defined within support processes.
Requirements:
-Knowledge in Data Warehouse (DW) theory and methodology,familiar with related tools.
-Experienced in one of the following reporting tools or skills is plus:
Fast Radar/Oracle Web OSA will be preferred.
Siebel analytics,
BO/Cognos/Hyperion products(e.g. Brio)/Microsoft BI products.
-Data modeling and repository modeling techniques.
-Team-working attitude with strong desire to learn and excel.
-Fluent English is a must.Good English communication skills,with the ability to present resolution to foreign customers in a clear and comprehensible way.
-Good time management skills, ability to multi-task and handle pressure without compromising level of customer service or required detail.
-Exceptional interpersonal and team skills, Excellent Customer Service Focus.
Job Description:
This engineer position will work on Business Intelligence (BI) OR Data Warehouse (DW) projects for HP/External customers.
A qualified candidate should be able to:
-Deep understanding on Data Warehouse system
-Practical working experience in BI/DW industry;
-Work with domestic/oversea counterparts to code, test, troubleshoot, document and maintain projects;
-Apply current technologies and applicable emerging technologies to assigned duties;
-Develop front-end reporting solutions
-Related business knowledge such as fast Consumer goods
-Documentation - providing Support documentation on processes and procedures for maintaining system test and production environments .Document solutions and track communications as required and defined within support processes.
Job Requirements & Skills Required：
-Degree in Computer Science or Engineering related area;
-Experienced in one of the following reporting tools or skills is plus:
o Oracle Web OSA,
o Siebel analytics,
o BO/Cognos/Hyperion products (e.g. Brio)/Microsoft BI products
- PMP certificate is a plus;
- Data modeling and repository modeling techniques
- Knowledge in Data Warehouse (DW) theory and methodology;
- Have good English/Chinese communication skills;
- Team-working attitude with strong desire to learn and excel.
- Knowledge in BI/DW theory and methodology, familiar with related tools;
- Fluent English is a must. Good English communication skills, with the ability to present resolution to foreign customers in a clear and comprehensible way.
- Good time management skills, ability to multi-task and handle pressure without compromising level of customer service or required detail
-Exceptional interpersonal and team skills, Excellent Customer Service Focus (focus on customer as the top priority, keep abreast of customer needs and priorities, and provide value to the customer).
- Solving skills to identify, research, isolate, and resolve customer issues. Maintain call ownership from initial customer contact to call resolution, which includes supporting escalations if appropriate, and provide customer updates either by phone, email or instance messenger timely.
Position number: 90022
Business Intelligence (BI) & Dashboard Systems Developer and Implementer - Responsible for facilitating existing business processes, developing systems for business process improvements, and developing or improving existing systems to track performance indicators necessary to management daily business with long term sustainability.
In his/her role the Business Intelligence (BI) & Dashboard Systems Developer and Implementer will:
· Design, analysis and implementation of DWH / OLAP / BI / Dashboard system
· Plan and execute a roadmap for implementing BI systems
Formal education Knowledge
· Bsc. In computer science, computer engineering or industrial engineering with expertise in information systems
· Experience working with databases such as MSSQL, SAP, Access, P3e.
· Experience in developing high complexity of SQL queries, algorithms and procedures.
· Project management, Schedule methodology
· Proven ability of BI implementation project management
· Experience in BI systems analysis and development, data warehouse , Data Modeling, technical development based on DTWH methodologies
· Experience in inter-systems integration and interface
· High level of self-instruction ability
Skills
· Software development abilities
· Ability to integrate data from multiple sources to create a bigger picture
· Strong data analysis skills
· Cross-departmental project management skills
· High level of creativity
· Strong interpersonal and managerial skills.
· Strong organizational and project management skills.
· Strong analytical skills
· Strong sense of teamwork
· Strong Technical English writing abilities for project documentation – CET06 or above
Computer Abilities / Familiarity with software
· P3e (Primavera)
· MS-Project
· Excel and Excel VBA (Visual Basic for Application) - expert level
· SQL / Access and report engine development SAP
· BI development tools (Business Object, Data Stage-ETL)
Please send resume in English and Chinese! Resumes only in Chinese are not acceptable.
职位编号：90022
商务智能与仪表盘系统开发与实现工程师
负责加快现有的商务流程，开发相应的软件，开发和改善现有系统在日常管理方面所必须的追踪能力，使其具有长期的可持续性。
工作内容包括
-数据库系统 /在线分析处理系统 / 智能商务系统 /仪表盘系统的设计、分析与实现
-为实现智能商务系统，计划和执行技术路线
应骋者应具备的知识背景和技能
知识背景
- 学士学位，专业为计算机科学、计算机工程，或者工业工程(熟悉信息系统)
- 有使用诸如MSSQL、SAP、 Access、P3e等数据库软件的经验
- 有开发高度复杂的SQL查询系统、算法和程序的经验
- 具有一套项目管理与计划调度的方法
- 具有在项目管理中实施商务智能的能力
- 有使用商务智能系统分析与开发的经验，有数据库、数据建模、基于DTWH方法进行技术开发的经验
- 有系统集成与接口设计的经验
- 较高的自学能力
技能
- 软件开发能力
- 整合多种来源的数据，以创建更大图表的能力
- 较强的数据分析能力
- 跨部门项目管理的能力
- 较高的创造性
- 善于处理人际关系
- 较强的组织与项目管理能力
- 较强的分析能力
- 较强的团队精神
- 能够熟练使用英语撰写技术报告与项目文档
计算机技能/熟练使用下列软件
- P3e (Primavera)
- 微软项目管理软件
- Excel and Excel VBA (VB编程语言应用) – 专家水平
- SQL /开发查询和报告引擎
- SAP（企业管理软件）
- 商务智能开发工具(商务目标，数据资料-ETL（企业应用集成软件）)
The HP ITO ESM Reporting team is focused on standardizing and automating the Reporting capabilities for clients in support of HP EDS Outsourcing Services' quality, scalability, and cost structure goals. The major responsibilities of this role include, but are not limited to:
* Hands-on in a BI environment
* Rapid DW development
* DW specification development
* Analyze problems and propose, present and propagate solutions or practices to meet architectural challenges
Qualifications
>Qualifications
* 4+ years working experience is a must
* Bachelor or Masters Degree in computer science
* Fluent English is a must
* Strong troubleshooting, communication and facilitation >Required skills
* Proficient in SQL and stored procedure development and maintenance; analyzing and tuning query performance; understanding data models; analyzing and troubleshooting data and data quality; providing engineering level support and troubleshooting of SQL processing and data issues to production environments
* Proficient in Perl programming and program maintenance; UNIX Korn Shell scripting; UNIX commands and utilities; analyzing data files and data anomalies;
* Experienced in installing and testing Perl and Perl modules on Solaris and Windows; installing and testing various database drivers on Solaris and Windows; configuring, testing, and troubleshooting remote database connectivity; developing, executing, and documenting ETL unit test cases
>Skill Plus
* Experienced in UNIX commands and utilities
* Basic data modeling; MS Word user and technical guide documentation
* Good knowledge of Sun Solaris UNIX is a plus
* Strong DB2 SQL skills is a plus
* Strong technical documentation is preferred
* Strong data modeling is a plus
* Korn shell scripting is a plus
* Experience on OV Suite of Products (OVIS, OVPI, OVSR, OVSD, OVSC, SM etc.) is a plus
* Knowledge on ITIL and ITSM is a plus
Description
Description
This architect position will work on Business Intelligence (BI) projects from HP or HP's customers.
A qualified candidate should be able to:
- Draft solution proposal according to customers' requirement;
- Work with domestic/oversea counterparts to design, implement, test and support projects;
- Apply current technologies and applicable emerging technologies to assigned duties;
- Lead and develop front-end or back-end solutions.
Qualifications
Qualifications
- Bachelor degree or above in Computer Science or Engineering related area;
- At least 5 year practical working experience in BI/DW industry;
- Experienced in the following tools or skills:
* Business Objects
* Microsoft BI products (e.g. Analysis Services, Reporting Services),
* Cognos products (e.g. PowerPlay, ReportNet),
* Oracle/Hyperion products (e.g. Essbase, HFM, OBIEE, OWB);
* SAS
* ETL products (e.g. Informatica, Datastage)
- Familiar with at least one major DBMS, e.g. ORACLE, SQL Server, Teradata
- Profound knowledge in BI/DW theory and methodology;
- Have good English/Chinese communication skills;
- Be good at team-working attitude with strong desire to learn and excel.
- Exceptional interpersonal and team skills, Excellent Customer Service Focus (focus on customer as the top priority, keep abreast of customer needs and priorities, and provide value to the customer).