Viswanath Reddy P
Bangalore
Summary
Seeking a challenging role in a dynamic organization to leverage expertise in Data Engineering & Cloud Data Engineering, driving business intelligence and analytics initiatives.
Possessing 5 years of experience in the IT industry, focusing on Azure Data Engineering, SQL Database Administrator. Worked as Azure Data Engineer at Infosys for Client ExxonMobil. Proficient in designing scalable and efficient data solutions on Azure, comprehending functional requirements from business stakeholders, and collaborating with cross-functional teams to achieve project goals effectively. Liaised with data architects and stakeholders to design and implement scalable and high-performing data architecture in the cloud. Skilled in developing data ingestion and transformation pipelines using Azure Data Factory, Azure Databricks, and other relevant tools, extracting data from diverse sources, and performing data cleansing, transformation, and enrichment to prepare it for analysis. Demonstrating strong problem-solving abilities, analytical skills, and excellent communication and interpersonal skills, essential for effective team leadership and collaboration.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Infosys
12.2022 - 11.2024
- Collaborating with a team of data engineers to design and implement robust data solutions on the Microsoft Azure platform, ensuring alignment with business objectives and stakeholder requirements
- Collaborating with business stakeholders to understand functional requirements and translating them into scalable data solutions, leveraging appropriate Azure services and components
- Designing and developing data pipelines using Azure Data Factory, Azure Databricks, Azure Data Gen 2, Azure Key vault, Logic App, and other relevant tools, ensuring efficient data ingestion, transformation, and enrichment processes
- Extracting data from diverse sources, performing data cleansing, transformation, and enrichment to ensure data quality, and implementing data governance practices to ensure compliance and data security
- Optimizing data solutions for performance and scalability, providing technical guidance and support to team members, and staying updated with emerging data technologies and trends
- Developing and managing data ingestion processes to collect data from various sources, such as databases, APIs, streaming platforms, and external systems, and load it into the cloud-based data storage systems
- Creating and maintaining data models that provide efficient access to structured and unstructured data for analytical purposes
- Ensuring data quality, accuracy, and consistency by implementing data validation checks & establishing data governance practices, such as data lineage tracking, data cataloging, and access control
- Implementing end-to-end data pipelines using Azure Data Factory, managing on demand clusters, and establishing link services between data sources and destinations, ensuring seamless data flow and integration
- Setting up and managing Databricks clusters, using Python notebooks to perform data transformations from raw to refined data, and facilitating knowledge transfer to new team members and supporting existing team members in adapting to upcoming changes in the data engineering environment
Senior System Analyst
Infosys
Bangalore
11.2019 - 12.2022
- Proficiently administered SQL Server databases in production environments, spanning versions from 2008 to 2019 SQL Versions
- Expertise in end-to-end SQL Server deployment, migration, patching, troubleshooting, optimization, and maintenance, implementing High-Availability (HA) and Disaster Recovery (DR) solutions for uninterrupted data
- Installed, maintained, and configured SQL Server, SSIS, and SSRS installations for both production and non-production environments
- Successfully executed migration of SQL Server Databases from on-premise infrastructure to Azure Cloud and Managed instances, enabling enhanced scalability and cost-efficient
- Configuring and managing SQL Server High-availability data solutions Log shipping, Mirroring, Replication and Clustering, Always ON
Education
B.tech - Civil Engineering
MeRITS
Nellore06-2017
Skills
- Data/Cloud Data Engineering
- Azure Data Factory
- Azure Databricks
- Azure Data Lake
- ETL Processes
- PySpark
- SQL
- Azure Storage Services
- Azure Storage Explorer
- Service Now
- Azure Key Vault
- Commvault Backup Tool
- Azure SQL Database
- Azure Managed Instance
- Azure Logic Apps
- ON-Prem SQL Database Admin
Certification
- Databricks Accredited Lakehouse Fundamentals
- Databricks Accredited Generative AI Fundamentals
Languages
- English
- Telugu
Personal Information
Date of Birth: 20/07/1996
Timeline
Infosys
12.2022 - 11.2024
Senior System Analyst
Infosys
11.2019 - 12.2022
B.tech - Civil Engineering
MeRITS