In the age of technological advancements happening almost every minute, upgrading a business is essential to survive competition, offering a customer experience beyond expectations while deploying fewer resources to derive value from any process or business. Platform upgrades, software upgrades, security upgrades, architectural enhancements, and so on are required to ensure stability, agility, and efficiency. […]
Rajesh Ranga Rao
Rajesh has near 2 decades experience in managing data warehousing & data analytics BUs with ETL DEV/Support/Architect experience deploying DI/DQ/DG tools by adding value to BFS and healthcare clients offering data analysis, integration, transformation while ensuring data quality to facilitate business make informed decisions and improvise day-day business operations effectively using Performance tuning, Automations and Process Improvements.
Blogs from this Author
IDMC – CDI Best Practices
Every end product must meet and exceed customer expectations. For a successful delivery, it is not just about doing what matters, but also about how it is done by following and implementing the desired standards. This post outlines the best practices to consider with IDMC CDI ETL during the following phases. Development Operations Development Best […]
Azure SQL Server Performance Check Automation
On Operational projects that involves heavy data processing on a daily basis, there’s a need to monitor the DB performance. Over a period of time, the workload grows causing potential issues. While there are best practices to handle the processing by adopting DBA strategies (indexing, partitioning, collecting STATS, reorganizing tables/indexes, purging data, allocating bandwidth separately […]
SQL Server Space Monitoring
On Operational projects that involves heavy data volume load on a daily basis, there’s a need to monitor the DB Disk Space availability. Over a period of time, the size grows occupying the disk space. While there are best practices to handle the size by adopting strategies of Purge for outdated data and add buffer/temp/data/log […]
Windows Folder/Drive Space Monitoring
Often there’s a need to monitor the OS Disk Drive Space availability with the Drive holding ETL operational files (log, cache, temp, bad files etc.). Over a period of time, the # of files grows occupying the disk space. While there are best practices to limit the # of operational files and clear them from […]
SQL Tuning
In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]
Performance Tuning Guidelines – Informatica PowerCenter
Quite often, while building the Data Integration Pipeline, Performance is a critical factor. The factors below are vital for following the guidelines while working on ETL processing with Informatica PowerCenter. The following items are to be considered during ETL DEV: Pre-Requisite Checks and Analysis Basic Tuning Guidelines Additional Tuning Practices Tuning Approach Pre-Requisite Checks/Analysis Before […]