Varun N.

• Possessing 11+ years of IT experience in Planning and implementation of end to end data warehousing systems utilizing best practices from data Management areas • Having strong technical expertise in EDW, Active Load, Teradata Database and CLDM (Teradata Communication Logical data model). • Thorough understanding of Data Warehousing Architecture and Technology. • Strong technical expertise in optimizing Teradata System • Extensive knowledge of data warehousing and information management best practices. • Extensive experience in defining and rationalizing complex models within Teradata data warehousing environment. • Proficient in Teradata TD14.10 and previous Teradata versions. • Analysis, Design, Development and Implementation of ETL process using various Teradata utilities like TPT, BTEQ, FLOAD, MLOAD, TPUMP and FEXPORT and Informatica. • Experience in Reporting Analytical tool -Tableau. • Experience in Hadoop – Hive & HAWQ. • Expertise in Teradata SQL performance tuning. • Design, Developed & implemented reusable and generic components. • Experience in Python, UNIX shell scripting, Batch script, C/C++, and SQL. • Rich experience in CMM Level 5/CMMi Companies, implementing process compliance over the complete SDLC across industries like Retail industry. • Experience of Production Support and problem resolution in a 24*7 environment. • Design metadata solution framework. • Understanding of Teradata database features like – Temporal tables, Period data type, Improved collect stats performance, Table without NOPI, Character based partitioning, SQL based UDF, Enhanced Hashing algorithm, Query Banding, Soft RI, AJI’s, Multi-Level PPI, Geospatial, TMSM, Teradata Viewpoint etc • Worked in various capacities as designer, system analyst and Developer. • Experience in Requirement Gathering, Effort estimation. • Rich exposure to agile methodology, DevOps and software development life cycle SDLC. • Familiarity with Big Data Analysis, Sqoop.