Provide On premise & Cloud data architectural solutions/designs to project execution teams for implementation.
•    Design & Architect MS SQL Database Management Solution - MS SQL Server DB, SSIS ETL, SSRS Reporting Services and Power BI
•    Provide architectural assessments, strategies, and roadmaps for data management
•    Architect & design data migration patterns from RDBMS to cloud data warehouse
•    Own and aggressively drive forward specific areas of AWS technology data architecture. This includes data management architecture involving batch, micro batch, and real time streaming of data in both cloud and on premises solutions
•    Design knowledge of data modelling, ELT, MS SSIS / ADF ETLs, Spark & Python along with Strong SQL knowledge and strong DWH and ETL concepts
•    Support multiple Agile Scrum teams with planning, scoping and creation of technical solutions for the new product capabilities, through continuous delivery to production.
•    Liaise with the delivery team and clients for res