by Surya Golagani | Feb 14, 2023 | Cloud Data Migration, Data Quality, Data Validation, Dataflow, DataOps, ETL Testing
Data profiling is a crucial step in the data management process, especially in the pharmaceutical industry where accurate and reliable data is essential for making informed decisions. Data profiling involves examining and summarizing the characteristics of a dataset... 
by Surya Golagani | Feb 14, 2023 | Cloud Data Migration, Data Quality, Data Validation, DataOps, ETL Testing
An Introduction to Query Builders Query Builder is a tool that allows users to create complex SQL queries without needing in-depth knowledge of the SQL programming language. This can be especially useful for those who are new to SQL or who need to generate complex... 
by Surya Golagani | Feb 14, 2023 | Cloud Data Migration, Data Quality, DataOps, ETL Testing, Snowflake
Introduction and Overview of ETL Testing ETL stands for Extract, Transform, and Load. It is the process by which data is extracted from one or more sources, transformed into compatible formats, and then loaded into a target Database or Data Warehouse. The sources may... 
by Surya Golagani | Feb 7, 2023 | BI Testing, Cloud Data Migration, Data Quality, Data Validation, DataOps, ETL Testing, OBIEE Testing
COBOL and Financial Institutes COBOL (Common Business-Oriented Language) is a programming language that was developed in the 1950s and remains in widespread use today, particularly in the finance and banking sectors. Many financial institutions still rely on COBOL... 
by Surya Golagani | Jan 17, 2023 | BI Testing, Cloud Data Migration, Data Quality, Data Validation, DataOps, ETL Testing
Data Warehouses provide a comprehensive view of data across many different sources, and proper analysis can encourage better business decisions and problem-solving. However, building and maintaining an effective data warehouse requires careful thought and... 
by Surya Golagani | Jan 9, 2023 | Cloud Data Migration, Data Validation, DataOps, ETL Testing
Complex Structural Hierarchical JSON and XML files Why are complex structural and deeply hierarchical JSON and XML files so difficult to validate? While most google searches for “JSON Validation” led to validation tools and articles that focus on...
