-Client is seeking a Data/ETL Architect & Data Senior Developer
-The Risk Management Senior ETL developer works primarily on the data needs for the Anti Money Laundering (running on Mantas platform), Trade Surveillance, Complaince Data repository & reporting applications.
-Primarily responsible for the Data &ETL architecture, Design and Development for data integration efforts surrounding the Risk & Compliance systems. Responsible for the development of Customer Due Diligence (CDD) data modules & various data needs for the Risk & Legal technology business apps.
-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 10.x platform as part of the 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 10.x platform that assist in the daily maintenance of the ETL platform and automation of the jobs.
-Performances tune the workflows on 10.x platform as part of the upgrade and development.
-Provide hands on support for production ETL processes.
-Support Production batch Jobs & Troubleshoot.
-Develop Oracle and Shell scripts.
-Please Note: this position REQUIRES Financial Services experience. Candidates MUST have spent their last 2-3 assignments in the financial services sector.
-Expert Knowledge in Informatica 10.x development and able to trouble shoot the issues independently.
-Experience with Oracle 11g/12c.
-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 10.x
-5+ yrs Oracle experience * SQL (must be very strong in SQL) - Oracle 11g / 12Cexperience 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 2-3 assignments at least;) using heavy design, ETL (Informatica 10.x) and database (11g).
-Informatica 10.x Unix, oracle 11g /12C, SQL, Oracle PL/SQL, Informatica 10.x Administration Skills, XML and Java transformations.
-# of Years Required: 10+ years
-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 on Mantas / Actimize platforms.
-Knowledge of Business Objects software and Universes.
-Good to have Knowledge of Java Script, HTML, J2EE concepts Required Education:
-Bachelors degree in Engineering / Management