At a Glance
- Tasks: Build and support reconciliations on TLM Premium, ensuring smooth production environments.
- Company: Dynamic tech firm in Sheffield with a hybrid work culture.
- Benefits: Competitive pay, flexible working, and opportunities for professional growth.
- Other info: Great chance to work in a fast-paced environment with career advancement.
- Why this job: Join a cutting-edge team and enhance your skills in finance technology.
- Qualifications: Experience with TLM tools, Oracle databases, and Unix scripting required.
The predicted salary is between 50000 - 65000 € 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, and 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.) is also beneficial.
What you will do:
- 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.
- 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 skills to write SQL stored procedures.
- Analyze production issues from the backend using TLM database table linkages.
- Expertise in exception management and breaks allocation automation on the TLM platform.
- Well versed in TLM services, usage, and 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.
- Knowledge of Oracle Database troubleshooting, using profiler, and database backup procedures.
- Troubleshoot Windows issues, understand Unix logs, and have Linux/Unix Solaris services knowledge, patching, server maintenance, application installation, building environments, security patching, and network maintenance.
- 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 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.
- Re-engineering business processes and building strong relationships with business and operations.
- Good understanding of Capital Markets and Trade Lifecycle of 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 in VB, Perl, PowerShell.
TLM Consultant Developer in Sheffield employer: PRACYVA
Join a dynamic and innovative team as a TLM Consultant Developer in Sheffield, where we prioritise employee growth and development within a collaborative work culture. Our hybrid working model allows for flexibility while providing access to cutting-edge technology and resources, ensuring you can thrive in your role. With a strong focus on continuous improvement and a commitment to supporting our employees, we offer a rewarding environment that values your contributions and fosters professional advancement.
StudySmarter Expert Advice🤫
We think this is how you could land TLM Consultant Developer in Sheffield
✨Tip Number 1
Network like a pro! Reach out to your connections in the BFSI sector and let them know you're on the hunt for a TLM Consultant Developer role. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Get your hands dirty with some practical projects. If you can, work on personal or open-source projects that showcase your skills in TLM Premium and Oracle databases. This will not only boost your CV but also give you real-world examples to discuss in interviews.
✨Tip Number 3
Prepare for those technical interviews! Brush up on your SQL queries, Unix commands, and TLM tools. Practising common interview questions related to reconciliations and production support will help you feel more confident when it’s time to shine.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be the perfect fit for you. Plus, applying directly can sometimes give you a leg up in the hiring process.
We think you need these skills to ace TLM Consultant Developer in Sheffield
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the TLM Consultant Developer role. Highlight your hands-on experience with TLM Premium 2.5 or higher, and don’t forget to showcase your Oracle database skills and Unix shell scripting knowledge!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. Mention your experience with reconciliation controls and how you can contribute to our team at StudySmarter.
Showcase Relevant Projects:If you've worked on any relevant projects, make sure to include them in your application. This could be anything from automating processes to developing stored procedures. We love seeing real-world examples of your skills!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at PRACYVA
✨Know Your TLM Inside Out
Make sure you brush up on your knowledge of TLM Premium 2.5 or higher. Be ready to discuss your hands-on experience with the platform, especially around building reconciliations and using tools like Smart Studio and Recon Admin. The more specific examples you can provide, the better!
✨SQL Skills Are Key
Since strong SQL skills are a must for this role, prepare to showcase your ability to write complex queries and stored procedures. Think of scenarios where you've optimised database performance or solved issues using SQL, and be ready to explain your thought process.
✨Demonstrate Your Production Support Experience
If you've got production support experience, highlight it! Talk about how you've handled troubleshooting, environment maintenance, and any challenges you've faced. This will show that you're not just technically skilled but also capable of managing real-world issues.
✨Communicate Clearly and Confidently
Good communication is crucial, especially when conveying technical details to non-technical stakeholders. Practice explaining complex concepts in simple terms, and be prepared to discuss how you've built relationships with business and operations teams in the past.
