MAHENDER PEDDANOLLA
Hyderabad
Summary
Accomplished Data Engineer at TATA Consultancy Services, adept at optimizing ETL pipelines with Azure Data Factory and Informatica. Achieved a 30% reduction in job execution time while ensuring 99.9% data accuracy. Strong collaborator with excellent problem-solving skills, driving data-driven decisions across multiple projects. Proficient in Python and SQL for advanced data manipulation.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Engineer
TATA Consultancy Services
Hyderabad
10.2022 - Current
- Developed and optimized ETL pipelines using Informatica, ADF, and Azure Databricks, improving data availability and reliability.
- Swiftly identified and resolved data discrepancies to enhance data completeness and accuracy.
- Reduced ETL job execution time by 30%, enhancing analytics readiness for business units.
- Ensured 99.9% data accuracy across 20+ projects by leading quality assurance initiatives and implementing robust error handling.
- Collaborated with 20+ stakeholders to gather requirements and deliver solutions aligned with compliance and performance standards.
- Diagnosed and resolved data anomalies, enabling better reporting and data-driven decision making.
- Tools Used: Informatica, Azure Data Factory, Power BI
Education
B.Tech - Electronics and Communication Engineering
St. Martins Engineering College
Hyderabad09-2022
Skills
- Programming skills: Python and SQL
- Shell scripting in Unix
- ETL tools: Azure Data Factory, Synapse Analytics, Databricks, Informatica, IDMC, Apache Airflow
- Cloud solutions: Microsoft Azure and HDInsight
- Data storage: Azure Data Lake and Blob Storage
- Database systems: SQL Server, MySQL, Oracle DB
- Data modeling frameworks: Star schema and snowflake schema
- Visualization software: Power BI
Projects
Forecasting COVID-19 Patterns Using Data Engineering
Technologies: Azure Data Factory (ADF), Azure Data Lake (ADL), Blob Storage, SQL Server, Azure Databricks, HDInsight, Power BI
• Integrated data from various sources using Azure Data Factory (ADF) to facilitate comprehensive data transformation
• Conducted in-depth analysis of COVID-19 dynamics, enabling detailed insights into virus spread patterns
• Built data models and visualizations to inform precautionary measures based on analysis findings
Cybercrime Cell to Analyze Criminal Data
Technologies: Python, Tkinter, Machine Learning (KNN), Firebase
• Designed a K-Nearest Neighbors (KNN) based criminal detection system using real-time images
• Integrated state-wise crime analysis to identify regions with the highest crime rates using CSV data
• Utilized machine learning algorithms to enhance the accuracy of crime predictions and improve response strategies
Awards
On-the-Spot Award — TATA Consultancy Services,
Sep 2023, Nov 2023, Apr 2024, Oct 2024, March2025
Recognized for exceptional performance in project delivery, client engagement, and teamwork
Accomplishments
Designed and implemented an end-to-end Azure Data Factory (ADF) pipeline to orchestrate ETL workflows between on-premise SQL Server and Azure Data Lake Storage, enabling secure and scalable data ingestion, and reducing manual data movement efforts by 70%
Languages
Telugu
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Certification
- Microsoft Certified: Azure Data Engineer Associate* (In Progress)
Microsoft
Expected Completion: [November, 2025]
Timeline
Data Engineer
TATA Consultancy Services
10.2022 - Current
B.Tech - Electronics and Communication Engineering
St. Martins Engineering College
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Abhiram MedavarapuAbhiram Medavarapu
Assistant Manager at Ernst And Young GDSAssistant Manager at Ernst And Young GDS