Techno Functional Consultant L2(Contract
Job in
Washington, District of Columbia, 20001, USA
Listed on 2026-08-05
Listing for:
Pacer Group
Contract
position Listed on 2026-08-05
Job specializations:
-
IT/Tech
Data Analyst, Data Engineering, Database Administrator, IT Consultant
Job Description & How to Apply Below
TLM
We are looking for a 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 on various types of the 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 recs for the same.
Candidate must have:
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 / Power Shell)
Key Responsibilities- The candidate is 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 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
- 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.
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 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 Lifecyle of the various Asset classes, which assist 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.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×