Senior Data Engineer with ETL and Automation Expertise

BADDULA SAI TEJA YADAV

Data Engineer

***************@*****.*** 470-***-**** LinkedIn

PROFESSIONAL SUMMARY

Data Warehouse Engineer with 5+ years of experience building and maintaining ETL/database load and extract processes, managing relational database infrastructure, and improving data warehousing architecture and tools. Strong proficiency in Python, SQL, and PowerShell-based scripting with practical experience in Oracle, Snowflake, and other relational databases. Recognized for passion for automation, continual process improvement, and strong written and oral communication while operating in Agile delivery environments.

TECHNICAL SKILLS

Languages: Python (Pandas, NumPy, Scikit-learn), SQL, PowerShell (Shell Scripting), R Data Snowflake, Oracle, AWS Redshift, SQL Server, PostgreSQL, MongoDB, Data Warehouse Warehouse: Architecture ETL Tools: ETL, ELT, SSIS, SSRS, Data Lineage, Data Transformation, Database Load & Extract Processes Orchestration: Job Scheduling, Pipeline Orchestration (Airflow Concepts), Process Automation Scripting: Shell Scripting, PowerShell Automation, Python Scripting, Linux Command-Line Concepts Dev Tools: Git, GitHub, Jira, MS Visio, HP Quality Center, UAT, Version Control Methodology: Agile/Scrum, SDLC, Waterfall, Continual Process Improvement, Documentation Practices: Automation Mindset, Architecture Improvement, Cross-Team Collaboration, Written & Oral Communication PROFESSIONAL EXPERIENCE

Data Analyst US Bank Irving January 2024 – Present

• Enhanced ETL and database load/extract processes through SQL and Power Query automation,identifying and resolving data quality issues to improve reporting trust by 30%.

• Implemented and managed scripted automation processes for data warehouse maintenance, reducingmanual data rework by 25% across reporting infrastructure.

• Designed comprehensive data dictionaries and metric definitions, ensuring enterprise-wide consistencyand decreasing conflicting metrics by 40%.

• Identified and implemented architecture and process improvements across data warehouse toolingusing Git-based version control and modular scripts.

• Defined data lineage tracking protocols supporting root-cause analysis, system impact assessments,and continual process improvement across data warehouse pipelines.

• Collaborated within Agile/Scrum delivery cycles, partnering with engineering teams on warehouse loadschedules, change control, and after-hours support.

• Communicated technical data definitions, exclusions, and structural integrity to external auditors andsenior stakeholders with strong written and oral skills.

• Mentored junior analysts on SQL optimization, scripting, and warehouse design patterns to strengthenteam automation capability. Data Analyst Gexa Energy January 2021 – December 2023

• Architected end-to-end ETL pipelines for high-volume energy data warehouse, ensuring 99.9% dataavailability for daily operational extract and load processes.

• Led design and deployment of standardized data models in Snowflake supporting 15+ business unitswith consistent warehouse load patterns.

• Spearheaded automation of manual data aggregation and warehouse load tasks using PowerShell shellscripting and Python, saving significant weekly hours.

• Orchestrated transition of legacy reporting systems to modernized analytical warehouse platforms,improving query performance by 40% through architecture improvements.

• Championed data quality frameworks with validation and deduplication, reducing anomalies by 20%across critical warehouse source systems.

• Built a metadata repository for warehouse tables and load processes, improving discoverability andreducing onboarding time by 35%.

• Established standard operating procedures for data intake and warehouse pipeline development,lowering rework rates by 18% through Agile-aligned processes.

• Managed full lifecycle of data warehouse projects, from requirements gathering through UAT andproduction deployment, with strong written documentation habits.

EDUCATION

Master of Science in Information Technology Management Indiana Wesleyan University USA

Contact this candidate