Pavan A.
Data Engineer - III at EMC Insurance | Certified AWS Solution Architect | Certified Snowflake SnowPro Core
- Role
- Data Engineer - Iii at EMC Insurance Companies
- Location
- Austin, TX, US
- LinkedIn followers
- 500 followers
About Pavan A.
Expertise in Application performance tuning, Design Reviews, CodeReviews & …
Experience
Data Engineer - Iii
Dec 2021 — Present · Des Moines, IA, US
Experienced Data Engineer with a strong background in SQL, PL/SQL, Informatica PowerCenter, and ETL development.• Specializes in data warehousing, performance tuning, and cloud-based data solutions.• Proven expertise in designing and optimizing complex ETL workflows, managing large-scale data pipelines, and supporting production environments.• Skilled in Snowflake, AWS services (S3, Lambda, Step Functions, CloudWatch, SNS), and DBT Labs for modern data stack implementations.• Adept at collaborating with cross-functional teams, troubleshooting performance bottlenecks, and ensuring data integrity across OLTP/OLAP systems.• Provided on-call production support, performed unit testing, and maintained detailed test logs and documentation.• Led efforts in performance tuning across source, target, and mapping layers to resolve bottlenecks.• Coordinated with source system owners and ETL developers for daily progress monitoring and issue resolution.• Implemented Control-M job scheduling for time-sensitive ETL processes across daily, monthly, and yearly cycles.• Worked extensively with Snowflake for data loading, cloning databases, backups, and performance optimization.• Utilized AWS services for building scalable data pipelines and event-driven architectures.• Built DBT models, macros, seed files, and integrated them into modern data workflows.• Applied Python for automation, data manipulation, and integration tasks.• Conducted code reviews to ensure adherence to coding standards, improve code quality, and mentor team members.ETL Tools: Informatica PowerCenter, Informatica IICS• Databases: SQL Server, Snowflake• Languages: SQL, PL/SQL, Python• Cloud & DevOps: AWS (S3, Lambda, Step Functions, CloudWatch, SNS), DBT Labs, • Modeling: Dimensional Modeling (Star & Snowflake Schema), ER Modeling• Scheduling Tools: Control-M• Other tools: Lucid chart, VS studio, Github, Confluence, Jira,
Education
Valparaiso University
Master’s Degree
2013 — 2014
Texas McCombs School of Business
Postgraduate Degree
2025 — 2026
JNTUH College of Engineering Hyderabad
Bachelor of Technology - BTech
2008 — 2012
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.