Arun Gilakamsetti

Experience

• 

  PwC Acceleration Centers

  Sept 2021 - now

  Role and responsibilities:-Performed Data mapping for SAP, PowerBI kind of Source reports to Target in Parquet, CSV etc formats. Constructed ETL pipelines in Azure Data Factory. -Built Data bricks notebooks to perform different transformation activities and cleaning activities. Maintained the Structured Data in Synapse Warehouse and worked on different warehousing queries. Worked on designing physical data models,(star schema). -Implemented all types of SCD in data bricks.-Developed CDC loads for around 20 dimension tables and 6 facts tables, which deal with around 50 GB of data per load. Show less Role and responsibilities:-Developed solution strategies and improved code functionalities for master data and EDW applications, collaborating with business and architecture teams. -Created and implemented components for the Program, ensuring high-quality and defect-free code. This included ETL Objects, BI Views, Historical dataloads, and TPT Scripts. -Reviewed the existing Informatica PowerCenter - Teradata pipeline jobs and designed the conversion to Informatica Cloud Data Integration (IICS) - Snowflake and ensured standards were being followed and quality was upheld. -Single-handedly owned API integration with IICS and coordinated with the client to approve the POC. Also became a go-to person in the project for all API mappings-related queries Show less

  • Associate 2 - Data and Analytics

    Jul 2022 - now

  • Associate - Data and Analytics

    Sept 2021 - Jul 2022