TLM Consultant/Developer

Job Description: TLM Consultant, Developer 

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

Candidate must have – 
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.) 
UNIX Solaris, Linux Shell scripting (bash/Vi Editors / PowerShell) 

What you will do:  

• The candidate, expected to 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 analysing 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 rec 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 DevOps 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.   
  

What you will need to succeed in the role:  

• 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 DevOps Product/Service team driving a culture of continuous improvement.