Senior Banking SME - SQL expert

Role: Banking SME - Techno-FunctionalLocation: DubaiWork mode: Work from officeExperience required: Minimum 15yrs of expMust have: Banking experienceData Discovery /Data Sources IdentificationAnalyzing data for data quality and data integrity issuesSupport in data cleansing and data EnrichmentSuggest and coordinate for improvements in dataDocument processes / suggest improvements to systemsSupporting Vendor for documenting Business Rules /Validation of RulesInternal Team Coordination / Validating Recon processFunctional Specification document finalization (Business Rules, Data Mapping Business Logic, Reconciliation /Exception Rules, Completeness)Present findings to senior stakeholders on the data challengesSupport integration activities with FIS Balance-sheet manager solutionDefine entry/ exit criteria for SIT and UAT.Participate in creation of Test scenarios covering exceptions, DQ, recon, completeness, reports validation, business rules validation, data flow, adjustments and othersParticipate in creation of Test Scripts (iterative cycle)Validation of Test Results (iterative cycle)Support for Go Live / Support post go liveIdentify post live issues and support in resolutionDeveloping and supporting report development processesParticipate in data workshops to align data structures of key subsidiaries and international entitiesLiaison with subsidiary data, Risk, Finance and IT teams.Understanding subsidiary business rules and automation of business rules.Data discovery, Data cleaning activities related to subsidiaries.Data Testing related to subsidiaries.Validating Recon processProficiency in SQL, including complex queries, joins, subqueries, views, and performance tuning.Hands-on experience with PL/SQL procedures, functions, packages, cursors, triggers, and exception handling.Ability to analyze large datasets and troubleshoot data-related issues