Himanshu Saroj

Background

About Himanshu Saroj

As a Data Engineer at Russell Investment, I specialize in designing, optimizing, and managing secure, high-integrity data pipelines that integrate critical on-premise systems with our cloud data platform. My focus is on delivering robust, high-performance data solutions for business intelligence and regulatory reporting.My core technical expertise is anchored in:Python: For developing custom data extraction scripts, complex transformation logic, and automating operational tasks.Advanced SQL: For efficient data modeling, in-warehouse transformations (ELT), query optimization, and leveraging Snowflake's native features like Stored Procedures and Tasks.Clover: Utilizing this powerful data integration platform for developing complex Extract-Transform-Load (ETL) workflows, ensuring seamless data flow from diverse legacy sources.I manage the complete data lifecycle using a hybrid architecture:Data Warehouse: Snowflake for its powerful, scalable data warehousing and processing capabilities.Orchestration & Workflow Management: Utilizing tools like Apache Airflow (self-hosted or managed) or Snowflake Tasks for scheduling, dependency management, and monitoring end-to-end data pipelines.ETL/Integration: Working with enterprise-grade platforms such as Talend or Informatica PowerCenter (with on-premise gateway support) to securely extract data from on-premise databases and systems before loading it into Snowflake.