LDH / SQL Server Engineer

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, AuMs 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

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

• 10-12 years of experience in developing and maintaining applications within Asset management financial domain
• Expertise in Eagle Star and PACE application, with hands on knowledge in Web Panels, STAR Scheduler, STAR Message Center, PACE Uploaders and Exporters
• Strong knowledge on Oracle Architecture and database design
• Excellent Skills in designing and development of applications using Oracle 11g/12c SQL, PL/SQL, toolset like SQL*PLUS, PL/SQL, TOAD
• Excellent SQL skills, experience in writing complex queries and working with database objects, like tables, views, stored procedures, sequences, Data Marts , cursors, triggers, packages and materialized views.
• Expertise with Data Migration, Data Mapping or Table Mapping, Data Loading and exporting by using Import/Export DBA jobs, Bulk Data loading with SQL*Loader and UTIL File Utilities
• Working knowledge in Query Performance Tuning by Analyzing Tables hints, DBMS profiles, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, and general trouble shooting on Oracle.
• Working knowledge on Unix, Windows and Shell Scripting. Python, Perl is also preferred
• Experienced in all phases of Software Development Life Cycle and part of the development team, along with the Systems Analysts and Business Analysts
• Other skills required for this role:
• Strong Linux (including shell scripting)
• Good verbal/written communication skills
• Experience working with agile methodologies