Senior - Internal Audit

Job Description

JOB DESCRIPTION About KPMG in India KPMG entities in India are professional services firm(s). These Indian member firms are affiliated with KPMG International Limited. KPMG was established in India in August 1993. Our professionals leverage the global network of firms, and are conversant with local laws, regulations, markets and competition. KPMG has offices across India in Ahmedabad, Bengaluru, Chandigarh, Chennai, Gurugram, Jaipur, Hyderabad, Jaipur, Kochi, Kolkata, Mumbai, Noida, Pune, Vadodara and Vijayawada. KPMG entities in India offer services to national and international clients in India across sectors. We strive to provide rapid, performance-based, industry-focused and technology-enabled services, which reflect a shared knowledge of global and local industries and our experience of the Indian business environment. Skills and Expertise: The consultant should have expertise in the following: 1. Database design and management using PostgreSQL, MSSQL and Oracle. 2. Advanced SQL development, including writing efficient queries, stored procedures, and performance tuning. 3. PL/SQL programming for developing complex database Analytics functions and optimizing database performance. 4. Data modeling and normalization to ensure structured and optimized database schemas. 5. Query optimization techniques for improving database performance and reducing query execution time. 6. Indexing and partitioning strategies to enhance database efficiency and scalability. 7. ETL process development to extract, transform, and load data into databases. 8. Troubleshooting and debugging SQL queries to resolve issues related to data retrieval and integrity. 9. Database security and access control, including user permissions and role-based access management. 10. Integration of databases with applications, ensuring seamless data connectivity and interaction. 11. Proficiency in version control tools such as Git for managing database scripts and configurations. 12. Automating database processes using scripts for scheduled tasks and batch processing. 13. Experience in cloud-based database services such as Azure SQL Database or Oracle Cloud (good to have). 14. Strong communication and presentation skills to effectively convey technical concepts to stakeholders. Equal employment opportunity information KPMG India has a policy of providing equal opportunity for all applicants and employees regardless of their color, caste, religion, age, sex/gender, national origin, citizenship, sexual orientation, gender identity or expression, disability or other legally protected status. KPMG India values diversity and we request you to submit the details below to support us in our endeavor for diversity. Providing the below information is voluntary and refusal to submit such information will not be prejudicial to you. QUALIFICATIONS Minimum Bachelor of Engineering (BE) required