Theja Kumar Kunchala
Data Engineer
Bengaluru,KA
Summary
Data Engineer with over 2 years of experience building scalable DBT models, transforming raw data into useful insights, and improving data quality for regulatory reporting. Skilled in working with cross-functional teams, streamlining ETL workflows, and deploying CI/CD pipelines. Strong knowledge of SQL, DBT, Redshift, and Informatica. Focused on designing reliable data models, automating workflows, and delivering solutions that support business needs.
Overview
2
2
years of professional experience
Work History
Programmer Analyst
Cognizant
01.2023 - Current
- Built and optimized DBT models for six regulatory data calls. Used Git for version control to track changes and maintain code quality, delivering submission-ready reports.
- Migrated legacy SAS code to optimized DBT SQL, improving data quality and reducing processing time by 20%.
- Developed custom DBT tests, validation, and reconciliation queries to ensure full format compliance and achieve 99% data accuracy.
- Created Informatica workflows to transfer SCD Type 1 tables from SQL Server to Redshift staging, making all required application tables available for downstream teams.
- Enhanced the data cleansing process by integrating 10+ new tables into the existing framework, achieving 100% latest data accuracy with active tracking mechanisms.
- Developed and scheduled automated Tivoli jobs to execute new Informatica workflows, ensuring seamless and timely data processing while reducing manual intervention by 30%.
- Used Jenkins CI/CD pipelines and Git to deploy DB scripts, Informatica flows, and file transfers via WinSCP, cutting manual deployment effort by 40%.
- Refined the Informatica ETL design to account for missed merge/unmerge scenarios, leading to a 25% boost in error detection and model completeness.
- Validated customer segmentation flow by testing API calls, ensuring 100% data accuracy. Processed Redshift datasets, updated segmentation keys via shell script API calls, and performed bulk loading, leading end-to-end testing for accuracy.
- Conducted data stewardship activities to resolve potential matches, maintaining overall data consistency and achieving a 98% accuracy rate.
Education
Electronics & Communication Engineering (ECE) - undefined
Hindustan Institute of Technology & Science
01.2022
Skills
- DBT
- SQL
- Redshift
- PostgreSQL
- Informatica PowerCenter
- Reltio
- Python
- REST APIs
- Jenkins
- Tivoli
- GitHub
- WinSCP
- Power BI
- ServiceNow
- Jira
- Machine Learning (basic)
Certifications And Awards
- Microsoft Certified: Azure Data Fundamentals
- Microsoft Certified: Power BI Data Analyst
- Emerging Talent, DBT Developer, 2024 Cognizant
Timeline
Programmer Analyst
Cognizant
01.2023 - Current
Electronics & Communication Engineering (ECE) - undefined
Hindustan Institute of Technology & Science
Similar Profiles
Vaishali GuptaVaishali Gupta
Programmer Analyst at CognizantProgrammer Analyst at Cognizant
Ben Christopher PeralesBen Christopher Perales
Senior Process Executive at CognizantSenior Process Executive at Cognizant
Sudharsan SSudharsan S
Developer at CognizantDeveloper at Cognizant