Mayur Kastiya

About Mayur Kastiya

Experienced professional with 8+ years of expertise in delivering innovative IT solutions, and optimizing processes through data analysis and system integrations. Skilled in leveraging advanced technologies like Snowflake and Databricks to design scalable architectures and streamline operations. Adept at collaborating with cross-functional teams and stakeholders to ensure seamless project delivery and alignment with business objectives.A certified professional passionate about continuous learning and growth - dedicated to upskilling, expanding my portfolio, and building a strong and impactful career.Hard Skills - Snowflake, Databricks, Python, SQL, DBT, Power BI, Jira, Trello, BitBucket, Microsoft ExcelGithub account - https://github.com/mkastiya

Experience

1. Senior Technology Consultant

   EY

   Apr 2024 — Present · IN

   As a Data Engineer for a Financial Planning and Analysis project in the private equity sector, I contributed to building robust data solutions to support business decision-making:• Developed a centralized, multi-dimensional, self-service data model that streamlined reporting and analysis, enabling faster and more informed decision-making for finance and sales teams.• Conducted in-depth analysis of source systems and tables, creating detailed system blueprints and source-to-target data mapping to ensure accurate data flow.• Designed and implemented Snowflake data structures, including tables, views, and stored procedures, and developed Informatica IICS integrations to populate and manage data pipelines.• Created Logical Data model and data mapping designs. Performed data cleansing to ensure data accuracy, consistency, and reliability, improving overall data quality for analysis.• Participated in user acceptance testing (UAT), and reconciliations to validate data accuracy and ensure seamless solution deployment.

Education

• Jaipur National University

  Bachelor of Technology (B.Tech.), Computer Science

  2013 — 2017