APOORV SAXENA

Implemented end-to-end data warehousing solutions using Snowflake, ensuring optimal performance and scalability.

• Build end-to-end DBT models, snapshots, macros, test and seeds using DBT Cloud and validated transformed data in Snowflake.
• Engineered complex SQL queries to load and transform data from Snowflake source tables to fact tables, optimizing data processing workflows.
• Streamlined and automated data pipeline processes by scheduling task flows in IICS, leading to a 40% reduction in data load time and ensuring smooth data integration.
• Executed SCD1 and SCD2 methodologies for change data capture, significantly enhancing data quality and enabling efficient loading of data deltas in the data warehouse.
• Designed and developed multiple data marts to meet client reporting requirements, facilitating advanced report development by the Tableau team.
• Implemented robust data security measures, including data masking and encryption, to safeguard sensitive information and ensure compliance with stringent data privacy regulations.

• Proficient in Data Warehousing tools, including Snowflake, SQL Snowflake, Procedures, Snowpipe, Snowsql, ELT, Birt, SnowflakeDB, SAP BO, OBIEE, AWS S3, Matillion, MS SQL Server, Oracle, PL/SQL, SAP BO, BIRT, GIT, Service Now, and Jira showcasing adaptability and strong technical foundation.
• Migrated SQL, PL/SQL stored procedures, functions, views, and materialized views to Snowflake, ensuring smooth transition with minimal downtime.
• Conducted thorough data quality assessments and implemented governance protocols to maintain high data accuracy and consistency.
• Collaborated closely with cross-functional teams to gather requirements, design data models, and deliver business centric solutions.
• Ingested CSV data and semi-structured data (JSON) into Snowflake, leveraging Snowflake functions to create lateral views, significantly enhancing data accessibility and analytical capabilities.
• ·Designed and developed end-to-end ETL/ELT pipelines for continuous data loading, ensuring seamless integration and efficient data management.
• Created dedicated virtual warehouses for Matillion ELT processes and reporting teams, optimizing resource usage and enhancing performance.
• Applied SCD methodologies for change data capture, ensuring incremental load of data in Data Warehouse and substantially improving overall data quality.