Senior Data Engineer (OTC Derivatives & Big Data Controls) Tampa, FL (3 days Onsite - Hybrid) 12+ months Web Cam Interview $75/Hr on W2 Candidates should be prepared to share screens to do technical coding assignment 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
S
Syntricate Technologies Inc