Prateek Agarwal
Bengaluru
Summary
Data Engineer with 4+ years of experience in ETL/ELT, skilled in Snowflake, SQL, Databricks, and dimensional modeling. Experienced in handling large datasets, building scalable pipelines, and implementing customer 360 solutions. Strong communicator with a proven ability to partner with clients, business users, and cross-functional teams to deliver impactful data solutions.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Consultant
Tredence Analytics
Bengaluru
01.2023 - Current
- Built a Control Framework for data replication from raw to operational layers, leveraging Snowflake procedures, tasks, streams, and Control-M scheduling. Designed it to be dynamic and parameter-driven for customization across sources, with logging and error handling that allowed 400+ objects to replicate seamlessly with minimal manual intervention.
- Implemented a deployment management strategy, moving the team from traditional methods to Git-based version control, CI/CD, and collaborative development.
- Transitioned the team's transformation workflows from Snowflake SQL to DBT, enabling versioned development, code reusability, lineage tracking, and deployment automation; developed reusable macros to standardize logic.
- Partnered with domain SMEs and client stakeholders to define KPIs such as occupancy rate and ticketing revenue (including discounts and exclusions), and led migration of the revenue calculation system by embedding these rules into procedures, enabling accurate year-over-year comparisons.
Analyst
Tredence Analytics
Bengaluru
07.2021 - 12.2022
- Contributed to building a customer data platform, designing data models that unified customer information into a 360 view for analytics and personalization, improving data accessibility for marketing and operations teams.
- Developed complex ETL transformations in Snowflake and SAP BODS, and built reusable components to automate ingestion from AWS S3 to Snowflake across multiple sources with outputs delivered to external accounts, reducing manual effort by ~30%.
- Developed ETL processes to assign a unique Golden ID to contacts across reservation systems, contact information, and fleet data sources, ensuring identity resolution and a single customer view; this cut duplicate outreach in direct mail and email campaigns by ~20-25%, lowering campaign costs significantly.
Education
B.Tech - Mechanical Engineering
National Institute of Technology
Warangal05-2021
Skills
- Warehousing: Databricks, Snowflake, Redshift
- Transformation: DBT, Matillion, SAP BODS
- ETL orchestration: Control-M, DBT
- Programming: SQL, PL-SQL, Python, Pyspark
- Data Modeling & Architecture: Dimensional Modeling, Star/Snowflake Schema, ODS, CDP
- Cloud: AWS (S3, EC2), Azure Data Lake
- Other tools: Git, Jira, Kafka, Salesforce Marketing Cloud, and CDP
Certification
- Databricks DE Associate Certification, Intermediate Proficiency
- Snowpro Core Certification, Professional Proficiency
- Transform your data using DBT, Professional Proficiency
- AWS cloud practitioner, Working Proficiency
- SAP BODS, Professional Proficiency
Accomplishments
Pat on the back
- Pat on the back Award
- Best Project Delivery Award (team recognition) across the organization for the successful delivery of the Customer Data Platform (CDP), providing a unified 360° customer view
- Received client appreciation for implementing the Snowflake-based Control Framework, enabling parameter-driven replication of 400+ objects with minimal manual effort
Timeline
Consultant
Tredence Analytics
01.2023 - Current
Analyst
Tredence Analytics
07.2021 - 12.2022
B.Tech - Mechanical Engineering
National Institute of Technology