Design and implement effective database solutions and models to store and retrieve data.
Enhance and maintain IAIT schemas and generate IATI XML and Json files
Move to the new version of IATI 2.03
Enhancements and modifications to the for the IATI biennial index
Assist the ICT specialist in understanding the business needs related to Core Standard Indicators and translating to data models and code
Trouble shoot data integrity issues between SAP, SAP BW and UNICEF Data warehouse
Requirements for a Data Engineer
5 years or more hands-on experience in Oracle database and SQL Server/SQL DB development including PL/SQL and T-SQL
3 years + of experience related to of International Aid Transparency Initiative (IATI) standards, elements and codes
Expert knowledge of IATI’s core, supplementary and metadata schema
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
Knowledge of Salesforce and its integration with Oracle and Azure Synapse
Experience in integration of SAP Open hub files with Oracle
Experience in trouble shooting data integrity issues between SAP and UNICEF Data warehouse(UDW) by looking at data within SAP
SAP knowledge to be able to analyze and transform data from SAP into intelligence in UDW