echojobs.io
Login

Stem Xpert

Senior Data ETL Architect, Risk Data AML

Jersey City, NJ
ETL Informatica Oracle SQL PL/SQL Linux Shell Scripting XML Java Script HTML J2EE Business Objects
Search for More Jobs
Description

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

Location: Jersey City, NJ, us

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


Stem Xpert
Stem Xpert

0 applies

0 views

There are more than 50,000 engineering jobs:

Subscribe to membership and unlock all jobs

Engineering Jobs

60,000+ jobs from 4,500+ well-funded companies

Updated Daily

New jobs are added every day as companies post them

Refined Search

Use filters like skill, location, etc to narrow results

Become a member

🥳🥳🥳 452 happy customers and counting...

Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.

To try it out

For active job seekers

For those who are passive looking

Cancel anytime

Frequently Asked Questions

  • We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
  • We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
  • We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
  • We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
  • Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
  • Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
  • Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅

What Fellow Engineers Say