Priyanshu Shivhare

Project 1: Data Warehouse Development and Optimization

• Developed, tested, and deployed Informatica mappings and workflows for seamless data extraction, transformation, and loading processes from the data warehouse to various applications.
• Collaborated closely with business stakeholders to understand data requirements and translated them into effective ETL solutions.
• Monitored and optimized ETL processes, ensuring efficient data flow and minimal processing bottlenecks.
• Implemented and enforced quality assurance processes, including testing and validation, to ensure data accuracy and reliability.
• Troubleshooted and resolved technical issues, production incidents, or data-flow breakdowns in a timely manner to meet SLAs.

Project 2: Azure Synapse Data Warehouse Migration

• Led a pivotal role in migrating a data warehouse from Cognos Analytics to Azure Synapse, emphasizing seamless integration, scalability, and optimized performance.
• Architected and implemented a robust data warehouse in Azure Synapse, showcasing proficiency in cloud-based data engineering.
• Designed and implemented efficient data pipelines for seamless flow of data from diverse sources to the centralized data warehouse.
• Collaborated with cross-functional teams to integrate data seamlessly from multiple sources, ensuring standardized and consistent data formats for improved analysis and reporting.
• Implemented SQL optimization techniques within Azure Synapse, resulting in faster data retrieval and improved system efficiency.
• Designed the data warehouse architecture with scalability in mind, allowing for future expansion and adaptation to evolving business needs.

Key Achievements

• Successfully implemented Informatica mappings and workflows, ensuring efficient data flow and meeting SLAs in Project 1.
• Led the ground-up construction of a cutting-edge data warehouse in Azure Synapse, emphasizing scalability and optimized performance in Project 2.
• Implemented SQL optimization techniques, enhancing query performance and improving overall system efficiency.