Telecom ETL & KPI Calculation

2024 – 2025 · Tata Communications, Vodafone Idea

Architected ETL and KPI pipelines for large-scale telecom data; owned schema design, job orchestration, and SLA for client-facing analytics (Tata Communications, Vodafone Idea).

System design

Batch ETL with clear stages: ingest (idempotent) → validate & clean → transform (business rules) → load into dimensional/reporting layer. Orchestration and scheduling for SLA; data quality checks and alerting.

Highlights

• Designed and implemented ETL workflows and schema for telecom KPIs; defined job boundaries and failure handling.
• Ensured data quality and SLA for client-facing dashboards; documented pipelines and ownership for operations.
• Collaborated with client teams on KPI definitions, refresh frequency, and reporting requirements.