Focus on analyzing preliminary Enterprise Data Warehouse Data and do Data Profiling .
Monitor database integrity, investigate inconsistencies, and make recommendations regarding best method to rectify data inconsistencies
Focus on resolving data quality and integration challenges .
Strong communication skills and the ability to gather business requirements .
Support Implementation Project * Work with Technical Lead and System Owner to analyze data in the application .
Determine data migration complexity, to identify information gaps against new requirements or conflicts across multiple applications .
Develop source-to-target mapping (STM) documents by analyzing data content and physical data structures in the legacy and downstream applications.
Identify methods to implement data quality monitoring based on rules specified by business data stewards as part of the implementation .
Strong technical competencies in SQL, database architecture/development and data marts.
Exceptional analytical and problem solving abilities. Ability to work independently and multi- task with a strong attention to detail.
Ability to prepare and present appropriate management reports.
Ability to communicate effectively with internal and external business partners.
Investment Management Asset management life cycles in Fixed Income, Real Estate, Mutuals etc..
Should have independently produced and owned mappings documents for data transfer in EDW environment.
Well versed with complex SQL, preferably on Teradata or ANSI SQL will also do.
Exposure of Third Party Service Providers like LexisNexis (Choice Point), ISO Home Value etc is useful and preferred.
Should have worked on analytics reports.