Internal Audit:Auditor

About Internal Audit

Internal Audit function of the Bank, operates independently under the supervision of the Audit Committee of the Board and is responsible for providing an independent view to the Board of Directors and Senior Management on the quality and efficacy of the internal controls, risk management systems, goverce systems and processes in place on an on-going basis This is provided to primarily ensure that the business and support functions are in compliance with both internal and regulatory guidelines

The Audit Intelligence Unit is responsible for driving technology transformation within the Internal Audit Department (IAD) by leveraging data analytics, automation, and advanced tools to enhance audit effectiveness, coverage, and efficiency The unit acts as a central hub for audit data engineering, control test automation, data analysis and automation

1 Control Test Automation

Develop SQL scripts for anomaly detection and audit observations

Conduct UAT and deploy scripts into production with backup in Bitbucket

Manage lifecycle activities: rerun, modification, addition, and retirement of tests

2 Audit Data Layer Management

Design and maintain a unified data layer integrating data from various business databases including Oracle, MS SQL, MySQL, and Big Data Lake (BDL)

Develop and monitor data pipelines using Informatica, Linux, Python, and SQL Developer

Rationalize data tables and manage SQL server space and procedures

3 Self-Service Portal Development

Build and maintain the Self- Service Portal for report dissemination

Integrate SQLs and automate report issuance based on defined frequencies

4 BOT Framework Management

Operate and enhance monthly BOTs for concurrent audits

Expand BOT coverage to new processes and improve efficiency

5 Advanced Analytics & Visualization

Apply process mining, machine learning, and AI to audit workflows

Develop dashboards for senior management and audit verticals

6 Goverce & Compliance

Support external and internal reviews to validate audit test integrity

Ensure alignment with RBI guidelines and internal change management protocols

Qualifications

Engineering degree in IT related area

Certifications in SQL, Python, Informatica, Data Analytics and Data Visualisation tools

Role Proficiencies:

For successful execution of the job, a candidate should possess the-
Knowledge of database architectures
Experience in SQL, Python, Informatica and Data Visualisation tools
Good communication (both verbal & written) and inter-personal skills

Ability to prioritize and make decisions in a fast-paced environment
Ability to manage multiple tasks/projects and deadlines simultaneously

Ability to manage risk and uncertainty for self and team within a dynamic priority-setting environment