ETL / Informatica Analyst

Confidential Company  •  Jersey City, NJ

8 - 10 years experience  •  Staffing & Recruiting

$80K - $200K
Posted on 09/20/17 by Radhika Arora
Confidential Company
Jersey City, NJ
8 - 10 years experience
Staffing & Recruiting
$80K - $200K
Posted on 09/20/17 Radhika Arora

Responsibilities

  • Document Data sourcing requirement, this includes data flow and working with source system for the data required for AML platform
  • Work with AML Up streams systems including Data Ware house and create data extraction document for Payment data – Wire, ACH and Core Banking data
  • Analyze the source data to support business and provide the clarity to business questions
  • Create Data flow diagrams and mapping documents as required for payment wire data and Core Banking data (Deposit, Loan and Credit Control)
  • Understand the Data transformation process with Development team and ensure AML platform consumed the cleansed good quality data
  • Translate test data requirements from source system to support AML platform design activities
  • Prepare SQL scripts during the data sourcing validation and document the process

Skills

  • Experience with Data Analysis ,SQL skills ,ETL, Informatica, SAS DI, Documentation, Presentation
  • 8+ hands-on experience in creating/refining business and functional requirements, Data Analysis and Documentation.
  • Solid experience in the Database SQL skills and ETL knowledge
  • Experience with Waterfall SDLC
  • Understand the Core Banking (Deposit, Loan, Credit Control) data, Payments data and coordinate with multiple source systems as required
  • Experienceworking with Wire, SWIFT formats and ACH transactions data
  • Experienceworking with Data Quality Monitoring and Reconciliation process
  • Data Modelling skills

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.