Country: United States of America
Closing date: 25 Nov 2014
Required Skills:
The ideal candidate will have extensive Oracle PL/SQL experience where data is moved from source to staging, further transformed into an ODS and then into dimensional reporting schemas.
Job Details:
This position will be based at UNICEF’s New York Headquarters. You will report to a section manager and work within a team dedicated to this new initiative at UNICEF.
Duties and responsibilities:
The consultant will be responsible for Business Information “back room” tasks included below:
- Develop new content and maintaining existing content to the Oracle database used in the Business Information project contributing towards the delivery of the work plan.
- Work with the DBA section in designing high performance, high availability database systems.
- Participate in database design sessions with the lead application DBA and project manager.
- Develop UNIX shell scripts and/or Windows batch files to facilitate in the extraction, movement, and loading of transactional data.
- Code the extract, transform, and load routines using PL/SQL and SQL Server Integration Services.
- Extract data from SAP BW and SAP ECC into the UNICEF Enterprise data warehouse.
- Maintain documentation on the development and production configuration and technical documentation including logical and physical database designs, metadata, and production procedures.
- Regularly monitor and tune as needed the database performance.
The skills and experience required for this assignment are:
- Bachelor’s degree in Computer Science or at least 5 years hands-on experience in Oracle database development including PL/SQL
- Advanced knowledge of Oracle internals and Oracle database administration and database tuning including hands-on experience creating database schemas, tablespaces, and all other related DDL
- Strong knowledge and experience in UNIX shell scripting
- Knowledge in ETL with hands on experience using an ETL, preferably SQL Server Integration Services
- Experience developing technical documentation
- Good oral and written communications
· Teamwork attitude and very good interpersonal skillsExperienced in a multi-cultural and gender sensitive work environment.
· Excellent communication skills, written and verbal.
· Strong interpersonal skills.
· Ability to work with a team as well as independently
Duration of the Consultancy: 11 months
Pay Rate: $439 per day
How to apply:
Interested applicants are requested to submit their applications along with a cover letter and C.V. to isspost@unicef.org no later than 25 November 2014. Only short listed candidates will be contacted. Depending on the outcome of the selection process the contract will be awarded to an individual or a corporate.
U. S. citizens and all those authorized to work in the U.S. are encouraged to apply.
The Organization does not sponsor for the H1 Visa right now.
0 komentar:
Posting Komentar