1. Code and test extraction transformation and load programs,
2. Develop and maintain data source to target data mapping,
3. Build and support the Planning Metadata repository, including defining data standards and naming conventions,
4. Assist in the design of an efficient, reliable Essbase, Planning cube,
5. Create calculation scripts/business rules as per business logic,
6. Assist in the development and optimization of reports and queries using Analyzer, Excel adding and Hyperion Reports,
7. Be able to perform database optimization,
8. Perform unit and system testing and data validation,
9. Automate data load activities by writing Esscmd/MaxL scripts,
10. Write shell scripts to perform other maintenance tasks like backup/recovery etc.
技能需求 Requirements
1. 5-6 years of IT services industry experience as a developer/analyst,
2. At least 2-3 full life cycle of Hyperion Essbase/Planning implementation experience OR Experience of 3-4 Hyperion Essbase/Planning system maintenance/support and enhancement projects as an administrator,
3. Ability to create Business rules and Webforms in Hyperion Planning,
4. Working experience on multiple currency in Hyperion Planning,
5. Functional knowledge in Finance is desirable,
6. Hands-on experience including experience on optimizing and fine tuning databases,
7. Good English oral communication skills to be able to participate in internal team meetings and weekly meetings with the customer,
8. Good E-mail communication skills to be able to write clear, effective and to the point E-mails within team and to the customer.