Ankit Goyal

Background

About Ankit Goyal

Data Solution Architect and Senior Project Manager having 15+ years of experience in the field of Data engineering, Data warehousing. He is proficient in Architecting Data Warehouse, Design and Development of Distributed Cloud systems, and building Business Intelligence platform. He is also expert in Project management, RFP submission, Resource Planning, Client Engagement, Application Design and Integration, Development, Vendor Reviews, and Support activities related to Enterprise level Data Warehousing & BI reporting. He worked on a variety of data management tools such as Azure Databricks, Azure Synapse (DB Storage), Informatica Cloud Services, Azure Data Factory, Informatica Power Center, Informatica Developer, Blob Storage, ADLS Gen2, Azure Cosmos database etc. He carries strong functional knowledge in many sectors such as Insurance, Real Estate, Banking and Financial Services, Automobile, Manufacturing, etc. He is proficient to source data from multiple data streams such as Salesforce, APIs, SQL Databases, Streaming sources, JD Edwards, Siebel, Workday, PeopleSoft, and many others. Azure Cloud Ecosystem: Azure Databricks, Cosmos DB, ADLS Gen2, Blob Storage, Provisioning of infrastructure, Azure Data Factory (Prelim) Informatica Tool: Extensively used Informatica Intelligent Cloud Services (IICS), most of the Informatica Power Center 10.1 Transformations, Informatica Developer, Power Exchange, Informatica Data Validation tool Data Modelling: Well versed with Data modelling and Data Warehousing Concepts like Relational modelling, Dimensional modelling, Fact & Dimension Tables, Fact- Dimension relationship, Star Schema, Snow-Flake Schema, Slowly-Changing dimensions, Physical and Logical Modelling. Data Governance: Analyzing data security, access control, data standardization, documentation, managing data lineage, and ensuring data availability to the end user based on specific business requirements. Project Delivery: Capable of code migration, delivering innovative solutions, presenting design solutions and code walkthrough to the stakeholders. He carries very strong analytical and communication skills.