🟡Project Tasks

• Design and develop data pipelines using ETL/ELT tools;
• Implement custom transformations;
• Design and build prototypes and data marts;
• Performance analysis, scaling of existing systems;
• Optimization of SQL queries and database structures;
• Development of procedures in PL/pgSQL;
• Development of DWH architecture, analysis and selection of optimal technologies, methodologies, tools;
• Creation and updating of a knowledge base for DWH users.

🟡Mandatory Requirements

• Knowledge of data warehousing principles;
• Understanding of MPP system architectures;
• Experience with the Hadoop ecosystem/Data Engineer skills (HDFS/YARN/Spark/kafka/Nifi/Sqoop/flume etc.);
• SQL knowledge (DDL, DML), query optimization experience;
• Experience with Greenplum or excellent knowledge of PostgreSQL;
• Practical experience with SAS DIS/Informatica PowerCenter;
• Experience using project management and documentation systems, support and monitoring of information systems within the scope of responsibility;
• Skill in working with Git, Jira, Confluence.