1) Decision support Systems and extensive experience in implementing
Full Life cycle Data Warehousing Projects.
2) Extensive experience in extraction, transformation and loading of data
directly from different heterogeneous source systems like flat files,
Excel, Oracle, SQL Server using ETL Tool (Enterprise Talend, Talend
Cloud) and Microsoft Azure services like Azure Data Pipelines, Azure
Data Factory and Data Lakes.
3) Designed DB schema, complex data model mappings in ETL Talend DI
to load the various sources into the Modern Data Warehouse, using
different transformations/ Stages.
4) Expertise in understanding data, data-flow, tuning existing mappings,
identifying performance bottlenecks, data integration at various stages.
Extensive experience in designing and developing jobs which are
dynamically scalable, fault tolerant, secure and reliable also proficient
in SQL, PL/SQL development.
5) Having the knowledge of Data warehousing concepts i.e. OLAP, OLAP
operations, OLTP, Schemas, Facts and dimensions