Capital Markets, Wealth Management (Advisory and Brokerage), Retail Banking. This will require a thorough understanding of investment
products concepts, Market Data, etc.
Retail banking knowledge would involve knowledge on concepts like Loans, Mortgage, HELOC etc
Good understanding of the capital markets terminology, trade life cycle
In Depth understanding of data warehouse concepts and terminologies;
Experience in the dimensional data modelling
Strong communication skills, should be able to interact with different stakeholders, translate the business requirement into technical design, prepare the functional/technical specifications, BRDs
Specific data modeling experience – Normalized ER modeling and dimensional modeling. In dimensional modeling, the resource should be able to demonstrate hands-on experience in designing slowly changing dimensions, understanding and implementation of the CDC process, metrics design.
Strong SQL skills. Teradata experience will be preferred.Experience with Hadoop (Hive, Spark, Scala, Impala) will be an advantage
Working knowledge of ETL, Business Objects reporting, Tableau/Qlikview will be a plus