Arkadiy Omelchenko
Verified Expert in Engineering
Database Developer
Berlin, Germany
Toptal member since September 26, 2022
Arkadiy has been a professional freelancer for almost 15 years, with experience in data engineering, integration, warehousing, and modeling, particularly with the entity-relationship (ER) model, multi-dimensional, and data vault modeling. He's also keen on data vault, ETL, ELT, databases, agile application development, object-oriented programming (OOP), software development, and reporting. Arkadiy is a seasoned Java, SQL, Python, Linux, and Talend tools professional.
Portfolio
Experience
- Data Engineering - 15 years
- SQL - 15 years
- ETL - 15 years
- Java - 15 years
- Linux - 15 years
- Databases - 15 years
- Python - 5 years
- Data Vaults - 5 years
Preferred Environment
Linux, Python, Java, ETL, ELT, SQL
The most amazing...
...project I've done is the automation of data transformation steps for selected transactional data loads for an international Fortune 500 company.
Work Experience
IT Consultant
ING-DiBa AG
- Implemented and maintained a web-based application to extend multiple IBM products, such as DataStage and Cloud Pak for Data.
- Created functions that include data lineage, generation and customization of ETL/ELT jobs, data quality, and versioning.
- Implemented Microsoft Azure DevOps pipelines for CI/CD.
- Handled the design and realization of the application REST API.
IT Consultant
An International Fortune 500 Company
- Supported the data migration for a global food and pharmaceutical client.
- Automated the data transformation steps for selected transactional data loads, primarily SAP finance and inventory.
- Created the reporting for the quality assurance of the migrated data.
IT Consultant
DB Vertrieb
- Analyzed the data for the internal VDV-KA standard (PKM).
- Built the ETL processes for migrating the existing data from multiple data sources into one database.
- Consulted the conception of the new ETL environment.
- Exchanged with the developers on PKM standards and implemented the product modules.
- Assured the quality of the data during the migration.
IT Consultant
Unitymedia
- Developed the new data transfers and optimized and unified the existing scripts and workflows.
- Analyzed the customers' requirements, built the concepts, and wrote the specifications.
- Automated the ETL processes for the internal system's communication.
IT Consultant
An Insurance Company
- Specified, implemented, and deployed the existing and new ETL processes for data import and export.
- Implemented database functions and stored procedures to automate the reporting.
- Consulted the extension of the existing data platform.
IT Consultant
Commerz Finanz GmbH
- Implemented internal banking projects, including Smart, React, and Heaven.
- Specified and developed the data pipelines for the bank's regulatory reporting.
- Extracted the data from multiple data sources, including the SAP, CRM, and call center systems.
- Provided production support, performance tuning, Talend ETL consulting, and ETL data modeling.
IT Consultant
An Insurance Company
- Specified, implemented, and deployed the existing and new ETL processes for data import and export.
- Implemented database functions and stored procedures to automate the reporting.
- Consulted the extension of the existing data platform.
IT Consultant
VHV Gruppe
- Implemented the data warehouse project called Ertragsorientierters Schadenmanagement (ESM).
- Specified and developed data pipelines for the BI solution needed by the controlling.
- Created the data analysis charts and dashboards with BIRT.
IT Consultant
Commerz Finanz GmbH
- Implemented internal banking projects, including Smart, React, Heaven, SEPA, and Dialer.
- Consulted by the introduction of the new data integration platform.
- Specified and developed the data pipelines for the bank's regulatory reporting.
- Extracted the data from multiple data sources, including the SAP, CRM, and call center systems.
- Provided production support, performance tuning, Talend ETL consulting, and ETL data modeling.
IT Consultant
Landesbank Berlin
- Developed and deployed the data pipelines for the data migration of the banking system software.
- Monitored the success of the data delivery at the migration phase.
- Tracked and fixed bugs in the ETL jobs using HP Quality Center (QC) as a reporting tool.
IT Consultant
excentos Software
- Implemented, coordinated, and deployed the automated load ETL processes for a web application in the context of online product recommendation solutions.
- Programmed the web application for the online product recommendation.
- Tracked and fixed bugs in ETL jobs and web applications using Track as a reporting tool.
Experience
Complex ETL Jobs for SAP Migration
The data was stored in the cloud with Amazon S3 (AWS S3) and Snowflake data warehouse. The quality of the migrated information was assured with Microsoft Power BI charts and dashboards, automatically updated by the additional logic in the ETL jobs.
Vason
VISUALIZE
Vason efficiently displays JSON documents in user-friendly formats, simplifying data visualization and interpretation.
ANALYZE
Vason offers a built-in query system that allows you to thoroughly analyze JSON documents. This feature empowers users to extract insights and explore data effectively, enhancing the accuracy of data analysis.
TRANSFORM
Vason offers a comprehensive solution by allowing users to both transform JSON documents using its built-in system and convert them into different formats, enhancing data adaptability.
Vason Docs
Based on Docusaurus, the website provides public documentation for end users, including instructions on how to use Vason, available functionality, contact information, and legal details.
Education
Graduate Degree in Computer Science
Free University of Berlin - Berlin, Germany
Certifications
Certified Professional in Python Programming 1 (PCPP1)
Python Institute
Certified Data Vault 2.0 Practitioner (CDVP2)
DataVaultAlliance
Enterprise Professional Security (LPIC-3)
LPI
Certified Associate in Python Programming (PCAP)
Python Institute
Linux Engineer (LPIC-2)
LPI
Linux Administrator (LPIC-1)
LPI
Oracle Certified Associate (OCA) | Java SE 8 Programmer
Oracle
Skills
Libraries/APIs
Apache POI, Pandas, NumPy, Matplotlib, Lit, Node.js, Stripe, React
Tools
JDK 8, Apache Maven, Apache Tomcat, Microsoft Access, SoapUI, Subversion (SVN), HP Quality Center (QC), Talend Data Integration, Jira, Confluence, Pentaho Data Integration (Kettle), System i Navigator, Git, Excel 2010, Apache Airflow, Seaborn, Jupyter, GitLab, Microsoft Power BI, GitLab CI/CD, Artifactory, GitHub, Pipx, Ansible, ANTLR, Bitbucket, Grafana, Gradle, IBM InfoSphere (DataStage), IntelliJ IDEA, Logstash, Toad, NGINX
Languages
Python, Java, SQL, Java SE 8, JavaScript, HTML, CSS, Transact-SQL (T-SQL), XML, XSD, Stored Procedure, Bash, PL/pgSQL, Snowflake, Java 8, Kotlin, TypeScript, Markdown
Paradigms
ETL, Object-oriented Programming (OOP), Scrum, Business Intelligence (BI), Kanban, App Development, Azure DevOps, REST, DevOps
Platforms
Linux, Oracle, Eclipse, BIRT, OpenShift, Visual Studio Code (VS Code), SharePoint 365, Meltano, Unix, Desktop, Apache Kafka, Docker
Storage
Databases, PostgreSQL, Oracle PL/SQL, SQLite, Microsoft SQL Server, JSON, IBM Db2, Essbase, H2, Amazon S3 (AWS S3), Linux File Systems, Elasticsearch, PL/SQL
Frameworks
Jakarta Server Pages (JSP), JSF, Ant Design, JUnit, Hibernate, Spring, Grails, Apache Velocity, Eclipse Modeling Framework (EMF), JPA, Spring Boot, Flask, Selenium, Docusaurus
Other
ELT, Algorithms, Data Vaults, Data Engineering, GUI Development, Network Programming, Programming, Lambda Functions, GNU, File Systems, Linux Kernel, Domain Name System (DNS), Web Services, File Sharing, Client Management, Email, Shell Scripting, Linux Administration, Linux Network Stack, IT Security, Network Security, CruiseControl, Log4j, Talend Open Studio, Talend ESB, SOAP, RESTful Services, Frameworks, OSPlus, Information Systems, Talend Data Quality, Data Warehousing, Crontab, Mutt, SFTP, Data Build Tool (dbt), Talend Open Studio for Big Data, Excel 365, Talend Cloud Integration, SAP, SDKs, Singer ETL, PIP, Poetry, Cryptography, Systems, APIs, Linux Applications, Security, Network Configuration, System Architecture, Vulnerability Assessment, Linux Device Driver, CI/CD Pipelines, IBM Cloud Pak for Data, GitHub Actions, Promtail, Vite, Data Visualization, JetBrains IDE
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring