Manjula Vullemmagari

Develops ETL pipelines using PySpark scripts in AWS Glue to extract, transform, and load data. Performs comprehensive data validations to ensure data integrity and quality. Creates interactive KPI dashboards in AWS Quicksight to meet business requirements and enhance decision-making processes.

Responsibilities: -> Understand the business requirements and goals. -> Work with different entities data involved in a clinical trial-Sponsors, Investigators, Trials, Facilities etc. -> Worked on integrating data from different sources, transforming them according to the business requirements and loading them into the database tables. -> Perform Data Matering using the MDM tool Tamr. Tools Used: Azure Data Factory Azure Data Bricks Azure SQL Server Azure Synapse Tamr Palantir

Developed ETL mappings for loading large enterprise data using Informatica Power Center. Implemented Teradata utilities like BTEQ, MultiLoad,Fastload and created Fast Export scripts for loading and processing input data. Created and executed mappings using SCD Type 1, SCD 2. Designed the mastering logic for the enterprise data on Veeva Network (Masteringtool). Led the ADS design process, defining facts and dimensions for optimized data warehousing and reporting.