Senior Data Engineer (ETL Development)
с 12.2021 - По настоящий момент |DataArt
Informatica, SSIS, Matillion, AWS, Oracle 11g, MS SQL Server, Snowflake
Participation as Data Engineer in different projects of DWH creation\support and support the data migration process between one DWH to another and creation a new ELT and data extraction functionality.
Tasks:
- ETL-pipelines creation and support (Informatica, SSIS, Matillion, AWS).
- Implementation of calculation and data extraction mechanisms (Matillion, AWS).
- DWH objects creation (Oracle 11g, MS SQL Server, Snowflake).
- imported data analysis (Oracle 11g, MS SQL Server, Snowflake).
- Builds preparation.
- Data analysis (Oracle, Snowflake).
- Production support and bug fixing.
Senior Data Engineer (DWH Development)
10.2020 - 12.2021 |Innotech
Oracle 11g, Informatica, AirFlow
Participation as Data Engineer in a project of a new corporative DWH creations and support.
Tasks:
- Import data pipelines creation and support (Oracle 11g, Informatica, AirFlow).
- DWH objects creation (Oracle 11g).
- Imported data analysis (Oracle 11g).
Senior Data Engineer
01.2020 - 10.2020 |DIS-Group
Informatica PowerCentre, Informatica Developer, Informatica TDM
Participation as developer in the project of business glossary customization and data synchronization
between remote servers.
Tasks:
- Development and configuration of data synchronization mechanisms between servers (ETL-tool Informatica PowerCentre\Informatica Developer);
- Data analysis and configuration data anonymization mechanisms (Informatica TDM tool).
Data Engineer (DWH Development)
01.2019 - 01.2020 |ROSBANK
Oracle, PL-SQL, ETL-tools, SAS BI, SAS EG, MS Power BI
DWH functionality development and support/
Tasks:
- Imported data analysis.
- Development and support of data import and processing mechanisms inside the warehouse (Oracle
(PL-SQL), ETL-tools (SAS BI, SAS EG)).
- Data marts development and support (PL-SQL).
- Analytical visualization tools development and support (MS Power BI).
Data Engineer (DWH development)
12.2017 - 01.2019 |Sberbank
MS SQL Server, T-SQL, SSIS, Oracle 11g, PL-SQL
- Business customer's requirements analysis and decomposition into technical tasks.
- Analysis of the configuration of the 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.
Data Engineer (DWH development)
08.2012 - 12.2017 |UniCredit Bank
MS SQL Server, T-SQL, SSIS, Oracle, PL-SQL, SAP BO, Crystal Reports
DWH development and support.
Tasks:
- Development \ support for ETL DWH processes (MS SQL SERVER (T-SQL), SSIS, ORACLE (PL-SQL)).
- Data marts development and support.
- Searching and downloading of required information according to the requests of business users.
- Development of business logic (stored procedures, triggers, views, functions).
- SQL-scripting and optimization.
- Reporting development and support (SAP BO, Crystal Reports).
- Setting tasks for a third-party developers.
DB Administrator
03.2012 - 08.2012 |Progress
MS SQL Server
• Administration of databases and servers MS SQL Server 2008/2012/.
System engineer
11.2010 - 02.2012 |Pilog Rus
Oracle, PL-SQL
Participation as developer in the project of design, development and support of data processing systems (collection, updating, verification and structuring of information received from the customer) based on the Oracle 10g.
• Consulting business customer, studying the subject area, identifying entities and relationships in the subject area, identifying requirements for the system.
• Development of a data storage and processing system.
• Data processing and creation of a statistical reporting system for imported information.
• Project documentation support.
Achievements:
• Experience of working with the project tea.
• The skill of quickly learning a new subject area, mastering new knowledge.
• Experience in programming in PL-SQL.
Financial Systems Administrator
10.2006 - 11.2010 |Golden Telecom Inc.\ Vimpelcom
SQL, SSIS
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 authentification)
• 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, user profiles).
• Citrix-servers support (installation and configuration of the server and client parts).
Anykey support:
• Configuration of WS's, OS and software installation.
• Network configuration of workstations.
• Software configuration.
• Configuration of peripheral equipment (printers, scanners, streamers).
System administrator/DB administrator-developer
01.2006 - 09.2006 |"Berator" publishing house
SQL, MS SQL Server
• LAN administration (configuration of domain controllers, file servers, database servers, user accounts, WS's).
• DB administration (installation, backup\restore system configuration, configuration of user access to the database, SQL-scripting).
• Reporting development and support (Crystal Reports).
System administrator/DB administrator
04.2005 - 12.2005 |OMNI-Service
MS Access, MS SQL Server, SQL
• DB creation and administration.
• SQL-scripting.
• Backup system configuration, unloading the required information from the database.
• Anykey support(configuration of WS's, OS and software installation, network configuration of workstations, software configuration,configuration of peripheral equipment (printers, scanners, streamers).
DB administrator
01.2003 - 04.2005 |Plant of Calculating and Analytical Machines named after Kalmykova
MS Access, MS SQL Server, SQL
• DB creation and administration.
• SQL-scripting.
• Backup system configuration, unloading the required information from the database.
• Anykey support(configuration of WS's, OS and software installation, network configuration of workstations, software configuration,configuration of peripheral equipment (printers, scanners, streamers).
