Sumisha uppal's Linkedin Analytics

Above 5 years of IT experience with expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems using ETL tools Informatica PowerCenter with RDBMS like Oracle, MS SQL server, MySQL. Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation. Good experience with Informatica tools using CDC (change data capture). Experience in integration of various data sources like Oracle, SQL server, Flat files. Exposure in writing SQL using analytical functions like Ranking, case statement etc., also in writing optimize SQL query. Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.2, 9.6.1/9.1.1 Interacted with end-users to identify and develop Business Requirement Document (BRD) and transform it into technical requirements. Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica. Expert in writing SQL query using multiple databases like ORACLE, SQL Server, MySQL etc. Experience in integration of various data sources into staging area. Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources. Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it. Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica. Good understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling. Experience in integration testing, supported User for UAT testing. Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Created debugging and performance tuning of sources, targets, mappings, transformations and session. Hands on experience working on Waterfall Model as well as Agile Model.