Skip navigation EPAM

DB/ETL Engineer Kyiv, Ukraine or Remote

DB/ETL Engineer Description

Job #: 65612
EPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our customers, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.

DESCRIPTION


Our client is a leading multi-local food and beverage company building on health-focused and fast-growing categories in 3 businesses: Essential Dairy & Plant-Based Products, Waters, and Specialized Nutrition.

The current project’s goal is to set up and Perform a process of reverse-engineering of existing solutions.

Project technologies and tools

  • webMethods – SOA-based data ingestion and transformation orchestration and governance
  • snapLogic – ETL tools
  • Snowflake – data warehouse

Responsibilities

  • Design and develop ETL/warehousing/product sharing solution on Azure technology stack
  • Develop ETL technical specifications, designs
  • Develop, test, implement, and support optimal data solutions
  • Develop, test, implement, and support optimal data solutions
  • Document ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance
  • Integrate ETL process with existing SOA-based orchestration and governance system
  • Work with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake
  • Perform problem assessment, resolution, and documentation in existing ETL packages, mapping and workflows
  • Troubleshoot data issues and defects to determine root cause
  • Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques
  • Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations
  • Provide development team coordination and management

Requirements

  • 3+ years’ experience in DB engineering
  • Good communication skills. Can discuss integration aspects of ETL and governance tool on technical level with US team who manages orchestration
  • Deep understanding of common ETL processes and data management processes
  • Experienced in setup and development of data governance processes: business flows, cataloging, lineage, quality, data sharing etc
  • Minimal+ knowlege of APIs (REST) and integration. Be able to setup and use integration btw Informatica or ADF API and webMethods and propose integration approach
  • Understanding of basic steps of CI/CD for ADF or Informatica Cloud
  • Basic knowledge of any programming languages (Java, Python)
  • Experienced in estimations and task prioritizing. Be able to discuss priorities with a customer team
  • Experienced in data modelling (traditional: Kimball/Inmon and versions: Hub&Spoke, Data Mesh, Data Vault)
  • Intermediate or higher English level, both spoken and written (B1+)

We offer

  • Competitive compensation depending on experience and skills
  • Individual career path
  • Unlimited access to LinkedIn learning solutions
  • Social package - medical insurance, sports
  • Compensation for sick lists and regular vacations
  • English classes with native speakers (certified English teachers)
  • Flexible work hours

Наши сотрудники

ИЛЬЯ ПРИТУЛА
Ресурсный менеджер
Санкт-Петербург, Россия

ОЛЬГА КАЗАКОВА 
Руководитель проектов
Москва, Россия

ИЛЬЯ РОМАНОВ
Глава практики e-commerce
Москва, Россия

АЛЕКСЕЙ УДАЛОВ
Архитектор решений
Амстердам, Нидерланды

ЧЕМ МЫ МОЖЕМ ВАМ ПОМОЧЬ?


Наши офисы