KHANAL

About KHANAL

• Over 7+ years of IT experience with expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using ETL tools with RDBMS like Oracle, MS SQL server, Teradata, DB2 and PostgreSQL on Windows and UNIX platforms. • Strong experience in Informatica Cloud, PowerCenter10.0/9.x/8.x and PowerExchange 10.0/9.x/8. x. • Worked on multiple Data Synchronization using Informatica Cloudlike Cloud application to cloud application, On-premise application to cloud application and On-premise application to on-premise application. • Data integration with SFDC and Microsoft Dynamics CRM using Informatica cloud. • Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support. • Strong experience with Informatica tools using real-time CDC (change data capture) and MD5. • Experience in integration of various data sources like Oracle, Teradata, Mainframes, SQL server, XML, Flat files, JSON and extensive experience on Oracle, Teradata and MS SQL Server. • Very strong in Data Warehousing Concepts like Dimensions Type I, II and III, Facts, Surrogatekeys, ODS, stagingarea etc. • Realistic understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling. • Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch. • Expert in writing complex SQL queries, PL/SQL and optimizing the queries in Oracle, SQL Server and Teradata also excellent in working with Views, Synonyms, Indexes, Partitioning, Database Joins, stored procedure, Stats and Optimization. • Well-versed in tuning Teradata ETL queries, remediating excessive statistics, resolving spool space issues etc. • Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets. • Experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load. • Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects. Heavily created mapplets, user defined functions, reusable transformations, look-ups. • Technical expertise in designing technical processes by using Internal Modeling &working with Analytical Teams to create design specifications; successfully defined &designed critical ETL • processes, Extraction Logic, Job Control Audit Tables, Dynamic Generation of Session Parameter File, File Mover Process, etc. • Expertise in Teradata utilities like Multi Load, Fast Load, Fast Export, BTEQ, TPUMP, TPT and tools like SQL Assistant, Viewpoint • Expert in T-SQL coding and testing: functions, views, triggers, cursors, dictionary, stored procedures etc. • Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring. • Skilled in creating & maintaining ETL Specification Documents, Use Cases, Source to target mapping, Requirement Traceability Matrix, performing Impact Assessment and providing Effort estimates, deployment artifacts • Worked with UNIX shell scripts extensively for job execution and automation. • Deftly executed multi-resource projects following Onsite Offshore model while serving as a Mentor for the Junior Team Members • Strong Knowledge of Hadoop Ecosystem (HDFS, Hive, Hdfs, Impala, Hue, etc.) • Exposure of end to end SDLC and Agile methodology. • Good communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.