Arkadiy Omelchenko
Verified Expert in Engineering
Database Developer
Arkadiy has been a professional freelancer for almost 15 years with experience in data engineering, integration, warehousing, and modeling, particularly with the entity-relationship model (ER), 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
Availability
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
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.
Skills
Languages
Python, Java, SQL, Java SE 8, JavaScript, HTML, CSS, T-SQL (Transact-SQL), XML, XSD, Stored Procedure, Bash, PL/pgSQL, Snowflake, Java 8
Paradigms
ETL, Object-oriented Programming (OOP), Scrum, Business Intelligence (BI), Kanban, App Development
Platforms
Linux, Oracle, Eclipse, BIRT, OpenShift, Visual Studio Code (VS Code), SharePoint 365, Unix, Desktop
Storage
Databases, PostgreSQL, Oracle PL/SQL, SQLite, Microsoft SQL Server, JSON, IBM Db2, Essbase, H2, Amazon S3 (AWS S3), Linux File Systems
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, CruiseControl, log4j, Talend Open Studio, Talend ESB, SOAP, RESTful Services, Frameworks, OSPlus, Information Systems, Talend Data Integration, Talend Data Quality, Data Warehousing, Crontab, Mutt, SFTP, Data Build Tool (dbt), Talend Open Studio for Big Data, Excel 365, Talend Cloud Integration, SAP, Meltano, SDKs, Singer ETL, PIP, Pipx, Poetry, Cryptography, Systems, APIs, Linux Applications, Security, Network Configuration, System Architecture, Vulnerability Assessment, Linux Device Driver
Frameworks
Jakarta Server Pages (JSP), JSF, Ant Design, JUnit, Hibernate, Spring, Grails, Apache Velocity, Eclipse Modeling Framework (EMF)
Libraries/APIs
Apache POI, Pandas, NumPy, Matplotlib
Tools
JDK 8, Apache Maven, Apache Tomcat, Microsoft Access, SoapUI, Subversion (SVN), HP Quality Center (QC), 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
Industry Expertise
Network Security
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
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