IT People group 4 часа назад

ETL-developer

  • РФ, РБ
  • Удалённо
  • Опыт от 5 лет
  • Контракт
SQLPostgreSQLGitETLAirflowSparkOracleS3Informatica

Описание

Responsibilities

  • The project involves migrating CFT functionality to KHD as part of CFT import substitution.
  • KHD is an analytical corporate data warehouse.
  • The calculator solves the following tasks:
  • daily automated report calculation;
  • preparation and formation of reporting marts for decision-making and management in internal processes;
  • implementation of data quality control and improvement processes, improving data quality in source systems;
  • ensuring auditability and validation of data obtained during calculations.

Requirements

  • General technology stack: Oracle, Informatica, PostgreSql, S3, Spark
  • Commercial experience of 5 years or more;
  • Experience in banking projects;
  • Experience with Oracle development;
  • Experience developing DAGs on Airflow;
  • Knowledge of SQL (JOIN, indexes, aggregate functions, optimization skills);
  • Experience with relational databases (PostgreSQL, Oracle);
  • Experience in developing and supporting ETL/ELT processes: extracting data from various sources, transforming, and loading into the warehouse;
  • Knowledge of Git and ability to work with branches (GitFlow)

We offer

  • Location: Russian Federation, Republic of Belarus
  • Format: remote, under an individual entrepreneur or civil law contract
  • Rate: we will consider your offer
  • Engagement period: 12 months.