• Around 9+ years of experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse and Data and application integration solutions using Informatica Cloud and Informatica PowerCenter.• Extensive experience in the development of Batch and Real-time Integrations which fetch the data from various sources into Data Warehouses, Data Marts and different applications using APIs using Informatica Cloud, Informatica Power Center 10.2/9.6/ 9.1, SQL Server, Oracle 11g/10g and Netezza.• Developed Real-time integrations using Native connectors and APIs for endpoints such as Salesforce, OpenAir, Schoox, Cornerstone, Qualtrics etc.• Understanding the Business rules and requirements based on High-level specifications and implementing the data transformation as per the requirement.• Proficient in developing SQL using various relational databases such as SQL server, Oracle, MySQL etc.• Created UNIX shell scripts to automate various manual tasks resulting in the removal of manual intervention and reduction of effort.• Extensively worked on Informatica performance tuning involving source, target or mapping level bottlenecks.• Worked on implementation, analysis and tuning of complex SQL queries and integrated them with Informatica codes to drastically reduce the run time of workflows.• Strong business understanding of the Healthcare and Insurance Domain.• Extensive experience in working on projects which required flexible work schedules and stringent deadlines for deliverables.• Experienced in leading the operations team in maintaining the different ETL applications.