I Sowjanyareddy

Azure Data Engineer with 4+ years of IT experience across Azure data engineering, production support, and manual testing. Support 48+ production ADF pipelines, blending hands-on PySpark/SQL development with production monitoring, incident troubleshooting, and root-cause analysis. Strong background in Agile, cross-functional collaboration with BI and analytics teams, and secure credential management using Azure Key Vault.

Azure Data Engineer - Marathon Petroleum Corporation

(2023-09)

Development & Data Engineering and Production Support & Operations

• Diagnosed and resolved data processing failures in Azure Databricks notebooks by debugging and modifying PySpark and SQL transformation logic, restoring pipeline functionality with minimal downtime.
• Developed SQL-based validation, reconciliation, and data-quality-check logic to strengthen accuracy and consistency across critical data sets.
• Refined ELT logic to resolve recurring data load issues across development, testing, and production environments, partnering with BI and analytics teams.
• Sustained reliable, on-time ELT execution across 48+ production Azure Data Factory (ADF) pipelines by proactively monitoring and resolving failures before SLA breach.
• Reduced incident impact by analysing 5-10 production issues weekly, identifying root causes, and resolving ELT pipeline failures within SLA timelines.
• Monitored 5+ daily ADF-triggered jobs via automated email alerts, resolving failures to ensure uninterrupted batch processing.
• Coordinated with upstream data source teams, the Azure Synapse Analytics team, and downstream BI/reporting teams to troubleshoot dependencies and ensure end-to-end data availability.
• Authored operational documentation, troubleshooting guides, and runbooks that streamlined incident response for the support team.
• Configured secure secret and credential management using Azure Key Vault to support reliable pipeline connectivity.
• Safeguarded system stability by monitoring application health via Service Pulse and conducting root-cause analysis of failed integrations.

Manual Test Engineer - NFI Industries

(2022-02 - 2023-07)

• Performed end-to-end manual testing on logistics and transportation management system modules.
• Created, executed, and maintained test cases covering functionality, UI, and integration flows, and participated in defect triage meetings to prioritize and track issue resolution.
• Validated backend data using SQL queries to ensure consistency between reports and UI outputs.
• Supported UAT cycles, coordinating with developers and analysts to validate defect fixes.
• Executed regression and smoke testing prior to production releases to safeguard release quality.

Bachelor of Technology - B.Tech - St. Mary's Group of Institutions