Previous Job
Previous
Datawarehouse Developer
Ref No.: 17-01545
Job Description:
Global Markets IT team is responsible for the delivery of a strategic platform for electronic connectivity of Equity/Derivative products.
This is an opportunity for a skilled, enthusiastic team player to be part of a major design and development initiative that is key to our business.
We are looking for a self-motivated team player with strong previous experience as a senior DataWareHouse developer in Front-Office or related Equity/Derivative systems.


Responsibilities:
Development and Enhancement of Data-warehouse to be used for Regulatory requirements.
Able to coordinate with teams in other regions outside US business hours.
Drive the project requirements autonomously.
Provide status updates, proper escalations & reporting to management & Business.
Write technical specification and document functional flows.
Communication and coordination with Business analysts and other technology teams.
Design data models as per project requirements.
Manage Data Quality Control and Data Lineage.
Monitor database performance, capacity, tune/optimize performance of database performance.

Qualifications:
Oracle SQL, PL/SQL
Data warehousing
  • ETL/ELT/EDLT
  • Data Modeling
  • Partitioning
  • Indexing
Oracle Advanced Analytics
Must have hands on experience to handle millions of transactions on a daily basis.
Ability to analyze and improve queries
Knowledge of Oracle Data Dictionary
Must have knowledge UNIX, Scripting (Shell, Perl/ Python).
Worked on Data Quality Control/Data Lineage
Exposure to Equity, Future and Options products & markets is big plus.
Knowledge of Trade life cycle is big plus.
Experience on BI tools is plus.