About

Lakshmi Pai is a highly skilled Lead Data Engineer with 9 years of hands-on experience in developing and maintaining data warehousing and ETL processes for various domains including Banking, Insurance, Petrochemicals, and FMCG. She has a strong background in designing Azure Data Factory pipelines to process large data files and has worked on various Azure services such as Azure Blobs, Azure Cosmos DB, Azure Data Factory, Azure Functions, Azure Stream Analytics, and Event Hubs. Lakshmi is an expert in implementing advanced SQL concepts like SCD1, SCD2, and has expertise in enhancing and deploying SSIS Packages from development server to production server. She has hands-on experience in database performance tuning, query optimization, backup, restore, index rebuilds, integrity checks, and security. Lakshmi also has strong knowledge of Power BI to import data from various sources such as SQL Server, Azure SQL DB, MS Excel, and Web. Lakshmi has developed POC using the latest technologies such as Azure Data Factory, Blob Storage, Snowflake DB, and Power BI. She is proficient in Core technologies such as Advanced SQL, Azure Data Factory, Azure Blobs, Azure Functions, Azure Stream Analytics, Event Hubs, SSIS, and SSRS. Lakshmi is also proficient in programming languages such as Python, C#, and PowerShell, and tools such as Power BI, OrgPublisher, and Snowflake. Currently, Lakshmi is working as a Lead Data Engineer at Brilio and has previously worked as a Senior Data Engineer - Azure at the same company. At Brilio, Lakshmi has provided a solution to detect fraudulent transactions in mobile banking channels with a fast and scalable big data pipeline approach. She has also built an HR data warehouse for the company and then built a hierarchy chart for reporting purposes. Lakshmi has also worked as a Senior Business Analyst at EXL, where she led a team to build an ETL data pipeline for analyzing and transforming data as per customer requirements to help them build data warehouses on the cloud. Lakshmi holds a Bachelor of Engineering (B.E.) in Computer Science from Vishveshwaraiah Technological University. She also holds a Class 12 degree in Physics, Chemistry, Mathematics, and Computer Science from Bharatiya Vidhya Bhavan, Kannur. Lakshmi has a diverse TechStack, including Azure, SQL, Data Engineering, ETL, Snowflake,