ETL Informatica Development Lead
Charlotte, NC. Posted 3 months ago
This work spans all data and systems that contribute to the "enterprise view of the customer", including all attributes associated with Customer Identification Program (CIP)/ Customer Due Diligence (CDD) processes (customer and account levels), Front Line Monitoring (FLM) processes, Sanctions Scanning processes, Anti-Bribery & Corruption, and/or Wholesale Financial Crimes Risk & Compliance (WFCRC) QA activities associated with any customer.
NTT Data will partner with the Bank and carry out requirement analysis, design, development, testing and production deployment of the CDD DataMart.
Conduct a detailed analysis of the CDD DataMart requirements
Design and Define the structure of the CDD Database
Define the process flows necessary to populate the data necessary for the CDD DataMart
Design the data loading strategy
Define and code the logic to populate corresponding fields in the CDD DataMart
Define and code the ETL components to acquire data into the CDD DataMart
Create the Functional Specifications document
Deploy to the Production environment and support, post production, the CDD DataMart
Strong (5+ years) of experience with ETL Informatica