Logo
Syntricate Technologies

Senior Data Engineer (OTC Derivatives & Big Data Controls)

Syntricate Technologies, Tampa, Florida, us, 33646


Senior Data Engineer (OTC Derivatives & Big Data Controls)Tampa, FL (3 days Onsite - Hybrid)12+ monthsWeb Cam Interview

Candidates should be prepared to share screens to do technical coding assignment

$75/Hr on W2

Role:-

Strong domain knowledge on OTC derivatives, markets.7+ years of experience in IT and data base/data warehouse domainExperience in writing SQL in Hive, ImpalaStrong SQL skills are essential; experience writing complex queries spanning multiple tables is required.Working knowledge of performance tuning of database queries (understanding the inner working of the query optimizer, query plans, indexes, partitions etc.).Exposure to scripting language like shell scripting, python is required.Experience with FpML is a plus.Responsibilities:

The resource will be involved in working on implementation and governance of Controls on markets data on Cloudera/big data platform.Working with source systems that publish transactions to Cloudera data platform and perform RCA on controls failed.Day to day activity would involve working extensively on complex SQLs that are run on Hive/IMPALA DBRunning data analysis on controls implemented, issues identified and implement fixes