Candidate must have –
Reconciliation build experience using intelliMATCH 9.x or higher.
Strong MS SQL development skill.
Production Support experience is good to have.
Exposure to any reporting tool (Crystal / SAP BO etc.)
Windows BATCH scripting (CMD / PowerShell)
What you will do:
- The candidate, expected to perform comprehensive requirement analysis, development, testing (UNIT / SIT / UAT) and implementation of the ETD/OTC reconciliations into production environment.
- Through understanding of ETD recs data analysis, various product mappings.
- Deep knowledge on intelliMATCH database linkages and functionalities is necessary for timely resolution of any issues or understanding technical needs of the new rec build.
- Must have exposure to ETD module (pre-processor) of Intellimatch v 9.1 or above.
- Develop stored procedures, triggers and functions for recs and end-user reports using SQL 2012 and above.
- Production Support will also be one of the responsibility of the team, which goes on rotational basis.
- Must have knowledge of MS SQL Troubleshooting, using SQL profiler, database backup procedures, User and Login management in SSMS.
- Should have environment knowledge like troubleshooting windows issues, understanding event logs and windows services knowledge, patching, server maintenance, application installation, building environments, security patching, network maintenance.
- Should have exposure to Agile and DevOps culture.
- Knowledge of automated deployment tools will be an added advantage.
What you will need to succeed in the role:
- Advance knowledge working with intelliMATCH desktop and web modules.
- Solid experience MS SQL development using SQL Server 2012 and above.
- 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 the business processes and building short relationship with business and operations.
- Good understanding of financial market and products, especially in ETD/OTC domain.
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 Crystal/SAP BO/Qliksense/Qlikview etc.
Knowledge of DevOps principles & tools like GitHub/Jenkins, Jira, Confluence