Position: Big Data Engineer #8949
Company: Lohika
Category: SQL
Experience required: 2y
English level: upper

Lohika company provides premium software engineering services to leading technology companies. Our customers usually range from startup to high growth and VC backed companies, which drives a culture of acceleration and innovation. We are sure that team extension is the only engagement model, which works best.
Our current customer is a digital agency that connects brands and consumers. The agency is more than 400 people strong, manages over $600MM in media spend and deploys campaigns in 70 markets in many cities around the world. Our customer provides services for companies like Google, Viber, etc. You're looking for your next big thing, aren’t you? So are we, hoping it's you! Jump at your chance!

MAIN TASKS AND RESPONSIBILITIES:
Creating, fixing and improvement ETL's, procedures, functions based on Big Data solutions
End-to-end data flows checks
Designing database schema according to data processing needs

EDUCATION, SKILLS AND EXPERIENCE:
MUST HAVE:
At least 2 years of experience data warehouse and multi-dimensional database design and development using formal methodologies
At least 2 years of experience with at least one RDBMS (Postgres, Oracle, SQL Server, etc.)
Experience in SQL writing and tuning techniques
At least 2 years of experience with at least one ETL tool (Talend - preferred, Informatica, Kettle, etc.)
Knowledge of Git
Agile methodologies
Upper-Intermediate level of English

WOULD BE A PLUS:
Experience with Big Data tools: Presto
Experience with clouds (GCP, AWS)
Java or Python development
Bash/Shell scripting
At least 2 years of experience with Big data tools (Hadoop, Hive, Spark, HBase, Kafka, etc.)