Nerlapalli Aswini

Nerlapalli Aswini

Data Engineer
India
Full-time Hybrid

نبذة عني

I'm a skilled Data Engineer with expertise in Snowflake, DBT and SQL. I'm specialized in building efficient ETL pipelines and optimizing SQL queries to enhance data workflows and accuracy. With a strong foundation in dat…

الخبرة

senior systems associate

Infosys Limitied · Hyderabad , Telangana , India
Jul 2022 - حتى الآن · 4 سنوات 3 أشهر

<p>• 4+ years of expertise with Snowflake cloud data warehouse, DBT, AWS S3 & SQL.</p><p>• Proficient in constructing data pipelines and data transformation using Snowflake & DBT.</p><p>• Extensive experience with Snowflake Data Warehouse, including a thorough understanding of its architecture and processing mechanisms.</p><p>• Experienced in transforming data using Data Build Tool (DBT).</p><p>• Managed large and intricate datasets such as Parquet, JSON, and CSV files sourced from AWS S3.</p><p>• Competent in writing complex SQL scripts involving statistical aggregate and analytical functions for ETL processes in Snowflake.</p><p>• Skilled in interpreting business processes and requirements from user stories and translating them into technical specifications.</p><p>• Advanced SQL skills, including complex joins, Snowflake stored procedures, cloning, snowpipe, views, and materialized views.</p><p>• Capable of working independently and collaboratively with a strong sense of responsibility, dedication, and eagerness to learn new technologies.</p><p>• Analyzed data and resolved ad-hoc queries by liaising with the BI team and stakeholders.</p><p>• Experienced in understanding customer requirements, performing analysis, designing, developing, and implementing solutions, and enhancing business processes.</p><p></p><p></p>

Senior Data Engineer

Infosys · Hyderabad
Jul 2022 - حتى الآن · 4 سنوات 3 أشهر

<p>4+ years of expertise with Snowflake cloud data warehouse, DBT, AWS S3 & SQL.</p><p> Proficient in constructing data pipelines and data transformation using Snowflake & DBT.</p><p> Extensive experience with Snowflake Data Warehouse, including a thorough understanding of its architecture and processing mechanisms.</p><p> Experienced in transforming data using Data Build Tool (DBT).</p><p> Managed large and intricate datasets such as Parquet, JSON, and CSV files sourced from AWS S3.</p><p> Competent in writing complex SQL scripts involving statistical aggregate and analytical functions for ETL processes in Snowflake.</p><p> Skilled in interpreting business processes and requirements from user stories and translating them into technical specifications.</p><p> Advanced SQL skills, including complex joins, Snowflake stored procedures, cloning, snowpipe, views, and materialized views.</p><p> Capable of working independently and collaboratively with a strong sense of responsibility, dedication, and eagerness to learn new technologies.</p><p> Analyzed data and resolved ad-hoc queries by liaising with the BI team and stakeholders.</p><p> Experienced in understanding customer requirements, performing analysis, designing, developing, and implementing solutions, and enhancing business processes.</p>

المشاريع

Performance Forecasting & Reporting Analytics

Infosys Limitied
المدة : 01-Aug-2022 - 01-Jan-2025

<p> Led the end-to-end management of ETL workflows for a large-scale Snowflake data warehouse,</p><p>encompassing design, implementation and ongoing support.</p><p>• Designed and implemented an automated schema evolution framework to handle schema drifts,</p><p>reducing job failures by up to 30%.</p><p>• Developed and optimized data transformation workflows using DBT using models, views, and materialized views for efficient data processing.</p><p>• Built custom macros and reusable Jinja templates in DBT to standardize and simplify repetitive SQL logic across multiple transformation models.</p><p>• Implemented performance enhancement</p><p>strategies, including clustering keys and autoscaling to optimize data loading and query execution.</p><p>• Implemented SCD Type 2 to track the historical versions of data by using DBT Snapshots.</p><p></p><p></p>

الشهادات

Infosys Certified Snowflake developer • Infosys Certified Snowflake Testing professional • Infosys Certified Data Build Tool developer

infosys · Hyderabad , Telangana , India · 2026

المهارات

Snowflake Data Build Tool (DBT) Gitlab SQL AWS S3 Oracle Data Integrator Matillion Parquet JSON CSV Stored Procedures Snowpipe Views Materialized Views Clustering Keys Autoscaling Jinja SCD Type 2 CI/CD Git
الإبلاغ عن هذا الملف الشخصي؟