Sachin Awaghade

About Sachin Awaghade

I’m a Data Engineering & ETL Specialist with 14+ years of experience designing, building, and modernizing enterprise data platforms across Banking, Finance, Media, Telecom, and Manufacturing domains.My core expertise spans Informatica PowerCenter, Informatica IICS, Snowflake, DBT, Oracle, SAP data migration, PL/SQL, and performance-tuned ELT design.Over the years, I’ve led multiple end-to-end data modernization initiatives — including large-scale migrations such as Hive → Snowflake, Netezza → Snowflake, SAP → Snowflake using DBT, and legacy Informatica upgrades. My work consistently delivers 30–50% performance improvements, cleaner pipelines, higher reliability, and easier maintainability.In my current role at Accenture, I design Snowflake architecture, build optimized ELT pipelines, and lead cloud migration for enterprise-grade data warehouses. I’ve also contributed significantly for global clients by — developing DBT models across staging, transformation, and marts layers, improving query performance, standardizing model architecture, and creating clean, consumable datasets for downstream analytics.I enjoy mentoring teams, solving complex data problems, and simplifying legacy systems into modern, efficient, and scalable cloud architectures. Whether it’s building SCD2 frameworks, optimizing SQL, orchestrating pipelines, or ensuring SLA-driven production stability — I bring a hands-on, quality-focused approach.What I bring to the table:14+ years in ETL/ELT engineering, data modeling & DW modernizationStrong expertise in Informatica PC & IICS, Snowflake, DBT, PL/SQL, UnixProven experience leading teams and managing full SDLCPerformance tuning, job automation & migration strategyDeep understanding of financial, telecom & enterprise data ecosystemsClear communication, strong ownership & problem-solving mindsetI’m currently open to connecting with professionals, leaders, and teams looking for someone who is job-ready, skilled, proactive, and easy to work with. If you are hiring or collaborating on data engineering initiatives — let’s connect!

Experience

1. Senior Application Development Specialist

   Accenture

   May 2021 — Present · Mumbai, IN

   Designed and implemented Snowflake pipelines using DBT, migrating SAP data from SAP systems into Snowflake using modular SQL models.• Developed complete DBT model architecture including staging, transformation, and marts layers aligned with business and reporting requirements.• Built reusable DBT macros, sources, tests, and documentation ensuring standardization and data reliability.• Improved query performance by 35–50% through optimized Snowflake SQL, micro-partition awareness, clustering strategies, and model refactoring.• Implemented DBT testing (schema, unique, not-null) and automated quality checks to reduce data defects by 40%.• Designed and implemented Snowflake database architecture supporting 100+ ETL pipelines, improving query performance by 40% through clustering, micro-partitioning & optimized SQL.• Led end-to-end ETL delivery using Informatica IICS, including mappings, taskflows, macros, parameterization and error-handling frameworks.• Spearheaded Hive → Snowflake migration, rewriting legacy SQL and Informatica logic into cloud-optimized IICS pipelines.• Acted as Change Manager for the DW Run Publication Team; managed all release cycles with zero deployment rollbacks.• Built task-orchestrated workflows executed through ESP batches, improving job SLA adherence by 30%.• Provided daily operational oversight for 150+ scheduled jobs, ensuring 99% on-time performance.• Mentored a team of 6 engineers, supporting development, issue triage, code reviews and best practices.• Developed complex SCD-2 logic using IICS and Snowflake, ensuring high-quality dimension and fact data population.• Collaborated with onsite architects for STTM design reviews and technical solutioning.

Education

• Savitribai Phule Pune University

  Bachelor of Engineering (B.E.), Information Technology

  2006 — 2010

Skills

• Oracle
• Informatica Administration
• Jasper Reports
• Pl/Sql
• Unix
• Mysql
• Sybase Iq
• Informatica
• Sql