Harshitha Manam

Experience

1. Sr Azure Databricks Engineer

   Vanguard

   Jun 2022 — Present · PA, US

   Designed and developed an ELT process to move the data from OLTP to OLAP systems by using Oracle Data Integrator ODI.• Responsible for moving data migration from various external systems to Oracle database.• Implemented data discovery and data mapping strategies.• Managed user roles and permissions to maintain data security and privacy within the Collabra platform.• Designed and implemented data pipelines using Azure Data Factory for ETL processes.• Developed and maintained Python scripts for data analysis and automation, improving efficiency.• Worked on integrating multiple data sources for BI Reports using Pentaho Data Integrator.• Integrated data from multiple sources to create comprehensive Tableau reports.• Conducted data cleaning, pre-processing, and transformation to prepare datasets for machine learning models.• Experienced in writing complex SQL queries for data extraction, transformation, and loading (ETL) processes.• Responsible for taking the backup of the database of the database, cloning of database and maintenance.• Extensively used RMAN, exp db/imp db functionality take the backup of the database.• Utilized Azure Data bricks for big data processing and analytics.