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

Stem Xpert • New Jersey, United States • 3w ago

Company Description

Job Description

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

Additional Information

Related Jobs

Chief Operating Officer (COO)

AffinIT • Remote (New Jersey, United States, US) • $170k - $180k / year • 21h ago

21h ago

Chief Operating Officer (COO)

AffinIT • Remote (New Jersey, United States, US) • $170k - $180k / year • 21h ago

21h ago

Chief Operating Officer (COO)

AffinIT • Remote (New Jersey, United States, US) • $170k - $180k / year • 21h ago

21h ago

System Administrator

Franklin Fitch • Irvington, NJ, US • 1d ago

1d ago

Senior Partner Solutions Architect - GSI (East Coast Remote)

Wiz • Remote (New Jersey, United States, US) • 2d ago

2d ago

Mgr- Cyber Eng

Jobs via Dice • Mt. Laurel, NJ, US • 3d ago

3d ago

Systems Administrator

IGT • Trenton, NJ, US • $48.10k - $93.72k / year • 3d ago

3d ago

Escritor de Blogs

Outlier • New Jersey, United States, US • 3d ago

3d ago

Chief Technology Officer

Arch Insurance Group Inc. • Jersey City, NJ, US • $210k - $283.50k / year • 3d ago

3d ago

System Administrator

Halo Collar • Remote (Woodcliff Lake, NJ, US) • 3d ago

3d ago