Upwork home
Sign up
Secondary
Yegor K. Status: Offline
Boston, United States
100% Job Success
Top Rated Plus

Data Architect|Sr. Data Engineer with BI expertise

I am Data Architect/Snr. Data Engineer with 11 years experience with RDBMS/NoSQL databases and processing large amounts of data. Please note that minimum engagement is part-time (20 hrs/week) and month long, this will ensure the quality of delivered solution and mutual benefit. My experience related to enterprise level and high profile projects in the past, but now I'm helping startups and small-mid sized companies to achieve their goals! My core competences are: Data Modelling, Data Architecture on Cloud platforms, Database development, ETL and Business Intelligence, Database Administration Solution Architecture : Design of solution architectures for a data processing systems of various scale and purpose. Definition of up-to-date technical solutions including data storage, network, data processing (ELT/ETL), BI and AI/ML components. Process and methods definitions and optimisations. AI/ML : Amazon AI Services, Bedrock, Sagemaker, Pinecone, pgvector, Databricks Mozaic Data Modelling : Modelling of OLTP and Datawarehouse systems. It could be design of new schema, normalization/denormalization of existing model, Enterprise datawarehouse design based on Kimball/Inmon, Data Lake and Data Vault architectures, Modernization of existing data landscape. Data Lakes : Modern datalakes built on S3, GCS with Databricks, AWS Glue, Trino DBA Activities : DB migrations, Backup & Recovery, Upgrades, Instance configurations, DB Monitoring, Horizontal scaling, Streaming/BDR replications. Sharding with postgreSQL extensions. Data Integration and ETL : Traditional batch ETL - Informatica, Talend, AWS Datapipeline, Matillion ETL Serverless ETL - AWS Lambda, AWS Glue, Batch, AWS DMS, Google Cloud Functions, Databricks Streaming ETL - Apache NiFi, Kafka, Kinesis streams SaaS ETL - Stitch, Alooma, Fivetran, Airbyte BI/data layers - dbt/Prefect Direct loading with DBMS tools & scripting Data Governance and MDM: Design and implementation of solutions based on Informatica DG/MDM, Alation, Atlan, custom dataquality solutions. BI Systems : Design of BI systems and implementation. I had experience with major industry leading tools as Tableau, PBI, Looker and cloud alternatives. Additionally i had experience with old-style reporting solutions from SAP, Qlick, Jasper. Cloud containerization and deployment : Docker, Mesos/Kubernetes Java development : EE/SE , Spring, Hibernate, RESTful APIs, Maven Clouds : - Cloud migrations (AWS, Azure, GCP) - Cloud infrastructures (VPCs, EC2, Loadbalancing, Autoscaling, Security in AWS/GCP) Thank you for getting to the end of this boring details and looking forward working on exciting projects together :) Best Regards, Yegor.
Work history
Yegor K. has more jobs. Create an account to review them
Skills

Skills

  • ETL
  • Oracle PLSQL
  • PostgreSQL Programming
  • Oracle Performance Tuning
  • Tableau
  • Amazon Redshift
  • Amazon Web Services
  • Amazon RDS
  • Amazon EC2
  • Oracle Database Administration

Browse similar freelancers