ETL Informatica Engineer, Cloud-Based Storage (offline)

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 is a global software engineering firm. With over 20 years of experience, teams of highly-trained engineers around the world, deep industry sector knowledge, and ongoing technology research, we help clients create custom software that improves their operations and opens new markets. DataArt started out as a company of friends and has a special culture that distinguishes it from other IT outsourcers, such as:
- Flat structure. There are no “bosses” and “subordinates”.
- We hire people not to a project, but to the company. If the project (or your work in it) is over, you go to another project or to a paid “Idle”.
- Flexible schedule, ability to change projects, to work from home, to try yourself in different roles.
- Minimal bureaucracy and micromanagement, convenient corporate services

Company website:
https://dataart.ua

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