This position reports into the Development Manager of the Market Data systems group which develops and supports systems used to process and distribute security master, price, and corporate action data used by all of the downstream Citco fund administration, brokerage, and custody platforms worldwide
- 1-3 Years on Markit EDM Product implementation and support. This is required.
- 1-3 years experience in database programming. Specifically MS SQL Server. This is required.
- Experience in T/SQL, Querying, Triggers and Stored Procedures.
- Experience with windows, vb scripting.
- Experience with a job scheduling system like autosys, stonebranch.
- At least 2-3 years of overall industry experienceworking in Market Data / Reference Data space with exposure to data vendors like Bloomberg, Reuters etc. is a plus.
- Knowledge of Vendor Products like Bloomberg Data License a plus.
- Knowledge of UNIX / Wintel a plus.
- Knowledge of integration technologies, e. g. MQ, XML, TIBCO, Scripting a plus.
- Experience in Oracle a Plus.
- Experience with working with XML a plus.
- Familiarity with UNIX and shell scripting is a plus
- Experience with the AWS platform is a plus
- Experience in using version management tools preferably SVN
- As a functional specialist on Markit EDM product to the Technical and BA Team as needed. This may include major initiatives and/or minor upgrades/fixes.
- Day to day support of EDM Product and answering EDM related queries, enabling to assist in Generating reports and running SQL Queries on the DB , User Creation and configuration settings .
- Day to day support of programs/processes written in SQL and developing / enhancing application on SQL Server. Good knowledge in writing database stored procedures / triggers and packages.
- Knowledge of performance and tuning of a SQL Server DB.
- Good database implementation knowledge of SQL Server on Windows / Unix Platform.
- Effective determination of any problems and be responsible for problem resolution working with the necessary teams within Citco IT.
- Documenting enhancements such that other team members, business analysis, etc can understand and support the product.