Responsible for documenting data mapping requirements for the Enterprise Data Warehouse(EDW).
Performs data analysis to validate mappings, e.g. transformation logic, and identify discrepancies.
Exposure to Retail Banking.
Minimum of 7-10 years in a combination of data warehousing, business intelligence, and data analysis including data quality and data profiling.
Administrative/Technical Skills/ Other Information
Proficient in SQL.
Experience with Informatica; ability to interpret code
Knowledge of data warehouse design principles.
Outstanding written and spoken communication skills.
Document source-to- target data mappings for the EDW by extrapolating the Informatica code into business rules.
Performs data analysis for the purpose of profiling the data to identify issues.
Reviews the data models to identify inconsistencies and potential issues.
Participates in the generation of metadata and other support/training materials