KAKANI NAGARAJU
Hyderabad,Telangana
Work Preference
Summary
Senior Data Engineer with over 10 years of experience in Data Engineering, Product Development, and Data Platform Design across Banking, Retail, HR, and Supply Chain domains. Proven expertise in building end-to-end ETL/ELT pipelines, data warehouses, and cloud data ecosystems that support analytics, AI, and business intelligence. Seeking to contribute technical leadership in scalable data architecture, performance optimization, and automation.
- Designed and deployed data pipelines, ETL/ELT workflows, and data warehouses for enterprise clients including Mastercard, GAP, UPS, and ITC.
- Delivered data engineering solutions for product development-supporting analytical, predictive, and ML workflows using Python and Spark ecosystems.
- Partnered with cross-functional teams (Data Science, Product, BI) to ensure data readiness for ML models and analytics.
- Hands on Talend for data integration, transformation, and automation across AWS and Azure environments.
- Strong command of SQL, PL/SQL, Spark SQL, Python, and Shell scripting for advanced data manipulation and processing.
- Experienced in Databricks, Kestra, for orchestration, scheduling, and performance tuning.
- Hands-on with multiple data stores including Amazon S3, SingleStore, Oracle, Redshift, MySQL, and SQL Server using both columnar and row-based storage.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Data Engineer
Coronis Ajuba Solutions Pvt. Ltd.
Hyderabad, Telangana
04.2024 - Current
- Lead FA DWH (Financial Analytics Data Warehouse) development and performance optimization.
- Built scalable ETL/ELT pipelines using Shell, SQL, and Python, integrating AWS S3 with Redshift.
- Designed automated data validation and monitoring frameworks to ensure data quality.
- Improved pipeline runtime efficiency by 30% through Spark optimization and query tuning.
- Developed ETL processes using Apache Spark for efficient data integration and transformation.
- Designed and implemented data pipelines to optimize data processing workflows.
Product Engineer
Diwo India Pvt. Ltd.
Hyderabad, Telangana
07.2019 - 04.2024
- Contributed to Diwo Product Development V2, delivering AI-driven decision intelligence solutions.
- Designed and managed data ingestion, transformation, and automation pipelines using Databricks, Talend.
- Collaborated with Data Science teams to produce ML-ready datasets and integrated pipelines with cloud infrastructure.
- Implemented CI/CD for ETL workflows in AWS and Azure, reducing deployment overhead.
Data Engineer
ITC Infotech India Ltd.
Hyderabad, Telangana
12.2016 - 07.2019
- Engineered HRMS PowerApps data pipelines for human capital analytics.
- Migrated legacy Oracle ETL systems to AWS Redshift, improving scalability and performance.
- Developed PL/SQL stored procedures and analytical queries for dashboards and reporting.
- Enhanced data refresh speed by 25% through SQL tuning and partitioning.
DB Design and Application Engineer
VSoft Technologies Pvt. Ltd.
Hyderabad, Telangana
05.2015 - 12.2016
- Designed core database schema for CoreSoft Product Development V4.
- Automated data loading and transformation scripts using SQL and Shell scripting.
- Improved query performance via indexing, caching, and query optimization.
Education
Bachelor of Engineering - Electronics & Communication Engineering
Newton's Institute of Engineering
01.2015
Skills
- Banking
- Retail
- HR
- Supply Chain
- SQL
- PL/SQL
- T-SQL
- Python
- Shell Scripting
- Talend
- DBT
- Databricks
- Spark
- Kestra
- Airflow
- AWS
- Azure
- SingleStore
- Oracle
- MySQL
- CI/CD
- Data Governance
- Performance Optimization
- Agile
- Scrum
- Cross-Team Collaboration
Websites
Certification
Oracle PL/SQL Developer Certified Associate (OCA) - 1Z0-061 & 1Z0-144
Keywords
- Senior Data Engineer
- Cloud Data Engineer
- ETL / ELT Developer
- DataOps
- Python
- SQL
- Spark
- Databricks
- Talend
- DBT
- Kestra
- AWS
- Azure
- SingleStore
- Redshift
- Data Pipeline
- Data Architecture
- Data Modeling
- Shell Scripting
- Big Data
- Data Governance
- Data Warehouse
- Automation
- Performance Optimization
Core Skills
Banking, Retail, HR, Supply Chain, SQL, PL/SQL, T-SQL, Python, Shell Scripting, Talend, DBT, Databricks, Spark, Kestra, Airflow, AWS (S3, Redshift), Azure (Blob), SingleStore, Oracle, MySQL, CI/CD, Data Governance, Performance Optimization, Agile, Scrum, Cross-Team Collaboration
Project Highlights
- FA DWH (Coronis Ajuba): Enterprise data warehouse architecture and pipeline automation using Shell scripting and AWS.
- Diwo Product Development V2 (Diwo India): Data engineering backbone for a decision intelligence product.
- HRMS PowerApps (ITC Infotech): Data integration and analytics for HR operations.
- CoreSoft Product V4 (VSoft): End-to-end database and application data layer design.
Personal Information
- Title: Sr Data engineer
- Nationality: Indian
Timeline
Senior Data Engineer
Coronis Ajuba Solutions Pvt. Ltd.
04.2024 - Current
Product Engineer
Diwo India Pvt. Ltd.
07.2019 - 04.2024
Data Engineer
ITC Infotech India Ltd.
12.2016 - 07.2019
DB Design and Application Engineer
VSoft Technologies Pvt. Ltd.
05.2015 - 12.2016
Bachelor of Engineering - Electronics & Communication Engineering
Newton's Institute of Engineering