ODDULA JHAYA PAVAN KUMAR REDDY

Azure Data Engineer

Cognizant Technology Solutions•  February 2023 - Present•  India

Worked on migration of data from On-prem Oracle Database and File Systems to Cloud Databases (Azure SQL Database and Azure Synapse Serverless SQL pool). Extensive experience in creating pipeline jobs, scheduling triggers and mapping data flows using ADF, while also utilizing Key Vaults for credential storage. Utilized expertise in Azure Blob and Azure Data Lake storage to successfully load and manage data in Azure Synapse. Experience is RDMS concepts such as Tables, Indexes, Joins, Views, Stored Procedures, common table expressions (CTEs), Subqueries and temporary tables. Gained exposure to Python APIs while fixing and debugging reported issues. Managed security for SQL Server databases through user creation, role assignment, and permission delegation based on business needs. Utilized Visual Studio Code and Fast APIs to debug and modify Python code, enhancing overall API support. Developed and deployed the code to different environments using Azure DevOps CI/CD pipelines. Expertise in using Azure DevOps for code check-in, creating pull request and configuring build and release definitions.

Azure Data Engineer

Tata Consultancy Services•  July 2019 - February 2023•  India

Implemented a seamless process of extracting, transforming, and loading data from multiple source systems to Azure Data Storage services using Azure Data Factory along with SQL. Data Ingestion to one or more Azure Services like Azure Data Lake, Azure SQL Database and Azure Blob Storage. Designed efficient ETL workflows within ADF utilizing Linked Services/Datasets/Pipelines to extract, modify and store information from different databases including on-premise or cloud-based. Created and implemented JSON scripts to facilitate deployment of data processing pipelines in Azure Data Factory.