ETL

AWS ETL
Building data warehouse in Redshift. Visualizations in Power BI
  • integrate data sources in SQL server
  • ETL and integrate SQL Server data with non SQL data with Qlik Sense scripting
  • use Qlik Sense Set Analysis when necessary
  • develop visualizations and publish for self serve

 

 

Data sources various divers SQL Server systems
  • integrate data sources in SQL server
  • ETL and integrate SQL Server data with non SQL data with Qlik Sense scripting
  • use Qlik Sense Set Analysis when necessary
  • develop visualizations and publish for self serve
RSAETL
RelianceNew
Moving to a new Billing platform
  • find out which tables matter
  • find out how tables are connected
  • code ETL in native Progress for migration
  • code ETL for SQL data warehouse
  • code ETL for data not connected to system
Replace datasource completely
  • Mapping data from various IBM to the SAP data
  • Identify the most important elements
  • eliminating data and calculations no longer needed
  • simplifying the system as much as possible
  • Loading and cleaning incoming data
  • write front end routines that converted the new data 
  • minimally change the existing application
IBM2