TECHNO FUNCTIONAL CONSULTANT L2

Job Description We are looking for a Consultant with strong hands‑on experience in building and supporting reconciliations on the 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, and to understand business and build recs for the same. Prerequisites Reconciliation build experience using TLM Premium 2.5 or higher. Strong Oracle database development skill and hands‑on experience with Unix Shell scripting commands. Production Support experience is a plus. Exposure to any reporting tool (BIRT, Crystal / SAP BO, etc.). Unix (Solaris, Linux) Shell scripting (bash, Vi, PowerShell). Key Responsibilities Perform comprehensive requirement analysis, development, testing (UNIT / SIT / UAT) and implementation of the reconciliations on the TLM Premium 2.5 or higher platform into production. Expertise in Smart Stream TLM tool with hands‑on experience on TLM Premium 2.5 or higher. Hands‑on experience with TLM tools as SMART STUDIO / Smart Schema / Recon Admin / Web Connect / Control & CT tools. Expertise in Oracle (especially TLM tables) and writing SQL stored procedures. Analyze production issues from the backend using TLM database table linkages. Manage exceptions and automate break allocation on the TLM platform. Unix shell scripting proficiency, familiar with common Unix commands and the Vi editor. Validate TLM services and logs for debugging. Develop stored procedures, triggers and functions for reconciliations and end‑user reports using Oracle. Experience with Agile and DevOps culture. Strong communication skills to convey details to end users/clients during build or testing. Knowledge of automated deployment tools is an added advantage. What You Will Need to Succeed in the Role Advanced knowledge of TLM tools such as SMART STUDIO / Smart Schema / Recon Admin / Web Connect / Control & CT tools. Solid SQL experience on Oracle and performance optimization. Understanding of complex DB objects (stored procedures, views, triggers, structure). Ability to write complex SQL queries, joins, updates, scripts for analysis. Experience in automating CI/CD pipelines within a DevOps product/service team. Re‑engineering business processes and building strong relationships with business and operations. Good understanding of Capital Markets and trade lifecycle of various asset classes to build better reconciliation controls on the TLM Premium platform. Additional Skills That Will Be Good to Have Knowledge of cloud concepts and architecture (preferably GCP). Exposure to reporting/analytics tools like BIRT, Crystal/SAP BO/Qliksense/Qlikview. Knowledge of DevOps principles and tools such as GitHub, Jenkins, Jira, Confluence. Programming language experience in Python or Java. Scripting knowledge in VB, Perl, PowerShell. Mandatory Skills Transaction Lifecycle – Reconciliation Experience 8-10 years Compensation The expected compensation for this role ranges from $80,000 to $158,000. Final compensation will depend on various factors, including geographical location, minimum wage obligations, skills, and relevant experience. The role is eligible for Wipro's standard benefits, including comprehensive medical and dental benefits, disability insurance, paid time off (inclusive of sick leave), and other paid and unpaid leave options. Application & Equal Opportunity Applicants are advised that employment in some roles may be conditioned on successful completion of a post‑offer drug screening, subject to applicable state law. Wipro provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Applications from veterans and people with disabilities are explicitly welcome. #J-18808-Ljbffr Wipro