Kankarla N

Senior Data Engineer Lead Etl Developer @T-Mobile

Overland Park, KS, US

Lead enterprise ETL design, development, and implementation across multiple projects, working on Teradata, DataStage, Informatica PowerCenter, Azure Data Factory (ADF), and Azure Databricks for high-volume ETL pipelines.Designed and implemented incremental and full-load ETL pipelines using Snowflake Snowpipe and ADF, ensuring near real-time data availability for reporting and analytics.Developed complex ETL workflows integrating multiple heterogeneous data sources, including flat files, XML, JSON, APIs, Teradata, Snowflake, and HDFS.Automated ETL workflows using Unix/Linux shell scripts, Zena scheduler, and ADF pipelines, reducing manual intervention and improving SLA adherence.Developed R Shiny applications for KPI dashboards, spatial data analytics, trend analysis, forecasting, and performance monitoring, supporting executive-level decision-making.Mentored a team of onshore-offshore developers, assigning tasks, reviewing code, providing performance feedback, and implementing best practices in ETL development.Optimized Teradata SQL queries, DataStage jobs, and ADF pipelines, improving overall ETL performance by 25–30%.Designed and maintained interactive Tableau dashboards, converting legacy Excel and CSV reports into intuitive, user-friendly visualizations.Managed Viewpoint, TASM, and TDWM workloads, monitoring job performance, proactively resolving bottlenecks, and maintaining production data integrity.Integrated big data sources using HDFS and Hive, transforming and merging incremental datasets for downstream ETL consumption.Developed complex parameterized and reusable DataStage/ADF components for multi-project use, improving productivity and maintainability.Conducted unit testing, integration testing, and UAT across multiple environments to ensure ETL accuracy and reliability.Collaborated with business analysts, data architects, and stakeholders to translate business requirements into technical specifications.

Oklahoma Christian University

Master's degree, Computer Engineering