Data Engineer - ETL - Data Warehousing Specialist
Resume:
HEMANTH YALAGANDHULA
Data Engineer
*******************@*****.***
USA
linkedin.com/in/hemanth-yalagandhula
Career Overview
A passionate individual with 2 years' of experience working in the IT sector. Looking for a job while employed at TCS as an ETL
developer. Data analysis, data cleansing, and client requirements collection are among the primary abilities. Demonstrated ability for
picking up new software and products fast.
Skills
SQL
MSEXCEL
Data Analysis
Java Script
JS7 Jobscheduler
Putty
ANSYS SOFTWARE
LINUX
ETL
Data Warehousing
HTML
Winscp
Tableau
AUTO CADD
UNIX
Work Experience
Tata Consultancy Services (TCS)
Project: HOBS – Converge Network, Philippines
Role: Data Engineer /Data Migration Engineer
03/2022 – 03/2024
GUJRAT,INDIA
Project Overview Core Responsibilities & Contributions Contributed to the HOBS RMS implementation for a telecom client by supporting large-scale data migration, ETL development, billing validation, and production readiness across multiple environments. Worked closely with RMS, Billing, and Operations teams to ensure data accuracy and seamless Go- Live execution.
ETL & Data Engineering
•Designed and implemented robust ETL pipelines using Pentaho Data Integration (PDI) to migrate high-volume customer, billing, product, and usage data from legacy systems into the HOBS RMS platform.
•Optimized ETL workflows by improving job sequencing, transformation logic, and data validation checks, reducing migration defects across multiple cycles.
•Built reusable transformations and parameterized jobs to support incremental loads, re-runs, and environment-specific configurations (DEV, SIT, Pre-Prod).
•Worked on ETL pipelines and data migration processes supporting Data Warehousing systems, ensuring accurate transformation and loading of telecom billing and customer data.
•Applied data quality rules including null checks, referential integrity validation, duplicate detection, and data standardization before loading into target systems.
•Performed source-to-target reconciliation using SQL queries to validate record counts, financial totals, and billing accuracy post-migration. Data Validation & SQL Analysis
•Used complex SQL queries (joins, aggregations, subqueries) to validate migrated data, identify mismatches, and ensure consistency between legacy and RMS systems.
•Conducted financial data reconciliation to verify invoices, outstanding balances, bill cycles, and charge calculations prior to production release.
•Supported defect analysis by performing root cause investigations for data truncation, incorrect mappings, transformation errors, and missing records. RMS & Billing Validation
•Created and executed end-to-end order-to-billing test scenarios across DEV, SIT, and UAT environments for SME, Residential, and Enterprise customers.
•Configured and validated plans, packages, add-ons, bill cycles, and payment rules to ensure correct rating and invoicing behavior.
•Collaborated with functional and billing teams to validate post-migration billing flows, minimizing production defects during Go-Live. CI/CD & Deployment Support
• Supported CI/CD pipeline activities for ETL deployments across DEV, SIT, and UAT environments.
• Assisted in continuous integration and deployment of ETL workflows.
• Automated deployment tasks using Linux shell scripts and scheduling tools.
• Monitored pipeline execution logs and resolved failures. • Performed post deployment validation using SQL queries and reconciliation checks. Excel-Based Data Analysis & Reporting
•Used Microsoft Excel to perform large-scale data validation and reconciliation for customer, billing, and product datasets during migration cycles.
•Analyzed Customers transactional and billing data using Pivot Tables to identify mismatches, duplicates, and data inconsistencies.
•Applied advanced Excel formulas such as VLOOKUP/XLOOKUP, INDEX- MATCH, IF, SUMIFS, COUNTIFS, and TEXT functions to cross-verify source vs target data.
•Built reconciliation dashboards using Pivot Charts to track migration accuracy, billing totals, and defect trends across environments.
•Performed data cleansing using filters, conditional formatting, and data validation rules to standardize migrated datasets. Automation, Linux & Monitoring
•Developed Linux shell scripts to automate ETL job execution, file handling, directory cleanup, and pre/post-migration activities.
•Integrated ETL jobs with JS7 Job Scheduler to orchestrate workflows, manage dependencies, and monitor execution status.
•Actively monitored ETL and RMS batch jobs, analyzed logs, and performed timely failure recovery during critical migration windows. Go-Live & Production Support
•Supported multiple mock migrations, dry runs, and final Go-Live activities, ensuring complete and accurate data loads.
•Provided production and post-Go-Live support, resolving high-priority data and billing issues under tight timelines.
•Maintained strong coordination with cross-functional teams to ensure zero business disruption during customer onboarding and billing cycles. Education
Master of Science, Technology Management, LINDSEY WILSON UNIVERSITY 01/2024 – 08/2025 Columbia, KY
Bachelor of Technology (B.Tech), Mechanical Engineering, ACE ENGINEERING COLLEGE
08/2018 – 09/2021
Hyderabad
Diploma, Mechanical Engineering, TDR POLYTECHIC COLLEGE 08/2015 – 05/2018 Hyderabad
Secondary School Certificate, 10th Class, EVEREST HIGH SCHOOL 03/2015 Hyderabad
Certifications
Best Employee Award 2023 in
Hobs Project
Star Employee of Completing
5GO-LIVES
Certification of completing
SQL in QJ SIDERS
Contact this candidate