Get your Emails warmed up and ready to send
Build sender reputation and reach more inboxes with automated email warmup.
Warm up your emails
Starting at $49/month
Pavan A.
Data Engineer - Iii @EMC Insurance Companies
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer - Iii @EMC Insurance Companies
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
Texas McCombs School of Business
Postgraduate Degree
JNTUH College of Engineering Hyderabad
Bachelor of Technology - BTech
ABOUT PAVAN A.
Expertise in Application performance tuning, Design Reviews, CodeReviews & …
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.