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.