DB Developer
SoftEng
(Internet and Information Technology, 50-250 employees)
Keywords
Skills
I have been working in the IT industry for over 20 years.
Technical skills:
Technical concepts: BI, DWH, ETL
Database: Oracle, DB2, SQL Server, Sybase IQ
ETL: Informatica, IBM DataStage, MS SSIS, Unix
Languages: SQL, PL/SQL, T-SQL, Linux (Shell, Bash)
Reporting: Power BI
Cloud platforms: Azure, AWS
Version Control System: Git, TFS, Jira
Repository: GitHub
Technical skills:
Technical concepts: BI, DWH, ETL
Database: Oracle, DB2, SQL Server, Sybase IQ
ETL: Informatica, IBM DataStage, MS SSIS, Unix
Languages: SQL, PL/SQL, T-SQL, Linux (Shell, Bash)
Reporting: Power BI
Cloud platforms: Azure, AWS
Version Control System: Git, TFS, Jira
Repository: GitHub
Project history
07/2020
-
Present
Jul 2020- Present SoftEng Location: Kyiv, Ukraine Job Position: DB Developer ETL Converting Oracle large tables to flat files with Informatica. Responsibilities: Analysis of Informatica mapping Creating Oracle procedures in PL/SQL to unload data from Oracle database 19 Design of ETL workflows using Informatica for uploading Oracle data from DWH to flat file ETL troubleshooting and performance optimization
09/2022
-
09/2022
DB Developer
DB Best Technologies
PROJECT 2
Client: DB Best Technologies
Location: Kyiv, Ukraine
Job Position : DB Developer
Project Description: Migrating data from different sources platform of AS / 400 (OS / 400)
and SQL Server 2008 into one DWH on SQL Server 2016 with preliminary cleaning, converting
data into data marts.
Databases:
* Platform of AS / 400, MS SQL Server
Tools:
* MS SQL Server
* SQL Server Integration Services (SSIS)
* Team Foundation Server (TFS)
Responsibilities:
* Migration and development of tables, stored procedures, functions, views using the ETL
tool MS SSIS.
* Creating ETL workflows
* Create procedures and functions to populate tables.
Client: DB Best Technologies
Location: Kyiv, Ukraine
Job Position : DB Developer
Project Description: Migrating data from different sources platform of AS / 400 (OS / 400)
and SQL Server 2008 into one DWH on SQL Server 2016 with preliminary cleaning, converting
data into data marts.
Databases:
* Platform of AS / 400, MS SQL Server
Tools:
* MS SQL Server
* SQL Server Integration Services (SSIS)
* Team Foundation Server (TFS)
Responsibilities:
* Migration and development of tables, stored procedures, functions, views using the ETL
tool MS SSIS.
* Creating ETL workflows
* Create procedures and functions to populate tables.
09/2022
-
09/2022
DB Developer
DB Best Technologies
PROJECT 1
Client: DB Best Technologies
Location: Kiev, Ukraine
Job Position : DB Developer
Project Description: Load flat files to DWH Sybase IQ using IBM DataStage Platform for
Data Integration
Databases:
* Sybase IQ
Tools:
* IBM DataStage
Responsibilities:
* Analysis of IBM DataStage mapping
* Design of ETL workflows using Talend to load data to DWH
Client: DB Best Technologies
Location: Kiev, Ukraine
Job Position : DB Developer
Project Description: Load flat files to DWH Sybase IQ using IBM DataStage Platform for
Data Integration
Databases:
* Sybase IQ
Tools:
* IBM DataStage
Responsibilities:
* Analysis of IBM DataStage mapping
* Design of ETL workflows using Talend to load data to DWH
09/2016
-
07/2020
DB Developer
DB Best Technologies
PROJECT 3
Client: DB Best Technologies
Location: Kyiv, Ukraine
Job Position : DB Developer
Project Description:
"HRB Block ETL Development" : upload Informatica logs, SSIS logs, txt files to Azure Blob
Storage
Responsibilities :
* Creating ETL workflows
* Upload logs to Azure Blob Storage with Azure Storage Explorer
* Tuning SQL Queries (Kusto Query Language) for Azure Monitor Logs
* ETL troubleshooting and performance optimization
* Scheduling tasks in the cloud and restarting the job
* Analysis of logs and finding out the reasons for stopping the job
* Monitoring Upload Azure blob, files, pipelines, queues, and tables
Databases:
* MS SQL Server
Tools, technologies:
* Azure Storage Explorer, Azure Blob Storage, Virtual Machine in Microsoft Azure
Client: DB Best Technologies
Location: Kyiv, Ukraine
Job Position : DB Developer
Project Description:
"HRB Block ETL Development" : upload Informatica logs, SSIS logs, txt files to Azure Blob
Storage
Responsibilities :
* Creating ETL workflows
* Upload logs to Azure Blob Storage with Azure Storage Explorer
* Tuning SQL Queries (Kusto Query Language) for Azure Monitor Logs
* ETL troubleshooting and performance optimization
* Scheduling tasks in the cloud and restarting the job
* Analysis of logs and finding out the reasons for stopping the job
* Monitoring Upload Azure blob, files, pipelines, queues, and tables
Databases:
* MS SQL Server
Tools, technologies:
* Azure Storage Explorer, Azure Blob Storage, Virtual Machine in Microsoft Azure
Local Availability
Only available in these countries:
Ukraine
Ukraine, Kyiv, remote
