Developer (Big Data, capital markets, SQL)
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Strong domain knowledge on OTC derivatives, markets.
7+ years of experience in IT and database/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:
1. The resource will be involved in working on implementation and governance of Controls on markets data on Cloudera/big data platform.
2. Working with source systems that publish transactions to Cloudera data platform and perform RCA on controls failed.
3. Day to day activity would involve working extensively on complex SQLs that are run on Hive/IMPALA DB
4. Running data analysis on controls implemented, issues identified and implement fixes