Position: ETL Informatica Engineer
Company: DataArt
Category: SQL
Experience required: 3y
English level: intermediate

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.