The candidate will be responsible in the development of MIS Reports such as Central Bank reports, Finance reports, Adhoc reports, department wise operations reports and Channel wise Performance reports, in addition to monitoring and maintenance of Daily ETL data Loading activity and Monthly Data Loading activity. Additionally the job holder is also responsible for daily and monthly data submission, monitoring and maintenance activities for Al-Etihad and Central Bank regulatory reporting.
KEY ACCOUNTABILITIES:
Fetching of data from various systems like Core Banking, Credit Card / Debit Card / SMS and other sub systems within the Bank and automate / maintain the same in SQL Server database using SSIS Packages.
Maintaining of Historical data for any MIS requirements.
Automation of daily & monthly data loading using SQL Server Stored procedures and jobs.
To generate / automate various strategic reports:
Business unit / branch wise operational reports
Central Bank reports automation
Branch Business Performance reports
Finance reports
P&L summary
Channel wise Performance reports
Ensure adherence to source control usage, development standards and SDLC procedures.
Ensure the following documentations are completed:-
Requirement
Technical
User Acceptance
Quality control
Troubleshoot and resolve technical issues, connectivity problems, including user access and component configuration.
Record and maintain hardware and software inventories, site and/or server licensing, and user access and security.
Work as a team member with other technical staff, such as networking, Database, UNIX and windows admin teams, to ensure proper functioning of the Data Warehouse test/production environments.
Write and maintain system documentation such as installation, trouble shooting, backup and recovery guide for applications.
Basic management of the various Oracle and SQL databases installed for the respective Database servers.
Manage changes by ensuring that problem management and change management procedures are adhered to and problems tracked to resolution
Update applications with necessary patches as and when applicable.
KEY SKILLS :
Good Communication skills
Leadership skills.
Problem solving and crisis handling skills in an efficient manner.
High commitment to work under pressure and self-motivation.
Minimum Experience:
Minimum 3 years of banking experience and 6+ years of IT experience with 3+ years of experience in Oracle PLSQL, Microsoft SQL Server reporting services (SSRS) and SQL Server Integration services (SSIS).
Strong understanding of BI architecture, BI tools and the technology.
Having GCC / UAE working experience is preferred.
Fields: BI & Analytics, MIS reporting, Oracle PL SQL