Konstantin Ognev

Konstantin Ognev Email and Phone Number

Senior Data Engineer @ Eufomex
Konstantin Ognev's Location
Munich, Bavaria, Germany, Germany
About Konstantin Ognev

As a Data Engineer in Eufomex GmbH with profound expertise in data warehousing, data analysis and business Intelligence, I apply my skills in data engineering and migration\cloud migration projects to create, support, and optimize ETL data pipelines, DWH objects, and data analysis mechanisms utilizing various tools and technologies, such as DBT, Matilion, ETL, Informatica, SSIS, Azure Cloud, Databricks, Snowflake, Oracle, MS SQL Server.Have 10+ years of hands-on practice in designing and developing sophisticated DB-based solutions utilizing professional SQL skills, proven performance tuning practice and using various ETL data tools. Experienced in building end-to-end data value chain process from ETL to data marts and BI.Familiar with different methodologies - Waterfall, SCRUM\Agile, Kanban.With over 10 years of experience in the financial sector in several international banks and consulting companies, I have developed and enhanced my skills in DWH architecture, data goverment, as well as data analysis, CI/CD process, bug fixing and code review.I enjoy working in different international and multi-cultural teams and projects, and I am always eager to learn new skills and technologies to improve my data engineering capabilities and deliver high-quality solutions to the clients. The key skills that distinguish me from other candidates are: - experience in data migration\cloud data migration - extensive experience in developing and supporting DWH - participating in international data analysis\data migration projects. Skills- Cloud Storage- Cloud Migration- Data Engineering- Data Migration- Data Warehousing- Data Modeling- DBT- Microsoft Azure- Azure Data Factory- Databricks- Extract, Transform, Load (ETL) - Informatica, SAS, SSIS, Matillion, Apache AirFlow- RDBMS (MS SQL Server, Oracle)- SQL programming- Python Programming

Konstantin Ognev's Current Company Details
Eufomex

Eufomex

