Job descriptionData structure design, development and creation of packages, procedures and functions based on business requirements in Oracle Database 10G+ and othersEnsures that data structure design is scalable and maintainable.Provision of support and assistance in the design, testing, tuning and implementation of database applicationsWriting / Tuning data ingestion procedures from external suppliers and partners using PL / SQL, SQL loader, 3rd party tools like Toad etc.Business intelligent and reporting excellent skills and designing dashboardscreating new data warehouses and data marts, as well as ensuring that existing reporting solutions are functioning properly.Data warehouse analysts are involved in all aspects of data warehouse development, and in the design and development of business solutionsThe duties for this position include designing and development of Extract-Transform-Load (ETL) processes for data warehouses, gathering requirements, and designing data bases.perform include testing and documentation, and dimensional modelling