Application System Engineer
$84 - Per Hour IC - Self Incorporated or $78 w2
Jersey City, NJ
A Contract position at large financial services conglomerate.
Pay Options: IC - Self Incorporated or w2.
Contact Scott Eliot. call (646) 876-9552 / (212) 616-4800 ext.360 or email firstname.lastname@example.org with the Job Code SE31302 or Click the Apply Now button (Sorry, NO 3rd Party (Subcontract) or 1099 for this position!).
Location: Jersey City.
Skills required for the position: SYSTEM ENGINEER, DERIVATIVES, FIXED INCOME, ETL, OLAP, UAT, SQL, UNIX.
Detailed Info: Candidate should have 12+ years of experience in the financial services industry with a minimum of 8 years supporting Investment Banking IT projects in a major investment bank.
Candidate should possess knowledge of transaction mechanics and market structure for all major product classes and instrument types: fixed income, treasury products, listed and OTC derivatives and
Drive new product on-boarding onto the existing platform. Understand business requirements, interact with upstream source systems, perform data analysis, derive ETL mappings and customize the existing functionalities
Analyze trading and settlement data from various sources: front end trading systems, and historical databases. Reconcile source data to various Exchange, Broker, banks reports and invoices.
Perform data validation, conversion and massaging to Strategic Platform's format. Ensure data quality and accuracy. Write sql queries for different source databases by interpreting their data models
Map the data from external sources to Strategic platform. Create and maintain the Strategic platform's data standards. Identify data exception conditions.
Analyze data requirements and design data models in both OLTP and OLAP using ERD and dimensional modeling. Translate business requirements into data fields.
Meet with subject matter experts from the business line to determine reporting requirements
Development/Computing Environment: Analyze the impact of requirements changes on existing system and there by effect the changes
Perform development, user acceptance testing and production checkouts. Support development and testing cycles and manage UAT.
In depth financial product knowledge : Equity, Fixed Income (Treasury, Bonds etc), Derivatives (Futures, Options, Swaps, Interest Rate Products, Equity, Credit etc ), Foreign Exchange, Commodities etc.
Data Architect in both OLTP/OLAP environments including data modeling, dimensional modeling, Data Mapping, ETL Design/Transformation and Metadata repository. Familiarity with Data Modeling Tools such as Erwin, ERStudio, or System Designer
SQL skills and an understanding of a RDBMS System. Netezza experience is a plus.
Working knowledge of UNIX, Linux - experience in writing simple commands.
Experience with data warehousing, BI Tools like QLikview / qliksense is a plus.
Bachelors Degree in Computer Science & Engineering. Masters Degree in Computer Science & Engineering is a plus..
The position offers competitive rate.
Job Id: 31302