Position: Data/Big Data Engineer
Category: Data Engineer
English level: upper
Years of experience: 5

Data Warehouse migration from MSSQL database to GCP BigQuery/PostgresSQL
I performed the production data warehouse migration from MSSQL database to GCP BigQuery and client-sensitive data from MSSQL to PostgreSQL to increase performance of real time data representation. Refactored all existing tables, queries and code to support and actively use of BigQuery features. Redesigned and developed new streaming and batch ETL processes. Optimized existing analytical reports for BigQuery.
Data Engineer at Softserve (2018 - Present)

• Developed and maintained 30+ high-performance data pipelines to support complex data integration.
• Sourced, processed, validated, transformed, aggregated, and distributed data from source databases.
• Use MSSQL, PostgreSQL to store processed and aggregated data.
• Optimized data, queries, and data pipeline architecture.
• Designed highly performed analytical reports using SSRS.
• Migrated Data Warehouse from MSSQL database to the GCP BigQuery.
• Redesigned ETL\ELT SSIS project to Cloud Dataflow pipelines.
• Performed database administration activities such as storage management, backup, recovery, and performance tuning.
Looking for job with plenty of new features and opportunity for development. Ready to learn new features.