Lalit Kumar Koli

• An IT professional with 3 years of total experience focusing on Data Warehousing, Teradata SQL, ETL Process.
• Hands on experience in performance analysis, monitoring Batch jobs and handling source steams or DSF issues.
• Hands on experience on code review and bug fixing.
• Knowledge of BTEQ, Fast Export, FAST Import, Fast Load, Multi Load, Tpump.
• Strong experience in Creating Database Objects such as Target Tables, Volatile tables, Views, Functions, Stored Procedures in Teradata.
• Responsible for Collect Statics on FACT tables
• Responsible for finding out areas where cleanup process can be implemented.
• Good knowledge of Teradata architecture with protection concepts like Fallback, RAIDs, and Journals.
• Worked on Data Stage tools like Data Stage Designer, Data Stage Director.
• Involved in the development of various transformation to load the data in slowly changing dimensions
• Experience with development, testing, debugging, implementation, documentation and production support.
• Understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.
• Worked extensively with Dimensional modeling, Data cleansing, ETL Processes for data warehouses.
• Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.
• Proficient expertise in Client interaction while resolving any issue or on any request.
• Organized and self-motivated with good decision making skills.