View
Senior Data Engineer
Konstantin Ognev Work Experience Details
  • Eufomex
    Data Engineer
    Eufomex Oct 2024 - Present
    Munich, Bavaria, Germany
    View
  • Dataart
    Data Engineer
    Dataart Dec 2021 - Oct 2024
    Serbia
    Participation as Data Engineer\DWH Developer in different types of projects:- DWH creation\support (including "from the scratch" DWH projects)- data migration projects between one DWH to another (including stand alone --> cloud migration)- ELT-pipelines creation\support.Activities:- ETL-pipelines creation and support (Informatica, SSIS, Matillion, AWS, Apache AirFlow, Data Building Tool (DBT), Azure Data Factory);- Creating different data transformations mechanisms (Azure Data Factory): - importing data from different data sources (RDBMS, JSON-files, flat files, etc.) - DWH-inside data transformations - upload to Snowflake- Creating different data transformations (Azure Databricks): - raw-data checks and update; - raw-data aggregation for further usage in BI-tools;- Implementation of calculation and data extraction mechanisms (Matillion, AWS);- DWH objects creation (Oracle 11g, MS SQL Server, Snowflake);- Data Analysis (Oracle 11g, MS SQL Server, Snowflake);- CI\CD process;- Bug fixing.Achievements:- work in different international multi-culture teams and projects;- successfully mastered the skills of the Data Engineer role;- boosted skills in English Informatica, Apache AirFlow, Data Vault, Matillion, Azure Cloud, Snowflake, Power BI.
    View
  • Innotech
    Senior Dwh-Developer
    Innotech Oct 2020 - Dec 2021
    Moscow City, Russia
    Participation as DWH-developer in a project of a new corporative DWH creations and support.Activities:- import data pipelines creation and support (Oracle 11g, Informatica, AirFlow);- DWH objects creation (Oracle 11g);- imported data analysis (Oracle 11g).Achievements:- more than 60% of tables was successfully created in new DWH, and data was migrated to new objects;- boosted skills in Informatica, Apache AirFlow, Data Vault.
    View
  • Dis-Group
    Senior Dwh\Etl Developer
    Dis-Group Jan 2020 - Oct 2020
    Moscow, Russian Federation
    Participation as DWH-developer in two types of projects:- development and support the existing and new ELT-functionality DWH (Oracle+Informatica);- creation, development and support of DDL\DML synchronization tools between three DB’s (based on Informatica);Input data analysis also included in working with DWH.Activities: - Participation in framework design;- DWH development and support;- SQL performance tuning;- ETL mappings development (Informatica);- Reverse engineering;- Builds preparation;- Data Analysis (Informatica TDM);- Bug fixing;- Code review and refactoring.Achievements:- there was created a new DDL\DML synchronization system from the scratch- boosted skills in Informatica
    View
  • Rosbank
    Dwh Developer
    Rosbank Jan 2019 - Jan 2020
    Moscow, Russian Federation
    Participation as DWH-developer in project developing and supporting existing and new functionality of new risky DWH (Oracle) according to business requirements. The data in the warehouse was loaded from different sources (RDBMS, flat files). Full circle of DWH data transferring:- ETL-upload data buffer data layer- loading to operation data storage (ODS)- loading to detailed data layer (DDS)- updating data in data marts- dashboard data visualisation (Power BI).Activities: - DWH framework design;- DWH development and support;- SQL performance tuning;- ETL mappings development (SAS DI, SAS EG);- Reverse engineering;- CI-CD;- Data analysis;- Bug fixing;- Code review and refactoring.Achievements:- a new risky DWH was started;- successfully founded risky reporting system based on Power BI;- boosted skills in SAS, MS Power BI.
  • Sberbank
    System Analyst
    Sberbank Dec 2017 - Jan 2019
    Moscow, Russian Federation
    Participation as DWH System analyst in DWH development project.Activities:- business customer's requirements analysis and decomposition into technical tasks;- Data Analysis of current system in order to describe the processes and their;subsequent implementation on the new platform;- data processing development and support (MS SQL SERVER (T-SQL), SSIS, ORACLE 11g (PL-SQL));- business logic development (packages, stored procedures, triggers, views, functions);- DWH documentation support.Achievements:- boosted skills in System Analysis,Analysis of business requirements.
    View
  • Unicredit
    Dwh Developer, Data Analyst
    Unicredit Mar 2012 - Dec 2017
    Moscow, Russia
    Participation as DWH Developer in design, development and support of data processingsystems (collection, updating, verification and structuring of information received from the customer)based on the Oracle 10g.The project aimed to support the existing and implement new DWH functionality. The data in the warehouse was loaded from different sources (different RDBMS-sources, flat-files from FTP). DWH data processing consisted of:- ETL-upload data buffer data layer;- loading to operation data storage (ODS);- loading to detailed data layer (DDS);- updating data in data marts;- reporting data visualisation (SAP Business Objects).Activities: - DWH development and support;- SQL performance tuning;- Creating data migration tools;- ETL mappings development (SSIS, SQL Loader);- ETL process maintenance;- Creating ETL jobs to load data between Oracle DBs and between Oracle and MS SQL Server DBs; - Reverse engineering;- Builds preparation;- Source systems data analysis;- Bug fixing;- Code review and refactoring;- Participating in 24/7 production systems support.Achievements:- successfully completed 2-year data migration project from old corporate DWH to a new;- boosted skills in PL-SQL, T-SQL, ETL Development, DWH Development, Data Visualisation, data migration;- - creating of of self-updated "from the scratch" (Oracle 10g).
    View
  • Pilog Group
    Pl/Sql Developer
    Pilog Group Nov 2010 - Feb 2012
    Moscow, Russia
    Participation as PL-SQL Developer in the project of design, development and support of data processingsystems (collection, updating, verification and structuring of information received from the customer)based on the Oracle 10g.Activities:- Data Analysis;- Business Analysis;- Data handling (Oracle PL-SQL);- Reporting data (Oracle PL-SQL);- project documentation support.Achievements:- data processing systems was created from the scratch and then deployed on customer's side;- experience of working with the project team;- the skill of quickly learning a new subject area, mastering new knowledge;- boosted skills in programming in PL-SQL.
    View
  • Beeline Russia
    Sql Server Database Administrator
    Beeline Russia Oct 2006 - Nov 2010
    Moscow, Russia
    Activities:- DB administration:- installation and configuration of SQL servers- work with files and filegroups (DB up to 2 TB)- backup/restore system configuration- user access rights to the database (NT + SQL autentification)- SQL-scripting- ETL-tools development (SSIS)- monitoring the current activity of users and processes- the ability to understand someone else's code- LAN administration:- domain controllers configuration (user rights, data replication, group security policies, userprofiles)- Citrix-servers support (installation and configuration of the server and client parts)- Anykey support:- configuration of WS, OS and software installation- network configuration of workstations,- software configuration,- configuration of peripheral equipment (printers, scanners, streamers).Achievements:- boosted skills in DB administration, SQL Server administration, T-SQL, Windows domain administration,IT support, customer support.
    View

Konstantin Ognev Education Details

Frequently Asked Questions about Konstantin Ognev

What company does Konstantin Ognev work for?

Konstantin Ognev works for Eufomex

What is Konstantin Ognev's role at the current company?

Konstantin Ognev's current role is Senior Data Engineer.

What schools did Konstantin Ognev attend?

Konstantin Ognev attended Bauman Moscow State Technical University.

Not the Konstantin Ognev you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.