Senior Data Engineer (OTC Derivatives & Big Data Controls)

Senior Data Engineer (OTC Derivatives & Big Data Controls) Tampa, FL (3 days Onsite - Hybrid) 12+ months Web 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 domain Experience in writing SQL in Hive, Impala Strong 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 DB Running data analysis on controls implemented, issues identified and implement fixes