Skip to main content

Rajesh Ranga Rao

Rajesh has over a decade and a half of experience in managing data warehousing & data analytics BUs with ETL DEV and support experience in banking and healthcare domains offering data analysis, transformation, and loading to support the BI requirements of the clients.

Blogs from this Author

Istock 1308640312

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 […]

cyber space, digital lines, data grid, rainbow lights

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 […]