Aditya Bansal

I’m a dedicated SnowPro Core certified data professional with 7.2 years of experience in MSBI, ETL/ELT, and data management. I focus on designing scalable data models, developing and optimizing data pipelines, and improving data reliability in production. In my current role as Lead Consultant at ITC Infotech (Finance), I migrated complex Oracle SQL Developer codebases to Snowflake for a US-based financial client, boosting processing efficiency and scalability. I built Snowflake-based ELT pipelines using Streams and Tasks, and enhanced automation with performance tuning and data validation. Previously at Innova Solutions (Healthcare), I orchestrated ELT pipelines using Snowflake and DBT and improved SQL Server Agent–driven workflow reliability by 30%. I also developed SSIS packages in Visual Studio, migrated SQL logic into reusable DBT macros for incremental loads, and leveraged Snowpipe, Tasks, and zero-copy cloning to scale pipeline performance. Earlier at Capgemini and Infosys, I maintained and optimized SQL Server/SSIS data marts, improving sales growth by 15% and reducing processing time by 25%. I’ve also supported daily SSRS reporting and ensured dependable job scheduling through tools like SQL Server Agent and IBM Workload Scheduler, while mentoring junior developers and partnering with global stakeholders.