Position: Database/ETL Senior developer
Category: SQL
English level: upper
Years of experience: 11


Oracle (SQL, pl-sql) - 15+ years
AWS Cloud technologies - 2+ year
Amazon Redshift - 2+ year
Amazon Athena - 2+ year
MySQL (SQL) - 2 years

Languages: PL/SQL, Python
BI Tools: Qlik Sence
ETL tools: Apachi NiFi, Pentaho, Informatica
e.t.c. 

Tasks:
- maintenance and creation of database objects:packages, procedures, triggers e.t.c;
- development and design of database/DWH, database structures optimization;
- build queries based upon analytical functions, creating hierarchical queries;
- using collection, bulk collect, forall, dynamic SQL;
- database load monitoring (feeds monitoring, feeds load, support);
- queries optimization using AWR reports e.t.c..;
- developing ETL processes, SQL scripts for ETL;
- creating PL/SQL procedures for parsing json with following data transformation and loading it to DWH in compliance with requirements;
- creating ETL processes in the banking platform based upon different sources (text, xml, csv files; database tables; SQL queries);
- building reports based on loaded data;
- architect, design, implementation of POC projects (POC proof of concept projects), testing and documentation of technical solutions related to this projects;
- improving of database performance (materialized views, partitioning, parallel execution, table compression e.t.c..);
New solutions development, improvement of current projects. Have a possibility to work with challenging tasks.