Rajesh Nallamothu

Data Engineering Bi Consultant @Manulife

Waterloo, ON, CA

Designed and implemented end-to-end data pipelines using Azure Data Factory (ADF), Databricks, and PySpark, improving data processing efficiency and scalability.Migrated legacy databases to cloud-native architectures like Azure Synapse and Snowflake, enabling seamless integration and enhanced performance.Developed and optimized complex ETL workflows using SSIS and ADF, ensuring reliable and efficient data transformation processes.Engineered robust data validation and cleansing processes to improve data quality and consistency across workflows.Created interactive Power BI dashboards with advanced DAX queries and predictive analytics, providing actionable insights for stakeholders.Configured real-time data ingestion pipelines using Azure Event Hub, enabling streaming analytics and rapid decision-making.Architected dimensional models using Star Schema and Snowflake Schema techniques, enhancing data accessibility for business intelligence applications.Implemented machine learning models for predictive maintenance and optimization using Python, driving operational efficiency and cost savings.Automated CI/CD workflows with Terraform, Azure DevOps, and CloudFormation, ensuring consistent deployment and testing.