Job Title: LDH / SQL Server Engineer

Corporate Title: AVP

Location: Pune, India

Role Description

We are in sought of an Candidate with a Techno functional SME on Eagle STAR, ACCESS and PACE Products and hands-on experience in the below:

• Experience in Managing/Architecting/Developing Enterprise Solutions catering to Asset Management domain
• Domain experience includes Strong knowledge on the Securities Reference Data, Fund Accounting, Trade Clearing & Settlements, Reconciliation, and Trade Life Cycle frame works.
• Provide hands-on support for Global Client Reporting Platforms on accurate Fund Accounting Ledgers, AuM’s and NAV related consolidations
• Experience with Security Reference Manager (SRM) to setup message based service used to validate and enhance security reference data against a list of customizable validation rules (edits/checks).
• Setup payload orchestration for processing Composite Security Engine to build and validate a master security record from multiple data sources, such as Bloomberg, IDC and Reuters, and setup identify and resolve validation errors.
• Participated in the design and development of Eagle Message Center application to enable a routing system that allows external data transmission systems (Brokers, Bloomberg, etc.) to send and receive transaction and ref-erence data to the Eagle suite of products.
• Setup Message Center based data pro-cessing and distribution mechanism to allow for communication between disparate sources.
• Facilitate migration of data between systems by translating, reformatting, and mapping data as needed.
• Set up Outbound data exports to Message Center from the Eagle STAR and PACE applications, with protocols and apply various translation (mapping) rules that convert outbound data
• Co-ordinate with external trading partners and various internal application/infrastructure teams as required
• Support application migration workstream i.e. migrate and configure metadata to new Cloud Environment.
• Candidate has been a skilled communicator with honed relationship management, team building, planning, and analytical abilities. Specialized in Agile development and delivery models.
• Any of the working experience into GCP Technologies/Hosting or re-platforming
• ITIL, CMM level, ITSM and Service Management

What we’ll offer you

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy

• Best in class leave policy
• Gender neutral parental leaves
• 100% reimbursement under childcare assistance benefit (gender neutral)
• Sponsorship for Industry relevant certifications and education
• Employee Assistance Program for you and your family members
• Comprehensive Hospitalization Insurance for you and your dependents
• Accident and Term life Insurance
• Complementary Health screening for 35 yrs. and above

Your key responsibilities

• Actively participating in gathering Business requiements and System Specifications from System Users
• Involve in development of regulatory projects and other major activities kike upgrades and new feature implementation. For ex: MIFID, PRG, EAGLE 13, 11 and 9 version upgrades.
• Adopt Control-M Scheduler to order/schedule the loader, Uploader and exporter jobs
• Extensively use SQL * Loader to load the data from flat files to the database and validate the data marts
• Develop back-end PL/SQL Packages, Building Unix Shell scripts for data migration and batch processing
• Coordinate offshore and onsite teams to ensure Production Stablity
• Involve in tuning of SQL queries by using central tools and manual by Explain plan, Range Indexes
• Involve in handling central Xref mapping for Security, Trade, Portfolio, Client and Account setups and Accounting look through for ledgers
• Involve in handling central repository for time zone based Datamart snapshot for Prices received through several Brokers and external sources

Your skills and experience

• Java Open JDK Struts
• Struts Framework
• EJB and Middle ware Business Objects
• TOMCAT / Weblogic App Server
• REST API / Swagger/ Postman Logging Skills
• SpringBoot Framewrok / Microservices / API
• DevOps CI/CD Pipeline experience: Artifactory / Maven / BitBucket
• Database CRUD operations - Oracle PL SQL / SQL Server
• Unix Bash Scripting

How we’ll support you

• Training and development to help you excel in your career
• Coaching and support from experts in your team
• A culture of continuous learning to aid progression
• A range of flexible benefits that you can tailor to suit your needs

About us and our teams

Please visit our company website for further information:

https://www.db.com/company/company.htm