Data Engineer
Developed a data processing service from scratch, including extracting, filtering, and aggregating data from multiple data warehouses (DWHs) such as PostgreSQL and MS SQL, using advanced SQL scripts.• Created a specialized module for detecting errors and discrepancies in data, utilizing Python with pandas and numpy libraries.• Developed and implemented automated data verification processes using Apache Airflow, ensuring regular data updates and quality control.• Facilitated the integration of the entire application into Docker containers, significantly simplifying the testing and deployment processes on servers.• Developed and deployed a Flask-based web application for data management, including capabilities for user data correction, error note creation, ticket submission, and notification distribution.Tech Stack: Python, Airflow, Docker, Flask, HTML, CSS.Led the organization of ETL processes in a project aimed at modeling the optimal distribution of equipment among agricultural enterprises.• Handled data of various natures (including relational and non-relational databases, images), performing extraction, filtering, and aggregation.• Developed a module for cleaning and transforming data for an optimizer solving integer linear programming problems.• Created a database and a module for uploading data in the required format.Tech Stack: Python, SQL, Pyomo.