Supervision over design, management and improvement of various data warehouses.
Scope of works of DCG:
Construction and modification of ETL processes, browsing changes made by other team members, and presentation of recommendations concerning the strategy and the architecture of a data warehouse.
Technologies:
SQL, Oracle, Informatica Powercenter
Result:
Implementation of technical and functional solutions improving data warehouse supplying processes. Provision of appropriate scalability for further roll-outs.
Design challenge:
Assignment and transfer of a database application using more efficient servers and processes.
Scope of works of DCG:
Analysis, design, implementation, testing, documentation, implementation and maintenance.
Technologies:
SQL, PL/SQL, Informatica PC, Oracle Exadata
Result:
Simplification of the database architecture and increase in efficiency.
Design challenge:
Design and implementation of a database part of a B2B sales application.
Scope of works of DCG:
Analysis, design, implementation, testing, implementation and maintenance.
Technologies:
SQL, Informatica PC, MS SQL Server.
Result:
Growth in sales by development of price management tools.