5+ years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for Banking, HealthCare and Retails domains.Exposure in writing SQL using analytical functions like Ranking, case statement etc., also in writing optimize SQL query using ORACLE 12c/11g/10g, SQL Server 2014/2017 and Teradata. Excellent experience in designing and development of ETL Methodology using Informatica Power Center 10.2, 9.6.1/9.1.1Interacted 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. Worked in Change Data Capture (CDC) Methodology using Informatica Power Center 10.x/9. xInteracted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.Worked extensively in design and analysis of Requirements, Development, Testing and Production deployment.Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary etc.Expert in writing SQL query using multiple databases like ORACLE, SQL Server, Teradata etc. Extensive knowledge of Informatica tuning and SQL tuning.