Ildar Allayarov

Senior Data Engineer

Ildar Allayarov
Karlsfeld, Germany

Experience

May 2021 - Present
3 years 11 months
Munich, Germany

Senior Data Engineer

foryouandyourcustomers München GmbH

  • Providing consulting for data integration and data transformation
  • Designing architectural solutions and conceptual data models
  • Building ETL/ELT data pipelines with tools like Talend, Mulesoft, Java and cloud-based PaaS/SaaS such as Azure Data Factory, Azure Delta Lake, Databricks (PySpark/Python), Cosmos DB etc.
  • Deploying of CI/CD release pipelines through Azure DevOps, version control managed via Git/Bitbucket etc.
  • Creating cloud infrastructures using IaaC tools like Terraform
  • Implementation of Data Governance with Azure Purview
  • Guiding the customer team through workshops and trainings
  • Application of agile methods as Scrum, Kanban and Scrumban
Oct 2016 - May 2021
4 years 8 months
Cologne, Germany

Business Intelligence Developer / In-house Consultant

Trusted Shops GmbH

  • Addressing data-driven requirements for data integration, data logistics or DWH from stakeholders across company departments
  • Conception and implementing of logical and physical data models, designing data architectures and building Proof-Of-Concepts
  • Building ETL jobs using Talend, Python, SQL. Orchestrating and scheduling with Rundeck, Linux Cron, TAC, Luigi Framework.
  • Implementation of Data migrations from On-Premises into AWS Cloud using AWS S3, SQS, Lambda functions and Python.
  • Creating CICD Pipelines for automatic rollout of SQL-Structures using AWS Build, SQL, Flyway, GitHub and Toad Data Modeler
  • Transformation of an on-premises enterprise database to the centralized Data Vault based Core Layer in the AWS Cloud (RDS)
  • Generating reporting using MicroStrategy and Qlik Sense
  • Documenting in Confluence, Agile Workflow (Full Cycle)

Implemented Projects:

  • Implementation of a centralized CORE data layer within the Enterprise DWH using Data Vault, Toad Data Modeler, Talend Data Integration
  • Creation of multiple DWHs for finance, consumer, sales and risk departments
  • Data migration of B2B / B2C customer data into the subscription management system Zuora, syncing with Salesforce for accounting using Talend, REST and NoSQL
  • Setup of data pipeline for continuous data injection of shop orders and reviews into the corporate data lake utilizing AWS S3, SQS, Lambda etc.
  • Migration of reviews from on-premises systems into the cloud-based data platform with Talend and AWS Native (S3, Lambda, Snowflake) for Most Advanced Review System (MARS) product unit (Trusted Shops / Volkswagen)
Sep 2015 - Mar 2016
7 months
Cologne, Germany

Working student, business intelligence

Infomotion GmbH

  • Creation of reports with SAP BO Web Intelligence
  • Modeling of the universes with SAP BO IDT
  • Data maintenance in the customer DWH with SAP Data Stage
  • Development of a management information system for BI Unit
  • Preparation of the BI-oriented presentations
Lorem ipsum dolor sit amet

Bosch Building Technologies

  • Development of multilingual and multicurrency price lists for the customer's regional and country-specific sales organizations using Talend, Oracle. Data sources SAP, Stibo Step, Schema St4
  • Development of a data governance Proof of Concept for the customer showcase using Azure Data Factory, Azure Purview and IaaC Terraform
Lorem ipsum dolor sit amet

Bosch Data Logistics

Development of Data Logistics for product data from PIM and SAP into the REST-based Product API via Azure PaaS, utilizing Azure Data Factory, Cosmos DB, Azure Functions, Databricks, Python. Development of CI/CD release pipelines in Azure DevOps for deploying ARM templates in Azure Data Factory

Lorem ipsum dolor sit amet

Bosch Power Tools

  • Development of a data pipeline for the migration of regional product data from various company data sources into the MDM system
  • Implementation of Custom Stibo STEP Web-Extensions using Java
  • Provisioning of a centralized data platform for efficient use of data by company stakeholders and departments. Enabling of analytical data from Google Search, Google Analytics, Product APIs, etc. using Azure Databricks, Azure Data Factory, Synapse Analytics and PySpark (Data-Hub)
Lorem ipsum dolor sit amet

Bosch eBike

Migration of product data from various source systems such as SAP, Stibo Step, etc. to Salesforce CRM using Talend Cloud and Talend Big Data

Lorem ipsum dolor sit amet

Komax Holding AG

Migration of customer data from all globally operating Group subsidiaries into the central interface in Saleforce using Azure PaaS - Azure Data Factory, Azure Cosmos DB, Databricks, and PySpark

Lorem ipsum dolor sit amet

Norauto

Support in rolling out of customer infrastructure on AWS with IaaC Pulumi

Languages

German
Native
English
Advanced

Education

Oct 2015 - Sep 2017

University of Siegen

M.Sc. · Business Informatics · Siegen, Germany · 1.0

Oct 2012 - Aug 2015

University of Cologne

B.Sc. · Business Informatics · Cologne, Germany

Sep 2006 - Jun 2010

University of Information Technologies in Tashkent

B.Sc. · Informatics · Tashkent, Uzbekistan

Certifications & licenses

Talend Data Integration 6.3 Advanced

Talend

Linux Essential

Linuxhotel