DOKKARI KOTESWARARAO

DOKKARI KOTESWARARAO

Python AWS Data Engineer
India
Telugu, Hindi, English

About Me

Aspiring Python Developer with hands-on experience in backend development, data engineering, and cloud-based automation. Skilled in building scalable Django applications, creating RESTful services, and working with Snowf…

Experience

AWS Intern – Python Developer

ExcelR (Client: Daimler Trucks North America), Bengaluru
Jun 2024 - Dec 2024 · 6 months

Migrated large-scale legacy data from IBM DB2 to Snowflake using a Matillion-based ETL pipeline.
Created views, stored procedures, and staging tables following business validation rules for data cleansing.
Implemented aggregation logic in staging layers before loading into target systems.
Developed Matillion orchestration and transformation jobs for automated data flows.
Built Python-based automation scripts for Excel source–target reconciliation.
Maintained Reconciliation Sheets for mismatch tracking and data quality assurance.
Scheduled CRON jobs using UTC time handling to support daily automated loads.
Coordinated with QA teams for post-migration validation using automated scripts.
Worked with business analysts to translate validation rules into ETL transformations.

AWS Intern – Python Developer

ExcelR (Client: Daimler Trucks North America) · Hyderabad, India
May 2024 - Nov 2024 · 5 months

Migrated large-scale legacy data from IBM DB2 to Snowflake using a Matillion-based ETL pipeline., Created views, stored procedures, and staging tables following business validation rules for data cleansing., Implemented aggregation logic in staging layers before loading into target systems., Developed Matillion orchestration and transformation jobs for automated data flows., Built Python-based automation scripts for Excel source–target reconciliation., Maintained Reconciliation Sheets for mismatch tracking and data quality assurance., Scheduled CRON jobs using UTC time handling to support daily automated loads., Coordinated with QA teams for post-migration validation using automated scripts., Worked with business analysts to translate validation rules into ETL transformations.

Skills

Linux Python Shell Scripting Structured Query Language (SQL) Data Analysis Django GitHub Docker RESTful APIs Snowflake Matillion ETL AWS (EC2 S3 IAM CloudWatch VPC) GitLab CI/CD SonarQube AWS EC2 S3 IAM CloudWatch VPC LangChain Agent AI MCP RAG
Report this Profile?