Data structure design, development and creation of packages, procedures and functions based on business requirements in Oracle Database 10G+ and others
Ensures that data structure design is scalable and maintainable.
Provision of support and assistance in the design, testing, tuning and implementation of database applications
Writing / 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 dashboards
creating 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 solutions
The 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