Azure Data Factory
- Setup ETL process based on Azure Data Factory, to move data between OLTP.
- MS SQL Server DB (on-premises environment) and Data Mart based on Azure Database for MySQL.
- Implement several aggregations and transformations into ETL
- The ADF pipeline has been designed to move extract data from SQL Server, perform all required transformations and load the data into the Data Mart.
- The service has been integrated with an on-premises monitoring system (Zabbix), to ensure robust, production-ready management and monitoring capabilities.
- Azure AD roles and users have been set up to fit the enterprise security/access policies.
- Azure Cloud
- Azure Data Factory
- Azure Database for MySQL
- Microsoft SQL Server
- 60 hours
- Senior DevOps Engineer
- Senior Data Engineer
Want to make a successful project?
Need to save costs and consolidate your data assets? Tweak the database performance or execute 0% downtime database migration? Our creative approach unlocks business potential and focus on creating newer possibilities