Surendar Kumar Amduri

Background

About Surendar Kumar Amduri

Having 10+ years of experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design. • Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation. • Excellent understanding of Data warehousing Concepts - SCD Type1/Type2/Type3, CDC, Dimension & Fact tables, Schemas (Star and Snowflake), Normalization and De-normalization. • Strong experience in using various ETL tools like Infosphere Information Server 11.7,11.5,9.1,8.1,7.5.2, Quality Stage,Pentaho Kettle 5.0.1 and Informatica Power Center 9.6.1 and 10.x • Experience in handling various source systems like DB2, Oracle, MS SQL Server, GreenPlum, XML and Flat files. • Experienced in developing Datastage parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort, Merge, Funnel, Remove Duplicate Stage). • Experience in creating complex Informatica mappings, sessions, workflows, reusable components in Designer, Workflow Manager using various transformations like Source Qualifier, Expression, Unconnected and Connected Lookups, Router, Filter, Aggregator, Joiner, Update Strategy, Stored Procedure, Rank, Transaction Control. • Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms, Table partitions, Sub-partitioning. • Expertise in developing advanced PL/ SQL, T-SQL code through various stored procedures, functions, cursors, triggers and materialized views • Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL. • Extensively worked on Linux commands and shell scripting based on the needs of the project and client requirements. • Worked on Client tools like HP Service Desk, Control M and PVCS Dimensions. • Extensive experience in Unit Testing, Functional Testing, System Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing. • Ability to meet deadlines and handle multiple tasks, flexible in work schedules. • Posse’s good communication and Presentation skills. • Worked on Waterfall,Agile and Scrum Methodologies. • Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle.