Ildar Allayarov

Senior Data Engineer

Ildar Allayarov
Karlsfeld, Deutschland

Erfahrungen

Mai 2021 - Bis heute
4 Jahren 1 Monate
München, Deutschland

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
Okt. 2016 - Mai 2021
4 Jahren 8 Monaten
Köln, Deutschland

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)
Sept. 2015 - März 2016
7 Monaten
Köln, Deutschland

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

Sprachen

Deutsch
Muttersprache
Englisch
Verhandlungssicher

Ausbildung

Okt. 2015 - Sept. 2017

University of Siegen

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

Okt. 2012 - Aug. 2015

University of Cologne

B.Sc. · Business Informatics · Köln, Deutschland

Sept. 2006 - Juni 2010

University of Information Technologies in Tashkent

B.Sc. · Informatics · Tashkent, Usbekistan

Zertifikate & Bescheinigungen

Talend Data Integration 6.3 Advanced

Talend

Linux Essential

Linuxhotel