Nikolay Petrachkov

Data Engineer

The Randstad, Netherlands12 yrs 10 mos experience
Most Likely To Switch

Key Highlights

  • Expert in building data pipelines on AWS and GCP.
  • Proficient in SQL optimization and data modeling.
  • Experienced in agile methodologies and team collaboration.
Stackforce AI infers this person is a Data Engineering expert in cloud-based data solutions.

Contact

Skills

Core Skills

Data EngineeringPython (programming Language)Google BigqueryAmazon Redshift

Other Skills

AWSAirflowApache AirflowBusiness IntelligenceBusiness Process DesignBusiness Process ImprovementBusiness Process ManagementBusiness Process ModelingBusiness Process SimulationCPN ToolsCSSD3.jsData Build Tool (DBT)Dimensional ModelingElasticSearch

About

Data Engineer experienced in building data extraction and data integration pipelines in cloud data warehouses on AWS and GCP using SQL, Python and Apache Airflow.

Experience

Sennder

Senior Data Engineer

Jan 2023Present · 3 yrs 2 mos · Amsterdam, North Holland, Netherlands · Remote

  • Part of Data Platform team.
  • Working with dbt, Snowflake, Terraform, Fivetran, Python, Dagster.
  • Contributed to Data Mesh efforts. Wrote several architecture decision records (ADR).
  • Wrote and applied guidelines on efficient SQL pipelines in Snowflake.
  • Optimized performance of SQL queries 🚀
  • Cloud costs reduction.
  • Data modeling with Data Vault.
Data EngineeringPython (Programming Language)Data Build Tool (DBT)SnowflakeSQL

Self-employed

Senior Data Engineer

Oct 2022Dec 2022 · 2 mos · Netherlands · Hybrid

  • Freelance contract work.
  • Was busy with Apache Airflow, dbt, AWS.
Apache AirflowdbtAWSData Engineering

Remote

Senior Data Engineer

Mar 2022Jun 2022 · 3 mos · Netherlands

Ikea

Senior Data Engineer

Mar 2021Feb 2022 · 11 mos · Amsterdam, North Holland, Netherlands

  • Assembled Data Warehouse In BigQuery following dimensional modeling design;
  • Implemented incremental data transformation processes in BigQuery with Dataform 💰;
  • worked in agile (Scrum) way 🤹;
  • Participated in interviewing Data Engineers.
Google BigQueryDimensional Modeling

Takeaway.com

Senior Data Engineer

Oct 2018Feb 2021 · 2 yrs 4 mos · The Randstad, Netherlands

  • worked with AWS Redshift, AWS Glue, Kinesis, AWS Database Migration Service;
  • managed infrastructure on AWS with Cloudformation;
  • built data pipelines with Apache Airflow;
  • designed data warehouse ETL processes;
  • modeled data warehouse following dimensional modeling design;
  • optimized performance of SQL queries 🚀;
  • participated in the interviewing process for positions of Data Engineer/DevOps/DWH Engineer 🤝.
Python (Programming Language)SQLDimensional ModelingAmazon RedshiftApache AirflowData Engineering

Catawiki

Business Intelligence Developer

Sep 2016Aug 2018 · 1 yr 11 mos · The Randstad, Netherlands

  • wrote MDX queries for reports;
  • implemented cubes based on the Dimensional modeling technique;
  • maintained and implemented ETL processes in SQL (PostgreSQL) and Python;
  • implemented new ETL processes in Apache Airflow;
  • wrote data processing tasks in Apache Spark (PySpark);
  • worked with HDFS and Hive;
  • participated in the interviewing process for positions of Data Engineer and Product Owner.
PostgreSQLPython (Programming Language)SQLApache AirflowData Engineering

Eet.nu

Programmer

Sep 2014Aug 2016 · 1 yr 11 mos · Netherlands

  • As part of the team, I did the following:
  • Upgraded several Ruby on Rails applications from Rails 3.* to 4.*
  • Participated in the development of several web applications (with Ruby on Rails).
  • Wrote specs (with Rspec, Capybara, Selenium & Poltergeist) for a new product of the company.
  • Converted views in core product from HAML to ERB.
  • Built charts with D3.js.
  • Took part in migrating Eet.nu applications from MySQL to PostgreSQL.
  • Developed advanced search functionality based on Elasticsearch.
  • Acquired remote working experience.

Glowbyte consulting

Consultant

Mar 2014Jul 2014 · 4 mos · Moscow, Moscow City, Russia

  • @ Analytical CRM support team

Quintel intelligence b.v.

Ruby (on Rails) intern

Nov 2012May 2013 · 6 mos · The Randstad, Netherlands

  • Vastly increased test coverage on legacy applications. For one of the applications test coverage has been increased from ~10% to ~95%.
  • Provided maintenance and fixed bugs on legacy and new applications.
  • Wrote the specifications, planned and implemented new features on the company's core products.
  • Carried out pre-deployment quality assurance.
  • Investigated and applied approaches to improve performance of running applications (caching, eager loading, memoization, flame graphs). For one of the application the response time has been decreased from ~200ms to ~70 ms.
  • Was a key asset on researching, evaluating and planning the database migration strategy for a master-master setup (migration from MySQL to PostgreSQL).

Russian academy of education, education informatization institute

2 roles

Programmer

Sep 2009Jun 2010 · 9 mos

  • Took part in the implementation of the internal email system and file sharing solution for the Russian Academy of Education. Was responsible for the analysis of possible solutions. The solution was implemented based on Ebox platform (Zentyal) and Ubuntu Linux.
  • Was responsible for providing users with help on solving software and hardware related problems.
  • Participated in the development of information system for the institute. Was responsible for the analysis of the available open source and commercial information systems, that would fit provided requirements.

Laboratory Assistant

Nov 2008Aug 2009 · 9 mos

  • Developed a catalogue application for PhD students.
  • Helped researchers with the information search.

Education

Eindhoven University of Technology

Master — Business Information Systems

Jan 2010Jan 2012

International Academy of Business and Management (MABiU)

Specialist (Bachelor) — Applied Information Science (in Economics)

Jan 2004Jan 2009

Stackforce found 100+ more professionals with Data Engineering & Python (programming Language)

Explore similar profiles based on matching skills and experience