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

A day in the life

SALMAN TALAT
Account Manager
Toronto, Canada

IRYNA KOVALENKO
Delivery Manager
Kyiv, Ukraine

JAN MAZUREK 
Senior Business Analyst
Gdansk, Poland

DANIELLA KOROSSY
Project Manager
Budapest, Hungary

Hello. How Can We Help You?

Get in touch with us. We'd love to hear from you.


Our Offices