Default profile banner
KK

Kunwar Gaurav Katal

@kunwargauravkatal

Sr Database engineer at Chandigarh University

Pathankot, Punjab

linkedin.com/in/kunwar-gaurav-katal-7211ba14b

Chandigarh UniversityLPU University

Kunwar Gaurav Katal is a Database Engineer and ETL Tester with over 2 years of experience in designing, implementing, and maintaining robust database systems. He specializes in optimizing database performance, ensuring data integrity, and developing comprehensive backup and recovery procedures. His expertise includes performing detailed ETL testing using tools like Informatica and SSIS, troubleshooting performance bottlenecks, and ensuring compliance with data security regulations. He is skilled in collaborating with cross-functional teams to deliver solutions that meet complex business requirements.

Experience

Sr Database engineer

Chandigarh University

Full-time•Mar 2023 - Present•Chandigarh

Designing and developing the database architecture for the LMS, ensuring data availability, integrity, and security. Responsibilities include developing data models, implementing data governance policies, performing regular data backups, and optimizing database performance. Also worked as Data Analyst, creating reports in Power BI, and monitoring DB monthly backups for ERP Team.

Quality Analyst (ETL)

Advanze Technologies

Full-time•May 2022 - Feb 2023

Working on data reconciliation and system upgrades, including creating Root Cause Analysis (RCA) and running daily data reconciliation jobs. Led QA efforts, managing and mentoring the QA team, and ensuring the quality and reliability of software products.

Senior Analyst QA,(EE)

HBC

Full-time•Jan 2018 - Feb 2019

Monitored mainframe jobs and managed Informatica upgrades. Supported test activities for Point of Sale requirements, developed test strategies and plans, and utilized SQL to evaluate test results and verify database integrity.

Software Tester(ETL)

Technosoft Pvt Ltd

Full-time•Aug 2017 - Jan 2018•Bangalore

Analyzed data flow and helped developers develop complex SQL queries. Performed testing activities, including functional, integration, regression, and performance testing, to ensure data integrity. Mapped staging tables and analyzed source system architecture.

Education

LPU University

Bachelor of Technology

Jan 2012

Skills

Database Management Systems (DBMS): Oracle, Microsoft SQL Server, MySQL, Postgre
SQL Programming and Query Optimization
Data Modeling and Schema Design
Database Backup and Recovery Procedures
Database Performance Tuning and Optimization
Database Security and Compliance (GDPR, HIPAA)
ETL Tools (Informatica, SSIS)
Cloud-based Database Services (Amazon RDS, Google Cloud SQL, Azure SQL Database)
NoSQL Databases (Cassandra, Couchbase, Redis)
Database Monitoring and Diagnostics (Oracle Enterprise Manager, Nagios, Splunk)
ETL/DWH Testing
Test Management Tools (HP ALM, JIRA, AzureDevops, TFS)
Business Intelligence Tools (SAP BO, POWER BI)