Capital Market Specialist

Job Description

We are looking for Consultant with strong hands‑on experience in building and supporting reconciliations on TLM Premium 2.5 or higher version platform. The candidate is expected to have good knowledge of various types of reconciliation controls (Nostros, Depos, Inter Accounts, Intersystem, FOBO, FOCL) for the various Capital Markets asset classes, which will be required to understand business and build recons for the same.

• Reconciliation build experience using TLM Premium 2.5 or higher.
• Strong Oracle database development skill. Hands on experience on the Unix Shell scripting commands.
• Production Support experience is good to have.
• Exposure to any reporting tool (BIRT, Crystal / SAP BO etc.).

• Perform comprehensive requirement analysis, development, testing (UNIT / SIT / UAT) and implementation of the reconciliations on the Recs platform TLM Premium 2.5 or Higher into production environment.
• Expertise in Smart stream TLM tool with hands on experience On TLM premium 2.5 or higher version.
• Should have detailed hands‑on experience with TLM TOOLS as SMART STUDIO/ Smart Schema/ Recon Admin/ web Connect/ Control &CT tools.
• Expertise in Oracle (
  Specially TLM tables knowledge
  )/ good hands on write sql stored procedure.
• TLM database table linkages, for analyzing production issue from the backend.
• Expertise in the exception management and breaks allocation automation on the TLM platform.
• Expertise in Unix shell scripting should be well versed with the most frequently used UNIX commands and the Vi Editor.
• Well versed in TLM services/ usage & logs validation for debugging.
• Develop stored procedures, triggers and functions for recs and end‑user reports using Oracle database.
• Production Support will also be one of the responsibilities of the team, which goes on a rotational basis.
• Must have knowledge of Oracle Database Troubleshooting, using profiler, database backup procedures.
• Should have environment knowledge like troubleshooting windows issues, understanding Unix logs and Linux/Unix Solaris services knowledge, patching, server maintenance, application installation, building environments, security patching, network maintenance.
• Should have exposure to Agile and Dev Ops culture.
• Very good communication skills to convey clear details to end users/ clients for any challenges faced during build or testing.
• Knowledge of automated deployment tools will be an added advantage.

• Advance knowledge working with TLM TOOLS as SMART STUDIO/ Smart Schema/ Recon Admin/ web Connect/ Control &CT tools.
• Solid SQL experience on Oracle Database and its performance optimization.
• Understand complex DB objects – stored procedures, database views, triggers, and database structure.
• Ability to write complex SQL queries – joins, updates, scripts for analysis etc.
• Experience in automating the continuous integration/continuous delivery pipeline within a Dev Ops Product/Service team driving a culture of continuous improvement.
• Re‑engineering the business processes and building short relationships with business and operations.
• Good understanding of Capital Markets, Trade Lifecycle of the various Asset classes, which assists in building better reconciliation controls on the TLM Premium recs platform.

• Knowledge of cloud concepts and cloud architecture, different types of cloud computing (preferably GCP).
• Exposure to any Reporting/Analytics tool like BIRT, Crystal/SAP BO/Qliksense/Qlikview etc.
• Knowledge of Dev Ops principles & tools like Git Hub/Jenkins, Jira, Confluence.
• Any programming language experience Python, JAVA.
• Scripting knowledge on the VB, Perl, Power Shell.