ETL Informatica Engineer, Cloud-Based Storage

Our client is a system integrator that modernizes the IT infrastructure of their clients, which helps their business grow. The project’s goal is to build cloud-based storage for sales data for an international pharmaceutical company.

This warehouse is integrated with a variety of external data sources and involves the development of multiple data marts. Developing a web portal for managing directories and generating reports for end users is also planned.

Data storage will be implemented in AWS Redshift and organized according to the Data Vault 2.0 model. ETL functions in the project are implemented using Informatica Cloud. We will have to work with terabytes of data.

Must have

5+ years of experience in software development, 2+ years of working with cloud systems
Experience with Informatica Cloud/On-premise: building ETL processes (workflows, maplets, etc.) and integrating them with external systems
Experience with AWS Services: Lambda functions, Cloudformation, S3, excellent knowledge of AWS Redshift/Postgres
Experience in designing schemas and data models
Analytical skills for controlling data quality and identify gaps and inconsistencies
Understanding the layers of data storage architectures and approaches for loading data into such layers and the corresponding algorithms
Experience in designing data platform architecture with infrastructure in mind
Deep knowledge of databases, Data Vault 2.0, experience with columnar databases
Spoken English.

Would be a plus

Knowledge of Python.

About DataArt

DataArt с 1997 года проектирует, разрабатывает, модернизирует и поддерживает IT-решения в области финансов, здравоохранения, телекома, туризма, медиа и интернета вещей.

Клиенты DataArt — компании с уникальными бизнес-моделями — находятся в США и Великобритании, а распределенные команды специалистов — в центрах разработки в России, Украине, Польше, Аргентине и Болгарии.

Company website:
https://dataart.ua

DOU company page:
https://jobs.dou.ua/companies/dataart/