Position: Data Middle #10561
Company: Lohika
Category: SQL
Experience required: 3y
English level: intermediate
Published: 2021-10-01T00:00:00+03:00

Responsibilities

End-to-end data flow checks
Data transfer maintenance
Support existing solution on exporting data to BigQuery
Create new LookML explores and improve reporting dashboard
Improve existing ETL processes and data transfers
Maintain Client Feeds
Extend ETL processes
Support existing Oracle & PostgreSQL based solutions and develop new features
Performance optimization
Direct communication with the customer
Report to TL about current tasks status, technical or other risks

Requirements (required)

Strong knowledge of SQL
Experience with SQL optimization and performance tuning
Experience in building ETL processes, using ETL tools (Talend is a big plus, ODI)
Experience with BI tools (Looker is a big plus, Tableau, Pentaho)
Experience in Data warehousing
Upper-Intermediate level of English

Requirements (optional)

Knowledge of PostgreSQL and PLpgSQL
Experience with Big Data tools: Hive, Presto, BigQuery
Programming languages: Python
Bash/Shell scripting
Knowledge of some ETL, BI and Big Data tools