Thulasinath Sompally

• Working on analysis and creation of architecture, design, and specification document. • Involve in setting up Talend and Snowflake Cloud data warehouse environment for Lasalle AM, EMEA, and APAC regions. • Working as a Snowflake architect and SME, responsible for user access control and create database, virtual warehouse, functional roles, access roles, resource monitor, policies, tasks, streams and zero-copy clones. • Create Talend jobs to migrate data from SQL server(on-premise), PostgreSQL to Snowflake

• Involved in analysis, creation of design and specification document. • Created SSIS Packages to extract data from on-premise Database and load into Lookups, Dimensions and Facts on Azure SQL Warehouse and Data Lake Gen2. • Created Semantic layer, Stored Procedures and Views to process calculated and aggregated data for better Visualization to Business Users. • Deployed and scheduled SSIS Packages on Azure Data Factory using Azure Integration Runtime Service and support the deployed code.

• Involved in understand the Business requirements, Design and Develop Informatica powercenter mappings, sessions and workflows logics according to requirements. • Developed Mappings and Workflows schedule to process Real-time, Batch Data. • Developed Mappings and Workflows to read data from Oracle, SQL Server, Mainframe, CSV and IBM MQ Sources to generate Target XML and Flat File data. • Involved in production support, performance tuning of Mappings and Workflows to improve the data load performance.