Job Title:   ETL_Developer (Ref Code: 021413-DAWDEL-IO45-E-RAJ)
Location:   JERSEY CITY, New Jersey
Duration:   6 months
Visa Type: GC/USC/EAD

Job Description:

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.

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.

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

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.

Please mention the job code in the subject line: ETL_Developer (Ref Code: 021413-DAWDEL-IO45-E-RAJ)
Please rush your resumes to careers@iormyx.com <mail to: careers@iormyx.com>