• Over 9 years of IT experience in ETL Architecture, Development, Enhancement, Maintenance, Production support, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses.• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.• Strong skills in Data Analysis, Data Requirement Analysis, Data Modeling (Physical)and Data Mapping for ETL processes.• Hands on experience using Informatica Power Center 9.x, Oracle, Hive, DB2 and Unix Shell Scripting.• Expertise in Developing Mappings, Define Workflows and Tasks, Monitoring Sessions, Export and Import Mappings and Workflows and Backup, Recovery.• Experience in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, Oracle, DB2 and SQL Server.• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, Transaction Control, Java and update strategy.• Analyzed, designed and implemented Data warehouse, Data marts and operational databases• Expertise in designing Power BI desktop reports and Power Builder paginated reports.Experienced handling OBIEE reports.• Extensively Implemented Error Handling Concepts, SCD(Type I , II, III),IV, CDC, Historical Load ,Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. • Expertise in doing the RCA (Root Cause Analysis).• Strong skills in analyzing the database design, Coding using SQL and PL/SQL, Oracle 10g/11g, SQL Server, and Sybase database applications. Coded Stored Procedures, Packages and Triggers using PL/SQL.• Experienced working on GitHub repository, Jenkins Pipeline,UDeploy component,Splunk• Experienced setting up Azure infrastructure and application in different environment and good understanding on azure fundamentals