• Around 10 years of experience in Analysis, Architecture, Design, Development, Testing, Maintenance and User training of software application which includes support of various database technologies (SQL Server 2008/2012/2016 Azure Big Data, NoSQL, RDBMS and HDFS) environment.• Excellent experience in Data warehousing projects with extensive usage of Azure Services, ETL Reporting & Analysis services like SQL Server, SSIS, SSRS, SSAS, Power BI Desktop and Power BI Cloud.• Experience in Building cloud solutions with the Microsoft Azure HDInsight, Azure Data Lake Factory and Data Bricks in various projects.• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.• Experience in using Automation Scheduling tools like Autosys and Control-M• Excellent hands-on experience with data modelling tool like Erwin and strong knowledge of Relational and Dimensional database modelling concepts with star schema and snowflake schema’s design and implementation• Extensively worked SSAS Tabular Model Cubes and created dashboard reports using Power BI Desktop and worked on Static & Dynamic Row Level Security mechanisms in Power BI.• Extensive hands-on experience in executing Automation Testing tasks - automation testing requirements, prepared automation test scripts in Load Runner, running tests, monitoring/ analyzing results, collecting test metrics and conducting test reporting.Designed and implemented ETL workflows using Talend to integrate, migrate, and transform data fromvarious sources like databases, flat files, and cloud storage.• Experienced in Design and Setup of ETL solutions to meet Business needs using Informatica Power Centre platforms.