Data Analyst

The ideal person would be leading the analysis and data mapping to construct the target SQL. The person would liaise with the business in understanding all possible scenarios to be expected in the mapping, exclusion and inclusion filters and joins with other tables. Frequency of the data load and data sources from which the data needs to be loaded.

Document the requirements, get a sign off from business and create a working SQL. The DA must assist the testers in validating the scope of testing and the validity of the test cases. The DA must assist the Business UVT team in defining the scope of testing. The DA will be the SPOC during UVT validation.

The DA must be a go – getter and handle the things on his own. The DA will be single point of contact to business, testing, and the development team. The BA must be willing to learn on their feet and educate the technology team.

• Skills :Experience in working on data Mapping document
• Must Have
• Proficient in SQL : should be able to write queries efficiently
• Must Have
• Very Strong in data comparison and validation:
• Must Have
• Experience in setting up and defining data quality requirements / controls
• Must have
• Exp. in User acceptance & Verification Testing on data validation/verification:
• Must have.
• Knowledge of Agile process
• Must Have
• Functional knowledge :Good Understanding of the credit landscape preferably in CIB ( commercial / institutional banking )
• Good understanding of data store/data warehousing concepts
• Understanding of credit portfolio / credit risk
• Understanding of data analytics from banking perspective