I am a Senior Data and Analytics Engineer with 12+ years of experience delivering enterprise-grade data platforms and decision-support solutions. I translate business needs into scalable data models using Snowflake, dbt Cloud, Python, SQL, and AWS to enable resource prioritization, executive reporting, and data storytelling. I collaborate across business and technical teams to define roadmaps for analytics projects, establish data governance and quality frameworks, and mentor engineers to uphold best practices in data engineering, CI/CD, and modern data platforms.

Sowjanya Kakumanu

I am a Senior Data and Analytics Engineer with 12+ years of experience delivering enterprise-grade data platforms and decision-support solutions. I translate business needs into scalable data models using Snowflake, dbt Cloud, Python, SQL, and AWS to enable resource prioritization, executive reporting, and data storytelling. I collaborate across business and technical teams to define roadmaps for analytics projects, establish data governance and quality frameworks, and mentor engineers to uphold best practices in data engineering, CI/CD, and modern data platforms.

Available to hire

I am a Senior Data and Analytics Engineer with 12+ years of experience delivering enterprise-grade data platforms and decision-support solutions. I translate business needs into scalable data models using Snowflake, dbt Cloud, Python, SQL, and AWS to enable resource prioritization, executive reporting, and data storytelling.

I collaborate across business and technical teams to define roadmaps for analytics projects, establish data governance and quality frameworks, and mentor engineers to uphold best practices in data engineering, CI/CD, and modern data platforms.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Language

English
Fluent

Work Experience

Senior Data Engineer at HCL (Client: USAA)
November 1, 2018 - Present
Led migration of 100+ legacy assets (DataStage, Hadoop, Oracle) to Snowflake using dbt Cloud, Python, and AWS S3, improving scalability and reducing operational overhead. Designed and maintained production-grade ELT pipelines in dbt, implementing testing, documentation, and CI/CD best practices. Optimized Snowflake performance using micro-partitioning, clustering keys, and materialized views, reducing query latency by up to 40%. Built PySpark pipelines for large-scale data processing, improving processing efficiency by ~80%. Implemented Apache Airflow (MWAA) for orchestration, enabling reliable scheduling and monitoring of data workflows. Supported CECL regulatory data pipelines, ensuring accuracy, auditability, and compliance. Established data governance and data quality frameworks, improving data reliability and downstream analytics confidence. Partnered with business and analytics teams to translate requirements into scalable data models and analytics-ready datasets. Led automation
Senior ETL Architect / Senior Data Engineer at Commonwealth Bank of Australia (CBA)
March 1, 2012 - January 1, 2017
Led a team of 12 engineers delivering data quality and customer data platforms for enterprise banking systems. Defined and implemented data quality rules, monitoring frameworks, and remediation processes for critical datasets. Automated operational workflows, reducing manual intervention and improving system reliability. Partnered with global teams to provide 24/7 production support for mission-critical data platforms. Drove proof-of-concept initiatives using TFS, delivering successful adoption across teams. Translated business requirements into scalable data models and analytics-ready datasets.
Senior Software Engineer at GMAC
January 1, 2011 - January 1, 2012
Successfully integrated DataStage service accounts, connecting multiple databases including Oracle, Netezza, IBM DB2, and MSSQL, with the CyberArk vault, improving security for banking fraud and information applications. Created and managed conceptual designs that met business requirements and translated them into technical solutions, resulting in increased efficiency and transaction accuracy. Led cross-location collaboration to boost productivity and timely delivery. Supported real-time machine learning, forecasting, and simulation initiatives; participated in product testing and validation to ensure high-quality deliverables.
Senior ETL Developer at Western Union
January 1, 2010 - January 1, 2011
Managed DataStage workflows for insurance data integration. Automated job scheduling using Autosys; oversaw DB2 database management and schema design. Designed and implemented ETL processes for data transformation. Supported insurance reporting with SQL queries from DB2. Ensured data integrity through QA checks, problem solving, and risk assessment. Documented DataStage jobs, Autosys schedules, and DB2 configurations; collaborated with cross-functional teams for project alignment.
ETL Developer at UnitedHealth Group (UHG)
January 1, 2009 - January 1, 2010
Designed and supported enterprise ETL pipelines using DataStage, Teradata, DB2, Oracle, and SQL. Automated scheduling with Autosys and optimized database performance. Ensured data integrity through rigorous testing and production support.

Education

Bachelor of Technology (B.Tech) at Jawaharlal Nehru Technological University, Hyderabad, India
January 11, 2030 - January 1, 2006

Qualifications

IBM Certified Solution Developer – WebSphere IIS DataStage Enterprise Edition
January 11, 2030 - January 8, 2026

Industry Experience

Financial Services, Professional Services, Software & Internet