Kiran Mudumbi

About Kiran Mudumbi

12+ Years of IT experience in Analysis, Design, Development, Testing and Implementation of Data warehouse applications Experience in building Data Warehouse/Data Marts using ETL Tool IBM Websphere DataStage and QualityStage 8.1/8.0.1, IBM InfoSphere Information Server 11.5/9.1/8.5/8.1, IBM WebSphere (Formerly Ascential) DataStage 7.5.2/7.0/6.0 (DataStage Enterprise Edition(PX) & Server Edition). • Experience in building Data Warehouse/Data Marts using Informatica Power Center 10.1.1/9.5/8.1, SSIS, SAP DSXi (BODS) ETL tools. • Developed pipelines in Azure Data Factory (ADF v2) to load Data Warehouse/DataMarts. • Experience integrating and using different Databases like Oracle 11g/10g/9i, DB2 9.0/8.0, Teradata 12.0/V2R6, MS SQL Server 2005/2008/2012, MYSQL into the Canvas Area. • Highly skilled in Planning, Designing, developing and deploying Data Warehouse / DataMarts. • Expertise in Forward/Reverse Engineering using Erwin. Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling. • Experience in integration of various data sources like Oracle, SYBASE, DB2, SQL Server, MS Access, Teradata and Flat files into the Canvas Area. • Worked with Oracle PL/SQL Stored Procedures, T-SQL, Table Partitions, Triggers, SQL queries, PL/SQL Packages, and loading data into Data Warehouse/Data Marts. • Knowledge in Dimensional Data Modeling, Fact and Dimensional Tables, Slowly Changing Dimensions. • Involved in designing and developing of Data Marts by following Star Schema and SnowFlake Schema Methodology. • Good communication and inter-personal skills, accustomed to work in a team environment.

Experience

1. Sr Data Engineer Azure Synapse Devops Data Vault

   3Cloud

   Nov 2021 — Present

Education

• Visveswariah Technological University

  Bachelor, Technology

• Texas A&M University-Kingsville

  Master's degree

  2007 — 2008