Position: Senior ETL Engineer with Informatica, Banking System
Company: DataArt
Category: SQL
Experience required: 3y
English level: upper
Published: 2021-06-01T00:00:00+03:00

Our client is a British bank, one of the largest financial services companies in the world. The bank was founded three centuries ago, and today its assets are estimated to be worth trillions of US dollars.

DataArt's experts together with developers on the client's side are creating new banking apps and upgrading the old ones.

Working on this project will provide an opportunity to participate in the technological modernization of a large financial institution, to create a product for millions of users, and to obtain experience in agile software development.

We hire people not for a project but for the company. If the project (or your work on it) is over you go to another project or to a paid “Idle”.

Responsibilities:
Development of ETL streams using Informatica and PL/SQL
Building dependency streams for downloads
Data preparation and analysis
Testing architectural hypotheses in practice/preparation of prototypes

Must have:

3+ years of experience in projects with large volumes of data
Experience building and supporting a data warehouse as an ETL developer
Extensive knowledge of ETL concept
Knowledge of the mechanisms of data transformation
Experience in the optimization and parallelization of ETL processes
Solid experience with Informatica PowerCenter
Knowledge and experience working with Oracle DBMS as a developer
Knowledge of SQL at the level of writing effective queries for fetching and transforming big data
Ability to write complex SQL queries using PL/SQL
Experience building load and download dependencies
Understanding of Source-to-Target
Understanding the principles of working with a "golden record"
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
Spoken English

Would be a plus:

Knowledge of shell scripts at the level of processing CSV files (Linux)
Ability to collect and analyze requirements
Experience designing databases and data warehouses