At a Glance
- Tasks: Support and build reconciliations on TLM Premium, analyse requirements, and implement solutions.
- Company: Join a leading financial services firm with a focus on innovation.
- Benefits: Competitive salary, flexible working hours, and opportunities for professional growth.
- Other info: Great chance to enhance your skills in a fast-paced environment.
- Why this job: Be part of a dynamic team transforming the Capital Markets landscape.
- Qualifications: Experience with TLM tools, Oracle databases, and Unix shell scripting required.
The predicted salary is between 50000 - 70000 £ per year.
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 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 reconciliations for the same.
Candidate must have:
- Reconciliation build experience using TLM Premium 2.5 or higher.
- Strong Oracle database development skills.
- Hands-on experience with 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 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 the 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 such as SMART STUDIO, Smart Schema, Recon Admin, web Connect, Control & CT tools. Expertise in Oracle (especially TLM tables knowledge) and good hands-on writing SQL stored procedures. TLM database table linkages for analysing production issues from the backend. Expertise in 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 reconciliations 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:
- Advanced knowledge working with TLM TOOLS such as SMART STUDIO, Smart Schema, Recon Admin, web Connect, Control & CT tools.
- Solid SQL experience on Oracle Database and its performance optimisation.
- Understanding 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.
- 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 assist in building better reconciliation controls on the TLM Premium recs platform.
What additional skills will be good to have?
- 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 DevOps principles & tools like GitHub/Jenkins, Jira, Confluence.
- Any programming language experience (Python, JAVA).
- Scripting knowledge on VB, Perl, PowerShell.
Transaction Specialist in Sheffield employer: Infinity Quest
Join a dynamic team as a Transaction Specialist where your expertise in TLM Premium and Oracle database will be highly valued. Our company fosters a collaborative work culture that prioritises employee growth through continuous learning opportunities and exposure to cutting-edge technologies. Located in a vibrant city, we offer competitive benefits and a supportive environment that encourages innovation and professional development.
StudySmarter Expert Advice🤫
We think this is how you could land Transaction Specialist in Sheffield
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend relevant meetups, and don’t be shy about asking for introductions. We all know that sometimes it’s not just what you know, but who you know that can land you that dream job.
✨Tip Number 2
Prepare for interviews by practising common questions related to TLM Premium and reconciliation controls. We recommend doing mock interviews with friends or using online platforms to get comfortable talking about your experience and skills.
✨Tip Number 3
Showcase your skills through projects or case studies. If you’ve worked on any relevant projects, make sure to highlight them during interviews. We love seeing practical examples of how you’ve tackled challenges in the past!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we often have exclusive opportunities listed there that you won’t find anywhere else.
We think you need these skills to ace Transaction Specialist in Sheffield
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Transaction Specialist role. Highlight your hands-on experience with TLM Premium 2.5 or higher, and don’t forget to showcase your Oracle database skills. We want to see how your background fits perfectly with what we’re looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about the role and how your experience aligns with our needs. Be specific about your reconciliation controls knowledge and any production support experience you have.
Showcase Your Technical Skills:We love seeing technical skills in action! Make sure to mention your Unix Shell scripting experience and any reporting tools you’ve worked with. If you’ve automated processes or improved workflows, let us know – that’s the kind of initiative we value!
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining the StudySmarter team!
How to prepare for a job interview at Infinity Quest
✨Know Your TLM Inside Out
Make sure you brush up on your knowledge of TLM Premium 2.5 and its tools like Smart Studio and Recon Admin. Be ready to discuss your hands-on experience with these platforms, as well as any specific reconciliations you've built. This will show that you're not just familiar with the tools, but that you can effectively use them in real-world scenarios.
✨SQL Skills Are Key
Since strong SQL skills are a must for this role, practice writing complex queries, stored procedures, and triggers. Be prepared to demonstrate your ability to optimise database performance and troubleshoot issues. You might even want to bring examples of past projects where your SQL skills made a significant impact.
✨Show Off Your Scripting Savvy
With Unix Shell scripting being a big part of the job, make sure you’re comfortable with common commands and tools like Vi Editor. Consider preparing a small script or two that you can discuss during the interview to showcase your practical skills and problem-solving abilities.
✨Communicate Clearly
Good communication is essential, especially when conveying technical details to non-technical stakeholders. Practice explaining complex concepts in simple terms. You might even role-play with a friend to get comfortable discussing challenges you've faced and how you resolved them, ensuring you can articulate your thought process clearly.
