Position: Data engineer / ETL developer
Category: Data Science
English level: upper
Years of experience: 7


Core Technologies and Tools:
SQL, PL\SQL, Oracle
Python 3 Core, Java Core, OOP
DWH, ETL, Informatica PowerCenter
JMS, Kafka, RabbitMQ, XML, JSON
Jenkins, TeamCity
SVN; GIT 

Knowledge and Skills:
Oracle – knowledge of Memory Structure; Database objects; Partitioning; Materialized view; Locking; Transactions.
Performance tuning - experience in processing of big data; Execution plans; Tables, Indexes; Join methods; Hints; Statistics gathering, AWR reports.
SQL – Writing queries of varying complexity; Data manipulation; Analytical and Grouping functions, Regular expressions, Hierarchical queries.
PL\SQL – Procedures, Functions and Packages; Collections and records; Bulk loads; Cursors; Exception handlers; Dynamic SQL.
Python scripting – Python 3 Core
Java – Java Core, OOP principals
Informatica – Mapping and Workflow development and support
JMS, Kafka, RabbitMQ, XML, JSON
GIT, SVN – Version Control Systems
JIRA, Confluence – Bug-tracking systems