Hands on experience with SQL 2005 /2008 Analysis services 2005/ 2008 or higher databases
Programming experience with Teradata 12 or higher
ETL Architecture exposure with SQL Integrations service 2005 or higher
Expertise in creating OLAP Cubes MOLAP, ROLAP and HOLAP using Star and snowflake Schema
MDX and Advance MDX language expertise
Strong RDBMS Concepts, Database Management Systems, Database Logical and Physical design, Data Warehousing Experienced in Data modeling, Database Architecture, Data Mapping, Table Normalization, De-Normalization, T-SQL Queries, DDL and DML.
Query optimization using clustered, non-clustered and Online Indexes.
Experienced in Importing and exporting data between homogeneous/heterogeneous systems using ETL (Extraction Transformation & Loading) tools such as DTS (Data Transformation Services) and SSIS (SQL Server Integration Services), Teradata Utilities (MLOAD, FLOAD,FASTEXPORT,OLELOAD,TPUMP) and SQL Loader.
Expertise in working with Excel reports with VBA programming skills and SSRS.
Working experience with C# and VB.NET to accomplish ETL tasks.