BUSINESS INTELLIGENCE - DATA WAREHOUSING - ETL


Business Intelligence - Data Warehousing - ETL - Reporting

Technology Expertise

Cloud Data Warehousing
  • Snowflake
  • Google BigQuery
  • Databricks
  • Amazon Redshift
  • Microsoft Fabric
  • Microsoft SQL Server databases, SSIS
  • Microsoft Azure Data Factory - ADF
  • Data Vault 2.0 automation in Snowflake database - Agile Data Engine (ADE)
  • Transition from the traditional on-prem tools to Agile, Real-Time Business Intelligence solutions in the Cloud
  • Data Warehouse automation - DataOps , optimization , best practices
  • Batch and Stream integrations (S3, Azure Blob Storage)
Tableau
  • Tableau Desktop and Tableau Server
  • Preparation of data sources (TDE extracts, TDS), integration with data virtualization tools and Big Data
  • Analysis, visualizations, dashboards, custom calculations
 Oracle data warehousing
  • Oracle optimization, tuning, pl/sql procedures
  • Data Vault modeling and implementation
ELT and ETL on-prem and in the cloud - Agile Data Engine, dbt, Datavault Builder, Azure Data Factory, Informatica PowerCenter, Pentaho, Microsoft SSIS and IBM Infosphere Datastage
  • Architecture and implementation of Data warehouse loads and interfaces
  • Big data integrations - loading cloud data warehouses (including real time), S3 integrations, Lambda
  • Data migrations and cleansing processes
  • Enhancements and migrations to the new versions
  • Tuning and repair - aligned with the RDBMS used by an organization
  • Custom coding - to handle company specific processing issues
  • Workshops, trainings, best practices and guides
 Salesforce
  • Data migrations and data integration processes (using Informatica PowerCenter ETL, Oracle, Pentaho Open Source, Apex Data Loader, Force.com Excel Connector)
Denodo data virtualization
  • Logical Data Warehouse engineering with Denodo data virtualization
Pentaho Open Source BI
    Pentaho as an end-to-end, cost-effective Business Intelligence information environment, which includes:
  • Pentaho Data Integration (PDI, Spoon) - ETL processes which control the data flow from source systems into a data warehouse
  • Dashboards and management cockpits - embedded into an informational portal
  • Dynamic multidimensional OLAP analysis and information delivery
  • Static, pixel-perfect reporting
 SAP
  • SAP Business Objects, Crystal Reports, SAP BW and Business Objects integration
 IBM Cognos BI
    Cognos Enterprise Performance Management solutions:
  • Cognos 8 and Cognos 10 Business Intelligence - metadata modeling with Framework manager, report and analysis design, Cognos Connection portal administration
  • Cognos PowerPlay and PowerPlay Transformer - powercubes modeling, optimization, automation