Position: Middle ETL Engineer, Cloud-Based Storage
Company: DataArt
Experience required: 2y
Category: SQL
English level: upper
Published: 2021-06-01T00:00:00+03:00

Our client is a system integrator that modernizes the IT infrastructure of their clients, which helps their businesses grow. The project’s goal is to build cloud-based storage for sales data for an international company. This storage will automate the reporting process, analyze sales, and calculate bonuses for an affiliate program.

The project extensively uses such technologies: Oracle, MS SQL Server, DB2, PostgreSQL.

The processes are arranged according to the Agile principle and methodologies.

Currently, we are looking for 4 specialists to join us. They will work together in one team.

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”.

Responsibilities
Development of ETL streams
Building dependency streams for downloads
Formation of development standards
Testing architectural hypotheses in practice/preparation of prototypes

Must have:

2+ years of experience in projects with large volumes of data
Experience building and supporting a data warehouse as an ETL developer or architect
Solid experience with ETL SQL Server Integration Services (SSIS)
Experience with Informatica PowerCenter
Experience with MPP platforms
Experience with SSAS: basic developments skills, calculations, partitioning
Basic knowledge of databases and skills with DBMS (MSSQL and Oracle are preferred)
Ability to write complex SQL queries
Experience building load dependencies
Experience working with industrial DBMS (DB2, Oracle, MS SQL Server) as a developer
Knowledge of the principles of building data warehouses
Knowledge of SQL at the level of writing effective queries for fetching and transforming big data
Taking into account the peculiarities of the syntax of PostgreSQL, MS SQL Server, Oracle
Knowledge of shell scripts at the level of processing CSV files (Linux)
Knowledge of the basic mechanisms of data transformation
Experience in the optimization and parallelization of ETL processes
Ability to work with Git
Understanding of Source-to-Target
Understanding the principles of working with a "golden record"
Experience building download dependencies
Experience implementing reused procedures and mapplets
Experience with historical data, business history, technical history, including in the absence of Transaction date in the source, generation of surrogate keys

Would be a plus:

Experience with DataVault
Experience with Redshift
Experience with DQ and data cleansing
Experience with AWS, understanding of basic database services, storage, authentication
Spoken English