Reddy V Email and Phone Number

● Extensively used AWS Athena to import structured data from S3 into other systems such as RedShift or to generate reports.● Building use cases in snowflake by bring various sources using Attunity.● Migration of Hadoop solution to Snowflake platform. ● Used different AWS Data Migration services and Schema Conversion Tool along with Matillion ETL tool. ● Troubleshoot and maintain ETL/ELT jobs running using Matillion. ● Worked with Spark to improve the speed and optimization of Hadoop's current algorithms.● RDBMS as part of a Proof of Concept (POC) on Amazon EC2.● Migrated an existing on-premises application to AWS. AWS services, for example, EC2 and S3 were utilized for data set processing and storage. ● Used DBT to test the data (schema tests, referential integrity tests, customs test) and ensures data quality.● Used DBT to debug complex chains of queries. They can split into multiple models and macros that can be tested separately.

● Performed migration of several Databases, Application and Web servers from on-premises environments to Microsoft Azure Cloud environment.● Development level experience in Microsoft Azure providing data movement and scheduling functionality to cloud-based technologies such as Azure Blob Storage and Azure SQL Data base. ● Hands on experience in creating pipelines in Azure Data Factory V2 using activities like Move &Transform, Copy, filter, for each, Get Metadata, Lookup Data Bricks etc. ● Used Copy Activity in Azure Data Factory to copy data among datastores located on-premises and in the cloud. ● Created Python notebooks on Azure Databricks for processing the datasets and load them into Azure SQL databases.● Worked on advanced analytics using Python with Modules like Pandas, NumPy and Diplomate for data extraction, manipulation.● Used Azure Data Factory extensively for ingesting data from disparate source systems. ● Used Azure Data Factory as an orchestration tool for integrating data from upstream to downstream systems. ● Designed and Implemented pipelines in Azure Synapse/ADF to Extract, Transform and load Data from several sources including Azure SQL, Azure SQL Datawarehouse etc.

• Worked on Azure cloud platform services like HDInsight, DataLake, DataBricks, Blob Storage, Data Factory, Synapse, SQL, SQL DB, DWH, and Data Storage Explorer. • Extract Transform and Load data from source systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. • Ingested data to one or more Azure Services - (Azure Data Lake, Azure Blob Storage, Azure SQL DW) and processed the data in In Azure Databricks.• Developed data ingestion pipelines on Azure HDInsight Spark cluster using Azure Data Factory and Spark SQL and persist into Azure Synapse analytics.• Worked on Azure Data Factory to integrate data of both on-prem (MySQL, PostgreSQL, Cassandra) and cloud (Blob Storage, Azure SQL DB) and applied transformations to load back to Azure Synapse. • Worked on migration of data from On-prem SQL server to Cloud databases (Azure Synapse Analytics (DW) & Azure SQL DB). • Used Spark DataFrames to create various Datasets and applied business transformations and data cleansing operations using DataBricks Notebooks. • Developed Spark applications using PySpark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.

• Experienced working with big data, data visualization, Python development, SQL, and Unix.• Expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand trends and insights. • Handled high volume of day-to-day Informatica workflow migrations.• Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed.• Designed and implemented complex ETL data process using Informatica power Center and advanced SQL queries (analytical functions).• Created Informatica mappings using various Transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.• Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data and Business requirement gathering and translating them into clear and concise specifications and queries. • Prepared high-level analysis reports using Excel and Tableau. Provides feedback on the quality of Data including identification of billing patterns and outliers. • Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts and wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts) as well as gathered analytical data to develop functional

• Experienced working with big data, data visualization, Python development, SQL, and Unix.• Expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand trends and insights. • Handled high volume of day-to-day Informatica workflow migrations.• Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed.• Designed and implemented complex ETL data process using Informatica power Center and advanced SQL queries (analytical functions).• Created Informatica mappings using various Transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.• Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data and Business requirement gathering and translating them into clear and concise specifications and queries. • Prepared high-level analysis reports using Excel and Tableau. Provides feedback on the quality of Data including identification of billing patterns and outliers. • Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts and wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts) as well as gathered analytical data to develop functional