Senior Technology Analyst

10 - 12 years

15 - 20 Lacs

Pune

Posted:3 months ago| Platform: Naukri logo

Apply Now

Skills Required

Oracle settlements sql*plus python asset management sql loader data migration data mapping trade life cycle sql plsql database design software development life cycle data loader oracle 11g gcp linux eagle agile perl export unix fund accounting

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Title: Senior Technology Analyst Corporate Title: AVP 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

Deutsche Bank
Deutsche Bank

Banking and Financial Services

Frankfurt

approximately 84,000 Employees

2725 Jobs

    Key People

  • Christian Sewing

    CEO
  • Karl von Rohr

    President

RecommendedJobs for You

Thiruvananthapuram, Kerala