Senior Developer, Data/ETL Architect & Risk Data/AML -

Position Senior Developer ( Data/ETL Architect & Risk Data/AML) - #5792 Duration: 9 months+ Location: Jersey City, NJ Job Responsibilities: - Risk Management Architect / Senior ETL developer works primarily on the data needs for the Anti Money Laundering (running on Mantas platform) , Trade Surveillance, Sales Surveillance, Complaince Data repository and various reporting applications. - Looking for candidates worked in financial domain for long time - last 3-4 assignments atleast; last three long assignments using heavy design, ETL (Informatica 9.x) and database (Oracle10, 11g). Required Skills: - Overall 8+ years of ETL methodology and data design experience - Expert Knowledge in Informatica 9.1 development and able to trouble shoot the issues independently. - Experience with Oracle 10 / 11g. - Experience working with Very Large Databases and Data Warehouse environments. - Experience with Redhat Linux Server. Proficiency in UNIX shell scripting is needed. - Minimum 8 years total ETL development experience. Expert level development using Informatica PowerCenter 9.1 - 5+ yrs Oracle experience * SQL (must be very strong in SQL) - Oracle 10g experience is mandatory. - 3+ years Oracle experience * PL/SQL - 3+ years experience with Linux (Preferably Redhat) and Shell Scripting. - Good working knowledge of XML and schemas in Informatica PowerCenter. - Looking for candidates who have recently worked in the financial domain for a long time - (their last 3-4 assignments at least;) using heavy design, ETL (Informatica 9.x) and database (Oracle10, 11g). - Total IT Experience of Years Required: 10+ years Preferred Skills: - Prior experience in building the Compliance Data Repository for Risk data integration. - Working knowledge of dimensional and relational modeling required. - Financial compliance Industry experience pertaining to Anti Money Laundering, Trade Surveillance - Knowledge of Business Objects software and Universes. - Good to have Knowledge of Java Script, HTML, J2EE concepts - Required Education: Bachelors degree in Engineering / Management Job Description: - Primarily responsible for the Data &ETL architecture, Design and Development for data integration efforts surrounding the Risk & Compliance systems. - Establish, maintain and enforce ETL architecture design principles, techniques, standards and best practices. - Drive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling. - Collaborate with Business Analysts, and DBAs to understand business requirements, data, and optimize ETL performance. - Develop complex ETL mappings on Informatica 9.1 platform as part of the Anti Money Laundering and Risk Data integration efforts. - Lead team of junior ETL developers of varying experience levels in building and supporting ETL processes for systems. - Develop and deploy utilities on Informatica 9.1 platform that assist in the daily maintenance of the ETL platform and automation of the jobs. - Performances tune the workflows on 9.1 platform as part of the upgrade and development. - Provide hands on support for production ETL processes