Kundan Kumar

Experience

• 

  Bhuvan Care Services Private Limited

  Feb 2019 - Jul 2021

  BI Consultant

  1. ETL Production Support - Monitor Informatica ETL workflows, ensuring smooth execution and resolving failures.2. Data Validation and fixing DQ issues in prod env.3. Improve SQL queries and ETL processes for performance.4. Maintain records of ETL, DWH, and Unix scripts.5. Working in both Automation and Manual components of the project.6. Automating the Manual Test cases and their execution.7. Defect Logging and retesting, Defect Tracking using JIRA.8. Worked on Backend testing and has a good knowledge of writing SQL Queries to verify the data.9. Used the TOAD application for running queries on DB and validating data. Show less

• 

  Future Focus Infotech Private Limited

  Aug 2021 - Sept 2022

  Data Engineer

  1. Managed and optimized data integration processes across various platforms, including Power BI, Azure, and Azure Data Factory (ADF)2. Developed, maintained, and enhanced Power BI reports and dashboards, improving data visualization and business insights. 3. Data Validation and fixing DQ issues in prod env.4. Improve SQL queries and ETL processes for performance.5. Maintain records of ETL, DWH, and Unix scripts.6. Ensured data quality and consistency within the Data Warehouse, performing rigorous SQL-based validation and troubleshooting.7. ETL Production Support - Monitor Power BI ETL workflows, ensuring smooth execution and resolving failures. 8. Automating routine tasks using Unix scripting, optimizing ETL workflows9. providing comprehensive support to users for data-related queries, report issues, and system performance, driving overall efficiency and reliability of the data ecosystem. Show less

• 

  Broadridge

  Oct 2022 - now

  Senior Data Engineer

  1. Architected and implemented robust data solutions using Snowflake, Databricks, Azure, AWS, and Big Data Hadoop.2. Led complex data projects from inception to delivery, focusing on scalability, performance, and reliability.3. Developed and optimized scalable data pipelines within the Hadoop ecosystem, enhancing data flow and storage.4. Implemented and optimized data warehouse solutions on Snowflake, ensuring efficiency and high performance.5. Helped customers leverage Snowflake storage and retrieval solutions, providing expert guidance on Snowflake best practices.6. Managed ETL/ELT processes to extract, transform, and load data from various sources, ensuring data integrity and consistency.7. Designed and implemented data models while collaborating with cross-functional teams to gather requirements and optimize performance for data-driven applications.8. Optimized and maintained data infrastructure on Azure, ensuring reliability, security, and performance.9. Developed scalable, production-ready data integration and processing solutions, with a strong focus on data management and warehousing concepts.10. Hands-on experience with Snowflake utilities and advanced features like virtual warehouse sizing, query performance tuning, Zero Copy Clone, and Time Travel.11. Executed end-to-end Snowflake cloud data warehouse implementations and managed data migration from on-premises systems (RDBMS or NoSQL).12. Collaborated with cross-functional teams to deliver data-driven insights that align with business objectives.13. Mentored junior engineers, conducted code reviews, and provided technical leadership to enhance team capabilities.14. Implemented best practices for data governance, compliance, and quality assurance.15. Continuously evaluated and adopted emerging technologies to improve data processing and drive innovation. Show less