At a Glance
- Tasks: Build and support reconciliations on TLM Premium, analyse requirements, and implement solutions.
- Company: Join a leading firm in Capital Markets with a focus on innovation.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with a strong emphasis on collaboration and continuous improvement.
- Why this job: Make an impact in the fast-paced world of Capital Markets while developing your technical skills.
- Qualifications: Experience with TLM Premium, Oracle databases, and Unix shell scripting required.
The predicted salary is between 60000 - 80000 £ 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 reconciliations 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.
StudySmarter Expert Advice🤫
We think this is how you could land Capital Market Specialist in City of London
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Infinity Quest. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace Capital Market Specialist in City of London
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Infinity Quest.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Infinity Quest's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Infinity Quest
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Infinity Quest.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Infinity Quest will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Infinity Quest employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.
