Data Analyst

Job Description: 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 BA 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 DA must be willing to learn on their feet and educate the technology team. Skills : Proficient in SQL : should be able to write queries: – 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 Understanding of HADOOP/PYSPARK :- Good to have Understanding of basics of UNIX OS :- Good to have Understanding of data analytics tools ( Python / Sas) :- Good to have Functional knowledge : Good Understanding of the credit landscape preferably in CIB ( commercial / institutional banking ) Good understanding of data store concepts Understanding of credit portfolio / credit risk Understanding of data analytics from banking perspective